Open Pick Lines
openPickLines Based on 26C
Look up Open Pick Lines, with item lots and item serials. Read-only.
- Operations
- GET (list)GET (one)
- Record key
TransactionId- Required on create
- no create on this resource
- At a glance
- 82 fields8 finders12 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/openPickLines?fields=AllowUseOfCommonSuppliesFlag,AllowWorkOrderOverpickFlag,ContentLPNId,ContentLicensePlateNumber,CreatedBy&limit=25&onlyData=true
{
"items": [
{
"AllowUseOfCommonSuppliesFlag": false,
"AllowWorkOrderOverpickFlag": false,
"ContentLPNId": 0,
"ContentLicensePlateNumber": "<string, max 255>",
"CreatedBy": "<string, max 64>"
}
],
"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 82
| Attribute | Type | Use |
|---|---|---|
AllowUseOfCommonSuppliesFlag | yes/no · max 1 | Searchable |
AllowWorkOrderOverpickFlag | yes/no · max 1 | Searchable |
ContentLPNId | number | Searchable |
ContentLicensePlateNumber | text · max 255 | Read-onlySearchable |
CreatedBy | text · max 64 | Read-only |
CreationDate | date-time | Read-onlySearchable |
Customer | text · max 360 | Read-onlySearchable |
DestinationAccount | text · max 4000 | Searchable |
DestinationLocationName | text · max 80 | Read-onlySearchable |
DestinationLocator | text · max 4000 | Read-onlySearchable |
DestinationLocatorId | number | Searchable |
DestinationStructureInstanceNumber | number | Searchable |
DestinationSubinventory | text · max 10 | Read-onlySearchable |
DestinationSubinventoryId | number | Searchable |
DestinationSubinventoryName | text · max 30 | Searchable |
DueDate | date | Read-onlySearchable |
FromLPNId | number | Searchable |
FromLicensePlateNumber | text · max 255 | Read-only |
InventoryItemId | number | Searchable |
Item | text · max 300 | Read-onlySearchable |
ItemDescription | text · max 240 | Searchable |
ItemPrimaryImageURL | text · max 4000 | Searchable |
KanbanCardNumber | text · max 255 | Read-onlySearchable |
LPNEnabledFlag | yes/no · max 4000 | Searchable |
LastUpdateDate | date-time | Read-only |
LastUpdatedBy | text · max 64 | Read-only |
LotControlCode | number | Searchable |
LotQuantityAllocated | number | Read-only |
MaterialSequence | number | Searchable |
MaximumAllowedQuantity | number | Read-only |
MovementRequest | text · max 30 | Searchable |
MovementRequestLine | number | Searchable |
OperationSequence | number | Searchable |
Order | text · max 150 | Read-onlySearchable |
OrderDestSub | text · max 10 | Read-onlySearchable |
OrderDestSubName | text · max 30 | Searchable |
OrderLineNumber | text · max 600 | Read-onlySearchable |
Organization | text · max 18 | Searchable |
PackingStringId | number | Searchable |
PackingUnit | text · max 30 | Searchable |
PickSlip | number | Read-onlySearchable |
PickSlipLine | number | Read-onlySearchable |
PickSlipType | text · max 80 | Searchable |
PickWave | number | Read-onlySearchable |
PickedQuantity | number | Searchable |
PrepackLPNId | number | Searchable |
PrepackLicensePlateNumber | text · max 255 | Read-onlySearchable |
PrimaryRequestedQuantity | number | Read-onlySearchable |
PrimaryUOMCode | text · max 3 | Read-onlySearchable |
RemainingShipShelfLifeDays | number | Searchable |
RequestedQuantity | number | Read-onlySearchable |
RequiredDate | date | Read-onlySearchable |
Revision | text · max 18 | Read-onlySearchable |
RevisionControlCode | number | Searchable |
SecondaryDefaultInd | text · max 30 | Searchable |
SecondaryPickedQuantity | number | Searchable |
SecondaryRequestedQuantity | number | Read-onlySearchable |
SecondaryUOM | text · max 25 | Read-onlySearchable |
SerialNumberControlCode | number | Searchable |
SerialQuantityAllocated | number | Read-only |
ShipToLocation | text | Read-onlySearchable |
Shipment | text · max 30 | Searchable |
ShippingMethod | text · max 2082 | Searchable |
ShippingPriority | text · max 80 | Read-onlySearchable |
SourceLocator | text · max 4000 | Searchable |
SourceLocatorId | number | Read-onlySearchable |
SourceOrder | text · max 150 | Read-onlySearchable |
SourceOrderLine | text · max 600 | Read-onlySearchable |
SourceStructureInstanceNumber | number | Searchable |
SourceSubinventory | text · max 10 | Searchable |
SourceSubinventoryId | number | Searchable |
SourceSubinventoryName | text · max 30 | Searchable |
SplitLineFlag | yes/no · max 1 | Searchable |
ToLPNId | number | Searchable |
ToLicensePlateNumber | text · max 255 | Read-onlySearchable |
TrackingQuantityInd | text · max 30 | Searchable |
TransactionDate | date-time | Read-only |
TransactionId | number | Read-onlySearchable |
TransactionType | text · max 80 | Read-onlySearchable |
TransactionTypeId | number | Read-onlySearchable |
TransactionUOMCode | text · max 3 | Searchable |
UOM | text · max 25 | 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 8
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByMovementRequest·pMovementRequestfindByOrderNumber·pOrderfindByOrganization·pOrganizationpOrganizationIdfindByOrganizationAndItem·pItempOrganizationpOrganizationIdfindByOrganizationAndSourceSubinventory·pOrganizationpOrganizationIdpSourceSubinventoryfindByPickSlip·pPickSlipfindByPickWave·pPickWavefindByTransactionType·pTransactionType
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 12
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/openPickLines/{TransactionId}/child/<name>. Add them to a GET with expand.
DFFsGET Flexfields for Pick Lines · 3 fieldsTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueinventoryAttributesDFFsGET Flexfields for Inventory Attributes · 9 fieldsTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_DisplayitemLotsGET Lot Details · 6 fieldsLotLotExpirationDateLotMaturityDateLotOriginationDateQuantitySecondaryQuantityitemLotSerialsGET Serial Details for Lots · 3 fieldsFromSerialNumberSerialQuantityToSerialNumberlotSerialAttributeDFFsGET Flexfields for Serial Attributes · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuelotSerialStandardDFFsGET Flexfields for Serials · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuelotAttributeDFFsGET Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuelotStandardDFFsGET Flexfields for Lots · 4 fieldsLotNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueitemSerialsGET Serial Details · 3 fieldsFromSerialNumberSerialQuantityToSerialNumberserialAttributeDFFsGET Flexfields for Serial Attributes · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET Flexfields for Serials · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueprojectCostDFFsGET Flexfields for Project CostsFields depend on your pod's flexfield setup (check
/describe).
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/openPickLinesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByMovementRequestfor 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:AllowUseOfCommonSuppliesFlag, notallowuseofcommonsuppliesflag. - 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.