// fusionrest agent · supply chain and manufacturing · inventory management

Inventory Item Lots

inventoryItemLots Based on 26C

Create, change and look up Inventory Item Lots, with supplier lot numbers. Actions include recommend lot transaction and recommendations for expiry lots.

The record key inventoryItemLotsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

/fscmRestApi/resources/11.13.18.05/inventoryItemLots
Operations
GET (list)GET (one)POST (create)PATCH (update)2 actions
Record key
inventoryItemLotsUniqID
Required on create
InventoryItemIdItemNumberOrganizationIdOrganizationName
At a glance
37 fields8 finders3 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/inventoryItemLots?fields=ActiveLot,ActiveLotCode,CreatedBy,CreationDate,Disabled&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ActiveLot": "<string, max 80>",
      "ActiveLotCode": "2",
      "CreatedBy": "<string, max 64>",
      "CreationDate": "2026-01-31T09:00:00+00:00",
      "Disabled": "<string>"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 37

AttributeTypeUse
ActiveLottext · max 80Optional on createUpdatableSearchable
ActiveLotCodetext · max 30 · default 2Optional on createUpdatableSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
DisabledtextOptional on createUpdatableSearchable
DisabledCodetext · max 1 · default NOptional on createUpdatableSearchable
DualUOMFlagyes/noOptional on createUpdatable
ElectronicRecordApprovalStatustext · max 80Optional on createUpdatableSearchable
ElectronicRecordIdnumberOptional on createUpdatableSearchable
ExpirationActiontext · max 80Optional on createUpdatableSearchable
ExpirationActionCodetext · max 32Optional on createUpdatableSearchable
ExpirationActionDatedate-timeOptional on createUpdatableSearchable
ExpirationDatedate-timeOptional on createUpdatableSearchable
Gradetext · max 150Optional on createUpdatableSearchable
GradeDescriptiontext · max 240Read-onlySearchable
HoldUntilDatedate-timeOptional on createUpdatableSearchable
InventoryItemIdnumberRequired on createSearchable
ItemDescriptiontext · max 240Read-onlySearchable
ItemNumbertext · max 300Required on createSearchable
ItemPrimaryImageURLtext · max 4000Read-onlySearchable
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
LotNumbertext · max 80Optional on createSearchable
LotStatusMeaningtext · max 255Read-onlySearchable
MaturityDatedate-timeOptional on createUpdatableSearchable
OrganizationCodetext · max 18Optional on createSearchable
OrganizationIdnumberRequired on createSearchable
OrganizationNametext · max 240Required on createSearchable
OriginationDatedate-timeOptional on createUpdatableSearchable
OriginationTypetext · max 80Optional on createSearchable
OriginationTypeCodetext · max 30 · default 0Optional on createSearchable
ParentLotNumbertext · max 80Optional on createSearchable
RetestDatedate-timeOptional on createUpdatableSearchable
StatusCodetext · max 80Optional on createUpdatableSearchable
StatusIdnumber · default 1Optional on createUpdatableSearchable
UniqueDeviceIdentifiertext · max 150Optional on createUpdatableSearchable
UpdateSourceCodetextOptional on createUpdatable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 8

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 3

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/inventoryItemLots/{inventoryItemLotsUniqID}/child/<name>. Add them to a GET with expand.

Actions 2

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls