Inventory Staged Transactions
inventoryStagedTransactions Based on 26C
Create, change, delete and look up Inventory Staged Transactions, with lot summaries, serial summaries and costs. Actions include delete by header and generate txn multiple lots.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE4 actions
- Record key
TransactionInterfaceId- Required on create
SourceCodeSourceHeaderIdSourceLineIdTransactionDateTransactionModeTransactionQuantityUseCurrentCostFlag- At a glance
- 142 fields0 finders17 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/inventoryStagedTransactions?fields=AccountAliasCombination,AccountCombination,AssessableValue,Carrier,CategoryId&limit=25&onlyData=true
{
"items": [
{
"AccountAliasCombination": "<string>",
"AccountCombination": "<string>",
"AssessableValue": 0,
"Carrier": "<string, max 255>",
"CategoryId": 0
}
],
"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 142
| Attribute | Type | Use |
|---|---|---|
AccountAliasCombination | text | Optional on createUpdatableSearchable |
AccountCombination | text | Optional on createUpdatableSearchable |
AssessableValue | number | Optional on createUpdatableSearchable |
Carrier | text · max 255 | Optional on createUpdatableSearchable |
CategoryId | number | Optional on createUpdatableSearchable |
CategoryName | text · max 250 | Optional on createUpdatableSearchable |
ChartOfAccountsId | number | Optional on createUpdatableSearchable |
ConsignmentAgreementNumber | text · max 30 | Optional on createUpdatableSearchable |
Containers | number | Optional on createUpdatableSearchable |
ContentLPNId | number | Optional on createUpdatableSearchable |
ContentLicensePlateNumber | text · max 255 | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyCode | text · max 30 | Optional on createUpdatableSearchable |
DefaultTaxationCountry | text · max 2 | Optional on createUpdatableSearchable |
DefaultingControl | text · max 30 | Read-onlySearchable |
DemandSourceDelivery | text · max 30 | Optional on createUpdatableSearchable |
DemandSourceHeaderId | number | Optional on createUpdatableSearchable |
DemandSourceLine | text · max 30 | Optional on createUpdatableSearchable |
DistributionAccountId | number | Optional on createUpdatableSearchable |
DocumentSubType | text · max 240 | Optional on createUpdatableSearchable |
ERecordId | number | Read-onlySearchable |
ErrorCode | text · max 240 | Optional on createUpdatableSearchable |
ErrorExplanation | text · max 240 | Optional on createUpdatableSearchable |
ExemptCertificateNumber | text · max 80 | Optional on createUpdatableSearchable |
ExemptReasonCode | text · max 30 | Optional on createUpdatableSearchable |
ExpectedArrivalDate | date | Optional on createUpdatableSearchable |
ExternalSystemPackingUnit | text · max 2000 | Optional on createUpdatableSearchable |
ExternalSystemTransactionReference | text · max 300 | Optional on createSearchable |
FinalDischargeLocCode | text · max 60 | Optional on createUpdatableSearchable |
FirstPtyNumber | text · max 30 | Optional on createUpdatableSearchable |
FreightCarrierId | number | Optional on createUpdatableSearchable |
IntendedUse | text · max 240 | Optional on createUpdatableSearchable |
InventoryItemId | number | Optional on createUpdatableSearchable |
ItemDescription | text · max 240 | Read-onlySearchable |
ItemNumber | text · max 255 | Optional on createUpdatableSearchable |
LPNId | number | Optional on createUpdatableSearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LicensePlateNumber | text · max 255 | Optional on createUpdatableSearchable |
LoadRequestId | number | Read-onlySearchable |
LocationType | text · max 30 | Optional on createUpdatableSearchable |
LocatorId | number | Optional on createUpdatableSearchable |
LocatorName | text · max 255 | Optional on createUpdatableSearchable |
LockStatus | text · max 30 | Optional on createUpdatableSearchable |
LotControlCode | number | Read-onlySearchable |
LotTransactionGroupName | text · max 30 | Optional on createUpdatableSearchable |
OrganizationId | number | Optional on createUpdatableSearchable |
OrganizationName | text · max 255 | Optional on createUpdatableSearchable |
OwningOrganizationId | number | Optional on createUpdatableSearchable |
OwningOrganizationName | text · max 240 | Optional on createUpdatableSearchable |
OwningTpType | text · max 30 | Optional on createUpdatableSearchable |
ParentId | number | Read-onlySearchable |
PrimaryQuantity | number | Optional on createUpdatableSearchable |
PrimaryUOMCode | text · max 3 | Read-onlySearchable |
ProcessId | number | Optional on createUpdatableSearchable |
ProcessStatus | text · max 30 · default 1 | Optional on createUpdatableSearchable |
ProcurementBusinessUnitName | text · max 240 | Optional on createUpdatableSearchable |
ProductCategory | text · max 240 | Optional on createUpdatableSearchable |
ProductType | text · max 240 | Optional on createUpdatableSearchable |
ReasonId | number | Optional on createUpdatableSearchable |
ReasonName | text · max 255 | Optional on createUpdatableSearchable |
ReceivingTransactionId | number | Optional on createUpdatableSearchable |
RepresentativeLotFlag | yes/no · max 80 | Optional on createUpdatableSearchable |
RequesterId | text · max 80 | Optional on createUpdatableSearchable |
RequesterName | text · max 240 | Optional on createUpdatableSearchable |
RequesterNumber | text · max 30 | Optional on createUpdatableSearchable |
Revision | text · max 18 | Optional on createUpdatableSearchable |
RevisionControlCode | number | Read-onlySearchable |
RfidEventActionId | number | Read-onlySearchable |
SecondaryInventoryName | text · max 10 | Read-onlySearchable |
SecondaryTransactionQuantity | number | Optional on createUpdatableSearchable |
SecondaryUOMCode | text · max 3 | Optional on createUpdatableSearchable |
SecondaryUnitOfMeasure | text · max 25 | Optional on createUpdatableSearchable |
SerialNumberControlCode | number | Read-onlySearchable |
ShipFromLocationId | number | Optional on createUpdatableSearchable |
ShipToLocationId | number | Optional on createUpdatableSearchable |
ShipmentNumber | text · max 30 | Optional on createUpdatableSearchable |
SourceCode | text · max 30 | Required on createUpdatableSearchable |
SourceHeaderId | number | Required on createUpdatableSearchable |
SourceLineId | number | Required on createUpdatableSearchable |
SourceLotFlag | yes/no · max 3 | Optional on createUpdatableSearchable |
StructureInstanceNumber | number | Read-onlySearchable |
SubinventoryCode | text · max 10 | Optional on createUpdatableSearchable |
SubinventoryId | number | Read-onlySearchable |
SubinventoryName | text · max 30 | Read-only |
TagCode | text · max 255 | Read-onlySearchable |
TaxClassificationCode | text · max 50 | Optional on createUpdatableSearchable |
TaxInvoiceDate | date | Optional on createUpdatableSearchable |
TaxInvoiceNumber | text · max 150 | Optional on createUpdatableSearchable |
ThirdPtyNumber | text · max 30 | Optional on createUpdatableSearchable |
TrackingUnitOfMeasure | text · max 30 | Read-onlySearchable |
TransactionActionId | text · max 30 | Optional on createUpdatableSearchable |
TransactionActionName | text · max 255 | Optional on createUpdatableSearchable |
TransactionBatchId | number | Optional on createUpdatableSearchable |
TransactionBatchSequence | number | Optional on createUpdatableSearchable |
TransactionCost | number | Optional on createUpdatableSearchable |
TransactionCostIdentifier | text · max 30 | Optional on createUpdatableSearchable |
TransactionDate | date-time | Required on createUpdatableSearchable |
TransactionGroupId | number | Optional on createUpdatableSearchable |
TransactionGroupSequence | number | Optional on createUpdatableSearchable |
TransactionHeaderId | number | Optional on createUpdatableSearchable |
TransactionInterfaceId | number | Optional on createUpdatableSearchable |
TransactionMode | text · max 30 | Required on createUpdatableSearchable |
TransactionQuantity | number | Required on createUpdatableSearchable |
TransactionReference | text · max 240 | Optional on createUpdatableSearchable |
TransactionSourceId | number | Optional on createUpdatableSearchable |
TransactionSourceName | text | Optional on createUpdatableSearchable |
TransactionSourceTypeId | number | Optional on createUpdatableSearchable |
TransactionSourceTypeName | text · max 255 | Optional on createUpdatableSearchable |
TransactionTypeId | number | Optional on createUpdatableSearchable |
TransactionTypeName | text · max 255 | Optional on createUpdatableSearchable |
TransactionUOM | text · max 3 | Optional on createUpdatableSearchable |
TransactionUnitOfMeasure | text · max 25 | Optional on createUpdatableSearchable |
TransferCost | number | Optional on createUpdatableSearchable |
TransferInvProject | text · max 255 | Optional on createUpdatableSearchable |
TransferInvTask | text · max 255 | Optional on createUpdatableSearchable |
TransferLPNId | number | Optional on createUpdatableSearchable |
TransferLicensePlateNumber | text · max 255 | Optional on createUpdatableSearchable |
TransferLocator | number | Optional on createUpdatableSearchable |
TransferLocatorName | text · max 255 | Optional on createUpdatableSearchable |
TransferLocatorsSIN | number | Read-onlySearchable |
TransferOrganization | number | Optional on createUpdatableSearchable |
TransferOrganizationName | text · max 240 | Optional on createUpdatableSearchable |
TransferOwningOrganizationId | number | Optional on createUpdatableSearchable |
TransferOwningOrganizationName | text · max 240 | Optional on createUpdatableSearchable |
TransferOwningTpType | text · max 30 | Optional on createUpdatableSearchable |
TransferProjectId | number | Optional on createUpdatableSearchable |
TransferSubInventoryId | number | Read-onlySearchable |
TransferSubinventory | text · max 10 | Optional on createUpdatableSearchable |
TransferSubinventoryName | text · max 30 | Read-only |
TransferTaskId | number | Optional on createUpdatableSearchable |
TransportationCost | number | Optional on createUpdatableSearchable |
TrxBusinessCategory | text · max 240 | Optional on createUpdatableSearchable |
TrxSourceDeliveryId | number | Optional on createUpdatableSearchable |
TrxSourceLineId | number | Optional on createUpdatableSearchable |
UseCurrentCostFlag | yes/no · max 1 | Required on createUpdatableSearchable |
UserDefinedFiscClass | text · max 30 | Optional on createUpdatableSearchable |
VendorName | text · max 240 | Optional on createUpdatableSearchable |
VendorNumber | text · max 30 | Optional on createUpdatableSearchable |
WaybillAirbill | text · max 20 | Optional 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 17
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/inventoryStagedTransactions/{TransactionInterfaceId}/child/<name>. Add them to a GET with expand.
LotSummariesGET Lot Summaries · 2 fieldsLotscountLotsquantitysumSerialSummariesGET Serial Summaries · 2 fieldsSerialscountSerialsquantitysumattachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamecostsGET · POST · PATCH · DELETE Costs · 2 fieldsCostCostComponentCodedFFsGET · POST · PATCH Flexfields for Inventory Staged Transactions · 3 fieldsTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotsGET · POST · PATCH · DELETE Lots · 37 fieldsErrorCodeExpirationActionCodeExpirationActionDateExpirationActionNameGradeCodeHoldDateLengthUOMNameLotExpirationDateLotLengthLotNumberLotThicknessLotVolumeLotWidthMaturityDateOriginationDateOriginationTypeParentLotNumberPrimaryQuantityProductCodeProductTransactionIdReasonCodeReasonIdReasonNameRetestDateSecondaryTransactionQuantitySerialTransactionTempIdSourceCodeSourceLineIdStatusCodeStatusIdSupplierLotNumberTerritoryShortNameTransactionInterfaceIdTransactionQuantityVendorNameVolumeUOMNameWidthUOMNameLotSerialSummariesGET Serial Summaries · 2 fieldsSerialscountSerialsquantitysumlotAttributeDFFsGET · POST · PATCH Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotSerialsGET · POST · PATCH · DELETE Lot Serials · 12 fieldsErrorCodeFmSerialNumberOriginationDateSerialQuantitySourceCodeSourceLineIdStatusCodeStatusIdStatusNameToSerialNumberTransactionInterfaceIdVendorSerialNumberserialAttributeDFFsGET · POST · PATCH Flexfields for Serial Attributes · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET · POST · PATCH Flexfields for Serials · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotStandardDFFsGET · POST · PATCH Flexfields for Lots · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueprojectCostingDFFsGET · POST · PATCH Project Cost DetailsFields depend on your pod's flexfield setup (check
/describe).serialsGET · POST · PATCH · DELETE Lot Serials · 12 fieldsErrorCodeFmSerialNumberOriginationDateSerialQuantitySourceCodeSourceLineIdStatusCodeStatusIdStatusNameToSerialNumberTransactionInterfaceIdVendorSerialNumberserialAttributeDFFsGET · POST · PATCH Flexfields for Serial Attributes · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET · POST · PATCH Flexfields for Serials · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuetrackingAttributesDFFGET · POST · PATCH Tracking Attributes · 9 fieldsTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_Display
Actions 4
POST …/action/deleteByHeader·interfaceIddeleteCostheaderIdPOST …/action/generateTxnMultipleLots·organizationIdinventoryItemIditemNumbertxnInterfaceIdlotQuantityorganizationCodereasonIdparentLotNumbersupplierLotNumbergenerateSerialsnumberOfLotslotUOMPOST …/action/performBulkAction·errorExplanationpjcProjectIderrorCodetransactionIdListorganizationIdpjcTaskIdactionitemDescriptionexternalSystemPackingUnittransactionFromDatecountryOfOriginCodelotTxnGroupNametransactionHeaderIdtransactionTypeIdtransferTaskIdtransactionStatustransferProjectIdsubinventoryCodetransactionSourceIdcreationDatetransactionSourceTypeIdexternalSysTxnReferenceinventoryItemIdprocessFlagloadRequestIdtransactionToDateitemKeywordcreatedBylocatorIdprojectIdtaskIdstatusPOST …/action/processByHeader·transferOrganizationIdtransactionActionIdtransferLocatorNametoProjectIdheaderIdnoOfPackingUnitstransferLpnIdexpectedArrivalDatereasonIdprocessTypedistributionAccountIdtrackingNumbershipmentNumbertransferOrganizationNamereasonNametransactionSourceNametransactionTypeIdlotGradetoTaskIddispositionIdtransactionDatetransactionTypeNametransactionSourceTypeIdtransferLocatorIdtransferSubinventoryeresEnabledcarrierId
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/inventoryStagedTransactionsand 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:AccountAliasCombination, notaccountaliascombination. - 24 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.