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

Completed Transactions in Inventory

inventoryCompletedTransactions Based on 26C

Look up Completed Transactions in Inventory, with lots and serials. Read-only.

/fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactions
Operations
GET (list)GET (one)
Record key
TransactionId
Required on create
no create on this resource
At a glance
193 fields1 finders12 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactions?fields=Account,AlmInterfaceStatus,AssemblySerialNumber,AssessableValue,AssetTrackingStatus&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "Account": "<string>",
      "AlmInterfaceStatus": "<string, max 30>",
      "AssemblySerialNumber": "<string, max 80>",
      "AssessableValue": 0,
      "AssetTrackingStatus": "<string>"
    }
  ],
  "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 193

AttributeTypeUse
AccounttextSearchable
AlmInterfaceStatustext · max 30Read-onlySearchable
AssemblySerialNumbertext · max 80Read-onlySearchable
AssessableValuenumberRead-onlySearchable
AssetTrackingStatustextRead-onlySearchable
AssociatedOwnershipChangeTransactionnumberRead-onlySearchable
CarriertextRead-onlySearchable
CategorytextSearchable
CategoryIdnumberRead-onlySearchable
ConsErrorActionCodetext · max 30Read-onlySearchable
ConsErrorTypeCodetext · max 30Read-onlySearchable
ConsumptionAdvicetextRead-onlySearchable
ConsumptionAdviceErrortext
ConsumptionAdviceErrorActiontextRead-onlySearchable
ConsumptionAdviceLinetextRead-onlySearchable
ConsumptionAdviceStatustextRead-only
ConsumptionAdviceStatusCodetextRead-onlySearchable
ConsumptionLineIdnumberRead-onlySearchable
ContentLPNIdnumberRead-onlySearchable
ContentLPNNumbertext · max 255Read-only
CostedtextSearchable
CostedStatusCodetext · max 1 · default NRead-onlySearchable
CountryOfOrigintext · max 255Read-onlySearchable
CountryOfOriginCodetext · max 255Read-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
Currencytext · max 10Read-onlySearchable
DefaultTaxationCountrytext · max 2Read-onlySearchable
DepartmentCodetext · max 10Read-onlySearchable
DepartmentIdnumberRead-onlySearchable
DistributionAccountIdnumberRead-onlySearchable
DocumentFiscalClassificationtextSearchable
DocumentSubTypetext · max 240Read-onlySearchable
ElectronicSignaturenumberRead-onlySearchable
ErrorExplanationtext · max 240Read-onlySearchable
ExecutionRunNumbernumberRead-onlySearchable
ExemptReasonCodetext · max 30Read-onlySearchable
ExternalSystemPackingUnittext · max 150Read-onlySearchable
ExternalSystemTransactionReferencetext · max 300Read-onlySearchable
FinalDischargeLocationIdnumberRead-onlySearchable
FirstPartyTaxRegistrationNumbertextSearchable
FirstPtyRegIdnumberRead-onlySearchable
FreightCodetext · max 30Read-onlySearchable
IntegrationStatustext · max 255Read-onlySearchable
IntendedUsetextSearchable
IntendedUseClassifIdnumberRead-onlySearchable
InventoryItemIdnumberRead-onlySearchable
Itemtext · max 300Read-onlySearchable
ItemDescriptiontext · max 240Read-onlySearchable
LPNIdnumberRead-onlySearchable
LPNNumbertext · max 255Read-onlySearchable
LoadRequestIdnumberRead-onlySearchable
LocationtextRead-onlySearchable
LocationOfFinalDischargetextSearchable
LocationTypetext · max 30Read-onlySearchable
LocatortextSearchable
LocatorIdnumberRead-onlySearchable
LottextRead-onlySearchable
LotControlCodenumberRead-only
LotTransactionGroupNametext · max 30Read-onlySearchable
LotTransactionSourcetext · max 255Read-onlySearchable
ManualReceiptExpensetext · max 1Read-onlySearchable
MaterialSequenceNumbernumberRead-onlySearchable
MovementRequestLineIdnumberRead-onlySearchable
NumberOfContainersnumberRead-onlySearchable
OperationNumbertext
OperationSequenceNumbernumberRead-onlySearchable
OperationSequenceNumberIdnumberRead-onlySearchable
OperationTransactionnumberRead-onlySearchable
OrganizationtextSearchable
OrganizationIdnumberRead-onlySearchable
OrganizationNametextSearchable
OwningOrganizationIdnumberRead-onlySearchable
OwningPartytextSearchable
OwningPartyLocationtextSearchable
OwningPartyLocationIdnumberSearchable
OwningPartyOrgNametextSearchable
OwningPartySitetextRead-onlySearchable
OwningPartyTypetextRead-onlySearchable
OwningTpTypenumberRead-onlySearchable
PackingUnittext · max 30Read-onlySearchable
ParentTransactionnumberRead-onlySearchable
PickSlipnumberRead-onlySearchable
PjcProjectNumbertext · max 255Read-onlySearchable
PjcTaskNumbertext · max 255Read-onlySearchable
PrimaryUOMCodetextSearchable
ProductCategorytextSearchable
ProductCategoryCodetext · max 240Read-onlySearchable
ProductFiscalClassificationtextSearchable
ProductTypetextSearchable
ProductTypeCodetext · max 240Read-onlySearchable
ProjectIdnumberRead-onlySearchable
ProjectNumbertext · max 255Read-onlySearchable
PurchaseOrdertextRead-onlySearchable
PurchaseOrderHeaderIdtextRead-onlySearchable
PurchaseOrderLinetextRead-onlySearchable
PurchaseOrderLineIdtextRead-onlySearchable
QuantitynumberRead-onlySearchable
RcvShipmentHeaderIdnumberSearchable
RcvShipmentLineIdtextSearchable
ReasontextSearchable
ReasonIdnumberRead-onlySearchable
ReceipttextSearchable
ReceiptLinetext · max 255 · default if (ReceivingTransaction!=null && RcvShipmentLineId!=null){ return ReceivingShipmentReceiptLinePVOVA?.first()?.getAttribute("LineNum"); }Read-onlySearchable
ReceiptRequiredAtExpenseDestinationtextRead-onlySearchable
ReceivingTransactionnumberRead-onlySearchable
Referencetext · max 240Read-onlySearchable
ReferenceDesignatortext · max 15Read-onlySearchable
RequesterIdnumberRead-onlySearchable
RequesterNametextSearchable
Revisiontext · max 18Read-onlySearchable
RfidEventActionIdnumberRead-onlySearchable
SecondaryQuantitynumberRead-onlySearchable
SecondaryUOMtext · max 255Read-onlySearchable
SecondaryUOMCodetext · max 3Read-onlySearchable
SerialNumbertextRead-onlySearchable
SerialNumberControlCodenumberRead-only
ShipFromLocationIdnumberRead-onlySearchable
ShipFromSitetextRead-onlySearchable
ShipToLocationIdnumberRead-onlySearchable
Shipmenttext · max 30Read-onlySearchable
Sourcetext · max 30Read-onlySearchable
SourceLinenumberRead-onlySearchable
SourceLotFlagyes/no · max 3Read-onlySearchable
SourceReferencetextSearchable
StructureInstanceNumbernumberSearchable
SubinventoryCodetext · max 10Read-onlySearchable
SubinventoryIdnumberRead-onlySearchable
SubinventoryNametext · max 30Read-onlySearchable
SupplierLottextSearchable
TagCodetext · max 64Read-onlySearchable
TaskIdnumberRead-onlySearchable
TaskNumbertext · max 255Read-onlySearchable
TaxClassificationtext · max 50Read-onlySearchable
TaxClassificationCodetextSearchable
TaxExemptReasonCodetextSearchable
TaxExemptionCertificateNumbertext · max 80Read-onlySearchable
TaxInvoiceDatedateRead-onlySearchable
TaxInvoiceNumbertext · max 150Read-onlySearchable
TaxationCountrytextRead-onlySearchable
ThirdPartyTaxRegistrationNumbertextSearchable
ThirdPtyRegIdnumberRead-onlySearchable
TransactionActiontextSearchable
TransactionActionIdnumberRead-onlySearchable
TransactionBusinessCategorytextSearchable
TransactionDatedate-timeRead-onlySearchable
TransactionIdnumberRead-onlySearchable
TransactionQuantitynumberRead-onlySearchable
TransactionSetnumberRead-onlySearchable
TransactionSourceIdnumberRead-onlySearchable
TransactionSourceNametext · max 120Read-onlySearchable
TransactionSourceTypetextSearchable
TransactionSourceTypeIdnumberRead-onlySearchable
TransactionTypetextSearchable
TransactionTypeIdnumberRead-onlySearchable
TransactionUOMtextSearchable
TransactionUOMCodetext · max 3Read-onlySearchable
TransferBusinessUnittextRead-onlySearchable
TransferCostnumberRead-onlySearchable
TransferLPNIdnumberRead-onlySearchable
TransferLPNNumbertext · max 255Read-onlySearchable
TransferLocatortextRead-onlySearchable
TransferLocatorIdnumberRead-onlySearchable
TransferLocatorSINnumberRead-only
TransferOrgLocationtextRead-onlySearchable
TransferOrgLocationIdnumberSearchable
TransferOrganizationtextSearchable
TransferOrganizationCodetextSearchable
TransferOrganizationIdnumberRead-onlySearchable
TransferOwningPartytextRead-onlySearchable
TransferOwningPartySitetextRead-onlySearchable
TransferOwningPartyTypetextRead-onlySearchable
TransferOwningTpTypenumberRead-onlySearchable
TransferProjectIdnumberRead-onlySearchable
TransferProjectNumbertext · max 255Read-onlySearchable
TransferSubinventorytextSearchable
TransferSubinventoryCodetext · max 10Read-onlySearchable
TransferSubinventoryIdnumberRead-only
TransferSubinventoryNametext · max 30Read-onlySearchable
TransferTaskIdnumberRead-onlySearchable
TransferTaskNumbertext · max 255Read-onlySearchable
TransferTransactionnumberRead-onlySearchable
TransportationCostnumberRead-onlySearchable
TrxBusinessCategorytext · max 240Read-onlySearchable
UOMNametextRead-onlySearchable
UserDefinedFiscClasstext · max 30Read-onlySearchable
UserDefinedFiscalClassificationtextSearchable
WIPSupplyTypetextSearchable
WIPSupplyTypeCodenumberRead-onlySearchable
Waybilltext · max 20Read-onlySearchable
WorkCentertextSearchable
WorkOrderExternalSystemGroupIdnumberRead-onlySearchable
XfrOwningOrganizationIdnumberRead-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.

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/inventoryCompletedTransactions/{TransactionId}/child/<name>. Add them to a GET with expand.

Use in AI Agent Studio

More in For Builders.

Pitfalls