Picks
inventoryPicks Based on 26C
Create, change, delete and look up Picks, with inv validated inventory transaction lots, inv validated inventory transaction serials and inv validated lots summary.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE
- Record key
TransactionTempId- Required on create
InventoryItemIdOrganizationIdSubinventoryCodeTransactionSourceTypeIdTransactionTypeIdUOM- At a glance
- 75 fields0 finders16 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/inventoryPicks?fields=AllowedUnitsLookupCode,AttachmentEntityName,ContentLPNId,ContentLicensePlateNumber,DemandClass&limit=25&onlyData=true
{
"items": [
{
"AllowedUnitsLookupCode": "<string, max 30>",
"AttachmentEntityName": "<string, max 255>",
"ContentLPNId": 0,
"ContentLicensePlateNumber": "<string, max 255>",
"DemandClass": "<string, max 30>"
}
],
"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 75
| Attribute | Type | Use |
|---|---|---|
AllowedUnitsLookupCode | text · max 30 | Read-onlySearchable |
AttachmentEntityName | text · max 255 | Optional on createUpdatable |
ContentLPNId | number | Optional on createUpdatableSearchable |
ContentLicensePlateNumber | text · max 255 | Read-onlySearchable |
DemandClass | text · max 30 | Read-onlySearchable |
DemandId | number | Read-onlySearchable |
DemandSourceDelivery | text · max 30 | Optional on createUpdatableSearchable |
DemandSourceHeaderId | number | Read-onlySearchable |
DemandSourceLine | text · max 30 | Read-onlySearchable |
InventoryItemId | number | Required on createUpdatableSearchable |
ItemDescription | text · max 240 | Optional on createUpdatableSearchable |
ItemInventoryAssetFlag | yes/no · max 1 | Read-onlySearchable |
ItemLocationControlCode | text · max 30 | Read-onlySearchable |
ItemLotControlCode | text · max 30 | Read-onlySearchable |
ItemNumber | text | Optional on createUpdatable |
ItemPrimaryUOM | text · max 3 | Read-onlySearchable |
ItemRestrictLocatorsCode | text · max 30 | Read-onlySearchable |
ItemRestrictSubinventoryCode | text · max 30 | Read-onlySearchable |
ItemRevisionQuantityControlCode | text · max 30 | Read-onlySearchable |
ItemSerialControlCode | text · max 30 | Read-onlySearchable |
ItemShelfLifeCode | text · max 30 | Read-onlySearchable |
ItemShelfLifeDays | number | Read-onlySearchable |
ItemTrxEnabledFlag | yes/no · max 1 | Read-onlySearchable |
LPNId | number | Optional on createUpdatableSearchable |
LicensePlateNumber | text · max 255 | Read-only |
LocatorId | number | Optional on createUpdatableSearchable |
LocatorName | text · max 255 | Read-onlySearchable |
MoveOrderHeaderId | number | Optional on createUpdatableSearchable |
MoveOrderLineId | number | Optional on createUpdatableSearchable |
ObjectVersionNumber | number | Read-onlySearchable |
OrganizationId | number | Required on createUpdatableSearchable |
OrigTransactionQuantity | number | Read-onlySearchable |
PickSlipDate | date-time | Read-onlySearchable |
PickSlipLineNumber | number | Read-onlySearchable |
PickSlipNumber | number | Read-onlySearchable |
PickStrategyId | number | Read-onlySearchable |
PickedQuantity | number | Read-onlySearchable |
PickingLineId | number | Read-onlySearchable |
PostingFlag | yes/no · max 1 · default true | Read-onlySearchable |
PrimaryQuantity | number | Optional on createUpdatableSearchable |
RelieveReservationsFlag | yes/no · max 1 | Read-onlySearchable |
ReservationId | number | Read-onlySearchable |
ReservationQuantity | number | Read-onlySearchable |
Revision | text · max 18 | Optional on createUpdatableSearchable |
SecondaryTransactionQuantity | number | Optional on createUpdatableSearchable |
SecondaryUOM | text · max 3 | Optional on createUpdatableSearchable |
StructureInstanceNumber | number | Read-only |
SubinventoryCode | text · max 10 | Required on createUpdatableSearchable |
SubinventoryId | number | Read-only |
SubinventoryName | text · max 30 | Read-only |
TransactionActionId | text · max 30 | Read-onlySearchable |
TransactionBatchId | number | Read-onlySearchable |
TransactionBatchSequence | number | Read-onlySearchable |
TransactionDate | date-time | Read-onlySearchable |
TransactionHeaderId | number | Read-onlySearchable |
TransactionLineNumber | number | Read-onlySearchable |
TransactionMode | text · max 30 | Read-onlySearchable |
TransactionQuantity | number | Optional on createUpdatableSearchable |
TransactionReference | text · max 240 | Read-onlySearchable |
TransactionSequenceId | number | Read-onlySearchable |
TransactionSourceId | number | Read-onlySearchable |
TransactionSourceName | text · max 120 | Read-onlySearchable |
TransactionSourceTypeId | number | Required on createUpdatableSearchable |
TransactionStatus | text · max 30 | Read-onlySearchable |
TransactionTempId | number | Read-onlySearchable |
TransactionTypeId | number | Required on createUpdatableSearchable |
TransactionTypeName | text | Read-only |
TransferLPNId | number | Optional on createUpdatableSearchable |
TransferLicensePlateNumber | text · max 255 | Read-onlySearchable |
TransferOrganization | number | Read-onlySearchable |
TransferSubinventory | text · max 10 | Optional on createUpdatableSearchable |
TransferSubinventoryName | text · max 255 | Read-only |
TransferToLocation | number | Optional on createUpdatableSearchable |
TrxSourceLineId | number | Read-onlySearchable |
UOM | text · max 3 | Required on createUpdatableSearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 16
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/inventoryPicks/{TransactionTempId}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameDFFGET · POST · PATCH · DELETE Flexfields for Picks · 3 fieldsTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueInvStrippingDFFGET · POST · PATCH · DELETE Tracking Attributes · 9 fieldsTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_DisplayInvValidatedInventoryTransactionLotsGET · POST · PATCH · DELETE Lots · 33 fieldsCreatedByCreationDateDeleteOperationFlagErrorCodeExpirationActionCodeExpirationActionDateGradeCodeHoldDateLastUpdateDateLastUpdateLoginLastUpdatedByLotExpirationDateLotLengthLotNumberLotThicknessLotVolumeLotWidthMaturityDateOriginationDateOriginationTypePrimaryQuantityProductCodeProductTransactionIdReasonCodeReasonIdSecondaryQuantitySecondaryUnitOfMeasureSerialTransactionTempIdStatusIdSupplierLotNumberTransactionQuantityTransactionTempIdVendorNameLotSerialSummariesGET · POST · PATCH · DELETE Serial Summaries · 2 fieldsSerialCountSerialQuantitySumlotAttributeDFFsGET · POST · PATCH · DELETE Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuelotSerialsGET · POST · PATCH · DELETE Flexfields for Validated Transactions · 14 fieldsCreatedByCreationDateDeleteOperationFlagErrorCodeFmSerialNumberLastUpdateDateLastUpdateLoginLastUpdatedByOriginationDateQuantityStatusIdToSerialNumberTransactionTempIdVendorSerialNumberserialAttributeDFFsGET · POST · PATCH · DELETE Flexfields for Serial Attributes · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET · POST · PATCH · DELETE Flexfields for Serials · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValuelotStandardDFFsGET · POST · PATCH · DELETE Flexfields for Lots · 4 fieldsLotNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueInvValidatedInventoryTransactionSerialsGET · POST · PATCH · DELETE Flexfields for Validated Transactions · 14 fieldsCreatedByCreationDateDeleteOperationFlagErrorCodeFmSerialNumberLastUpdateDateLastUpdateLoginLastUpdatedByOriginationDateQuantityStatusIdToSerialNumberTransactionTempIdVendorSerialNumberserialAttributeDFFsGET · POST · PATCH · DELETE Flexfields for Serial Attributes · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET · POST · PATCH · DELETE Flexfields for Serials · 4 fieldsFmSerialNumberTransactionTempId__FLEX_Context__FLEX_Context_DisplayValueInvValidatedLotsSummaryGET · POST · PATCH · DELETE Lot Summaries · 2 fieldsLotsCountLotsQuantitySumInvValidatedSerialsSummaryGET · POST · PATCH · DELETE Serial Summaries · 2 fieldsSerialCountSerialQuantitySumPJCDFFGET · POST · PATCH · DELETE Project Cost DetailsFields 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/inventoryPicksand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - 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.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AttachmentEntityName, notattachmententityname. - 52 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- 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. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.