Inventory Pick Lines
inventoryPickLines Based on 26C
Look up Inventory Pick Lines, with movement request line. Read-only.
- Operations
- GET (list)GET (one)
- Record key
LineId- Required on create
- no create on this resource
- At a glance
- 43 fields1 finders4 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/inventoryPickLines?fields=CustomerId,CustomerName,DemandDocumentId,DemandDocumentLineId,DemandDocumentLineNumber&limit=25&onlyData=true
{
"items": [
{
"CustomerId": 0,
"CustomerName": "<string, max 360>",
"DemandDocumentId": 0,
"DemandDocumentLineId": 0,
"DemandDocumentLineNumber": "<string, max 150>"
}
],
"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 43
| Attribute | Type | Use |
|---|---|---|
CustomerId | number | Read-onlySearchable |
CustomerName | text · max 360 | Read-onlySearchable |
DemandDocumentId | number | Read-onlySearchable |
DemandDocumentLineId | number | Read-onlySearchable |
DemandDocumentLineNumber | text · max 150 | Read-onlySearchable |
DemandDocumentNumber | text · max 150 | Read-onlySearchable |
DemandDocumentType | text · max 80 | Read-onlySearchable |
DemandDocumentTypeId | number | Read-onlySearchable |
DemandProjectId | number | Read-onlySearchable |
DemandProjectNumber | text · max 25 | Read-onlySearchable |
DemandProjectTaskId | number | Read-onlySearchable |
DemandProjectTaskNumber | text · max 100 | Read-onlySearchable |
DueDate | date | Read-onlySearchable |
FromSubinventoryCode | text · max 10 | Read-onlySearchable |
FromSubinventoryName | text · max 30 | Read-onlySearchable |
HeaderId | number | Read-onlySearchable |
ItemId | number | Read-onlySearchable |
ItemNumber | text · max 300 | Read-onlySearchable |
ItemRestrictLocatorsCode | number | Read-only |
LineId | number | Read-onlySearchable |
MaterialSequenceNumber | number | Read-onlySearchable |
MoveOrderType | number | Read-onlySearchable |
OrganizationId | number | Read-onlySearchable |
OriginalItemId | number | Read-onlySearchable |
PickConfirmedQuantity | number | Read-onlySearchable |
PickLineCount | number | Read-onlySearchable |
PickQuantity | number | Read-onlySearchable |
PickStatus | text · max 80 | Read-onlySearchable |
PickStatusCode | text · max 30 | Read-onlySearchable |
QuantityDelivered | number | Read-onlySearchable |
RemainingShipShelfLifeDays | number | Read-only |
RequestedQuantity | number | Read-onlySearchable |
ReservationsExist | text · max 1 | Read-onlySearchable |
ReservationsExistFlag | yes/no · max 255 | Read-onlySearchable |
Revision | text · max 18 | Read-onlySearchable |
ToAccount | text · max 4000 | Read-onlySearchable |
ToAccountId | number | Read-onlySearchable |
ToSubinventoryCode | text · max 10 | Read-onlySearchable |
ToSubinventoryName | text · max 30 | Read-onlySearchable |
UOMCode | text · max 3 | Read-onlySearchable |
UOMName | text · max 25 | Read-onlySearchable |
WorkOrderOperationSequence | number | Read-onlySearchable |
WorkOrderProduct | text · max 300 | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByProjectTask·bindDemandProjectIdbindDemandTaskId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 4
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/inventoryPickLines/{LineId}/child/<name>. Add them to a GET with expand.
MovementRequestLineGET Movement Request Lines · 76 fields · 1 findersAllowWorkOrderOverpickFlagAvailableToTransactCreatedByCreationDateDestinationAccountDestinationAccountAliasDestinationAccountIdDestinationLocatorDestinationLocatorIdDestinationSubInventoryIdDestinationSubinventoryDestinationSubinventoryNameExternalSystemAllocatedQuantityExternalSystemCancelledQuantityExternalSystemGroupIdExternalSystemRequestedQuantityExternalSystemRequestedQuantityInPUOMFromSerialNumberGradeHeaderIdIntegrationStatusInventoryItemIdItemDescriptionItemNumberItemRevisionKanbanCardIdKanbanCardNumberLastUpdateDateLastUpdateLoginLastUpdatedByLineIdLineNumberLotNumberMaterialSequenceNumberOperationSequenceNumberOrderPrimaryUOMQuantityQuantityDeliveredQuantityDetailedReasonReasonIdReferenceReferenceSourceTypeReferenceTypeCodeRemainingShipShelfLifeDaysRequestedQuantityRequesterIdRequesterNameRequiredDateSecondaryQuantityDeliveredSecondaryQuantityDetailedSecondaryRequestedQuantitySecondaryUOMCodeSecondaryUOMNameShipToLocationShipToLocationIdSourceLocatorSourceLocatorIdSourceSubinventorySourceSubinventoryNameStatusStatusCodeStatusDateStructureInstanceNumberSubinventoryIdToSerialNumberTransactionSourceIdTransactionSourceLineIdTransactionSourceTypeIdTransactionTypeTransactionTypeIdTransferLocatorsSINUOMCodeUOMNameValidDestinationFlagWorkCenterCodeDFFGET Flexfields for Movement Request Lines · 3 fieldsLineId__FLEX_Context__FLEX_Context_DisplayValueinventoryStripingDFFGET Inventory Attribute Flexfields for Movement Request Lines · 9 fieldsLineId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_DisplayprojectDFFGET Project Flexfields for Movement Request Lines · 3 fieldsLineId__FLEX_Context__FLEX_Context_DisplayValue
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/inventoryPickLinesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByProjectTaskfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:CustomerId, notcustomerid. - Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.