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

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.

/fscmRestApi/resources/11.13.18.05/inventoryStagedTransactions
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
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.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/inventoryStagedTransactions?fields=AccountAliasCombination,AccountCombination,AssessableValue,Carrier,CategoryId&limit=25&onlyData=true
Response shape (placeholders)
{
  "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

AttributeTypeUse
AccountAliasCombinationtextOptional on createUpdatableSearchable
AccountCombinationtextOptional on createUpdatableSearchable
AssessableValuenumberOptional on createUpdatableSearchable
Carriertext · max 255Optional on createUpdatableSearchable
CategoryIdnumberOptional on createUpdatableSearchable
CategoryNametext · max 250Optional on createUpdatableSearchable
ChartOfAccountsIdnumberOptional on createUpdatableSearchable
ConsignmentAgreementNumbertext · max 30Optional on createUpdatableSearchable
ContainersnumberOptional on createUpdatableSearchable
ContentLPNIdnumberOptional on createUpdatableSearchable
ContentLicensePlateNumbertext · max 255Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CurrencyCodetext · max 30Optional on createUpdatableSearchable
DefaultTaxationCountrytext · max 2Optional on createUpdatableSearchable
DefaultingControltext · max 30Read-onlySearchable
DemandSourceDeliverytext · max 30Optional on createUpdatableSearchable
DemandSourceHeaderIdnumberOptional on createUpdatableSearchable
DemandSourceLinetext · max 30Optional on createUpdatableSearchable
DistributionAccountIdnumberOptional on createUpdatableSearchable
DocumentSubTypetext · max 240Optional on createUpdatableSearchable
ERecordIdnumberRead-onlySearchable
ErrorCodetext · max 240Optional on createUpdatableSearchable
ErrorExplanationtext · max 240Optional on createUpdatableSearchable
ExemptCertificateNumbertext · max 80Optional on createUpdatableSearchable
ExemptReasonCodetext · max 30Optional on createUpdatableSearchable
ExpectedArrivalDatedateOptional on createUpdatableSearchable
ExternalSystemPackingUnittext · max 2000Optional on createUpdatableSearchable
ExternalSystemTransactionReferencetext · max 300Optional on createSearchable
FinalDischargeLocCodetext · max 60Optional on createUpdatableSearchable
FirstPtyNumbertext · max 30Optional on createUpdatableSearchable
FreightCarrierIdnumberOptional on createUpdatableSearchable
IntendedUsetext · max 240Optional on createUpdatableSearchable
InventoryItemIdnumberOptional on createUpdatableSearchable
ItemDescriptiontext · max 240Read-onlySearchable
ItemNumbertext · max 255Optional on createUpdatableSearchable
LPNIdnumberOptional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LicensePlateNumbertext · max 255Optional on createUpdatableSearchable
LoadRequestIdnumberRead-onlySearchable
LocationTypetext · max 30Optional on createUpdatableSearchable
LocatorIdnumberOptional on createUpdatableSearchable
LocatorNametext · max 255Optional on createUpdatableSearchable
LockStatustext · max 30Optional on createUpdatableSearchable
LotControlCodenumberRead-onlySearchable
LotTransactionGroupNametext · max 30Optional on createUpdatableSearchable
OrganizationIdnumberOptional on createUpdatableSearchable
OrganizationNametext · max 255Optional on createUpdatableSearchable
OwningOrganizationIdnumberOptional on createUpdatableSearchable
OwningOrganizationNametext · max 240Optional on createUpdatableSearchable
OwningTpTypetext · max 30Optional on createUpdatableSearchable
ParentIdnumberRead-onlySearchable
PrimaryQuantitynumberOptional on createUpdatableSearchable
PrimaryUOMCodetext · max 3Read-onlySearchable
ProcessIdnumberOptional on createUpdatableSearchable
ProcessStatustext · max 30 · default 1Optional on createUpdatableSearchable
ProcurementBusinessUnitNametext · max 240Optional on createUpdatableSearchable
ProductCategorytext · max 240Optional on createUpdatableSearchable
ProductTypetext · max 240Optional on createUpdatableSearchable
ReasonIdnumberOptional on createUpdatableSearchable
ReasonNametext · max 255Optional on createUpdatableSearchable
ReceivingTransactionIdnumberOptional on createUpdatableSearchable
RepresentativeLotFlagyes/no · max 80Optional on createUpdatableSearchable
RequesterIdtext · max 80Optional on createUpdatableSearchable
RequesterNametext · max 240Optional on createUpdatableSearchable
RequesterNumbertext · max 30Optional on createUpdatableSearchable
Revisiontext · max 18Optional on createUpdatableSearchable
RevisionControlCodenumberRead-onlySearchable
RfidEventActionIdnumberRead-onlySearchable
SecondaryInventoryNametext · max 10Read-onlySearchable
SecondaryTransactionQuantitynumberOptional on createUpdatableSearchable
SecondaryUOMCodetext · max 3Optional on createUpdatableSearchable
SecondaryUnitOfMeasuretext · max 25Optional on createUpdatableSearchable
SerialNumberControlCodenumberRead-onlySearchable
ShipFromLocationIdnumberOptional on createUpdatableSearchable
ShipToLocationIdnumberOptional on createUpdatableSearchable
ShipmentNumbertext · max 30Optional on createUpdatableSearchable
SourceCodetext · max 30Required on createUpdatableSearchable
SourceHeaderIdnumberRequired on createUpdatableSearchable
SourceLineIdnumberRequired on createUpdatableSearchable
SourceLotFlagyes/no · max 3Optional on createUpdatableSearchable
StructureInstanceNumbernumberRead-onlySearchable
SubinventoryCodetext · max 10Optional on createUpdatableSearchable
SubinventoryIdnumberRead-onlySearchable
SubinventoryNametext · max 30Read-only
TagCodetext · max 255Read-onlySearchable
TaxClassificationCodetext · max 50Optional on createUpdatableSearchable
TaxInvoiceDatedateOptional on createUpdatableSearchable
TaxInvoiceNumbertext · max 150Optional on createUpdatableSearchable
ThirdPtyNumbertext · max 30Optional on createUpdatableSearchable
TrackingUnitOfMeasuretext · max 30Read-onlySearchable
TransactionActionIdtext · max 30Optional on createUpdatableSearchable
TransactionActionNametext · max 255Optional on createUpdatableSearchable
TransactionBatchIdnumberOptional on createUpdatableSearchable
TransactionBatchSequencenumberOptional on createUpdatableSearchable
TransactionCostnumberOptional on createUpdatableSearchable
TransactionCostIdentifiertext · max 30Optional on createUpdatableSearchable
TransactionDatedate-timeRequired on createUpdatableSearchable
TransactionGroupIdnumberOptional on createUpdatableSearchable
TransactionGroupSequencenumberOptional on createUpdatableSearchable
TransactionHeaderIdnumberOptional on createUpdatableSearchable
TransactionInterfaceIdnumberOptional on createUpdatableSearchable
TransactionModetext · max 30Required on createUpdatableSearchable
TransactionQuantitynumberRequired on createUpdatableSearchable
TransactionReferencetext · max 240Optional on createUpdatableSearchable
TransactionSourceIdnumberOptional on createUpdatableSearchable
TransactionSourceNametextOptional on createUpdatableSearchable
TransactionSourceTypeIdnumberOptional on createUpdatableSearchable
TransactionSourceTypeNametext · max 255Optional on createUpdatableSearchable
TransactionTypeIdnumberOptional on createUpdatableSearchable
TransactionTypeNametext · max 255Optional on createUpdatableSearchable
TransactionUOMtext · max 3Optional on createUpdatableSearchable
TransactionUnitOfMeasuretext · max 25Optional on createUpdatableSearchable
TransferCostnumberOptional on createUpdatableSearchable
TransferInvProjecttext · max 255Optional on createUpdatableSearchable
TransferInvTasktext · max 255Optional on createUpdatableSearchable
TransferLPNIdnumberOptional on createUpdatableSearchable
TransferLicensePlateNumbertext · max 255Optional on createUpdatableSearchable
TransferLocatornumberOptional on createUpdatableSearchable
TransferLocatorNametext · max 255Optional on createUpdatableSearchable
TransferLocatorsSINnumberRead-onlySearchable
TransferOrganizationnumberOptional on createUpdatableSearchable
TransferOrganizationNametext · max 240Optional on createUpdatableSearchable
TransferOwningOrganizationIdnumberOptional on createUpdatableSearchable
TransferOwningOrganizationNametext · max 240Optional on createUpdatableSearchable
TransferOwningTpTypetext · max 30Optional on createUpdatableSearchable
TransferProjectIdnumberOptional on createUpdatableSearchable
TransferSubInventoryIdnumberRead-onlySearchable
TransferSubinventorytext · max 10Optional on createUpdatableSearchable
TransferSubinventoryNametext · max 30Read-only
TransferTaskIdnumberOptional on createUpdatableSearchable
TransportationCostnumberOptional on createUpdatableSearchable
TrxBusinessCategorytext · max 240Optional on createUpdatableSearchable
TrxSourceDeliveryIdnumberOptional on createUpdatableSearchable
TrxSourceLineIdnumberOptional on createUpdatableSearchable
UseCurrentCostFlagyes/no · max 1Required on createUpdatableSearchable
UserDefinedFiscClasstext · max 30Optional on createUpdatableSearchable
VendorNametext · max 240Optional on createUpdatableSearchable
VendorNumbertext · max 30Optional on createUpdatableSearchable
WaybillAirbilltext · max 20Optional 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.

Actions 4

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