Completed Transactions in Inventory
inventoryCompletedTransactions Based on 26C
Look up Completed Transactions in Inventory, with lots and serials. Read-only.
- Operations
- GET (list)GET (one)
- Record key
TransactionId- Required on create
- no create on this resource
- At a glance
- 193 fields1 finders12 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactions?fields=Account,AlmInterfaceStatus,AssemblySerialNumber,AssessableValue,AssetTrackingStatus&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
Account | text | Searchable |
AlmInterfaceStatus | text · max 30 | Read-onlySearchable |
AssemblySerialNumber | text · max 80 | Read-onlySearchable |
AssessableValue | number | Read-onlySearchable |
AssetTrackingStatus | text | Read-onlySearchable |
AssociatedOwnershipChangeTransaction | number | Read-onlySearchable |
Carrier | text | Read-onlySearchable |
Category | text | Searchable |
CategoryId | number | Read-onlySearchable |
ConsErrorActionCode | text · max 30 | Read-onlySearchable |
ConsErrorTypeCode | text · max 30 | Read-onlySearchable |
ConsumptionAdvice | text | Read-onlySearchable |
ConsumptionAdviceError | text | |
ConsumptionAdviceErrorAction | text | Read-onlySearchable |
ConsumptionAdviceLine | text | Read-onlySearchable |
ConsumptionAdviceStatus | text | Read-only |
ConsumptionAdviceStatusCode | text | Read-onlySearchable |
ConsumptionLineId | number | Read-onlySearchable |
ContentLPNId | number | Read-onlySearchable |
ContentLPNNumber | text · max 255 | Read-only |
Costed | text | Searchable |
CostedStatusCode | text · max 1 · default N | Read-onlySearchable |
CountryOfOrigin | text · max 255 | Read-onlySearchable |
CountryOfOriginCode | text · max 255 | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
Currency | text · max 10 | Read-onlySearchable |
DefaultTaxationCountry | text · max 2 | Read-onlySearchable |
DepartmentCode | text · max 10 | Read-onlySearchable |
DepartmentId | number | Read-onlySearchable |
DistributionAccountId | number | Read-onlySearchable |
DocumentFiscalClassification | text | Searchable |
DocumentSubType | text · max 240 | Read-onlySearchable |
ElectronicSignature | number | Read-onlySearchable |
ErrorExplanation | text · max 240 | Read-onlySearchable |
ExecutionRunNumber | number | Read-onlySearchable |
ExemptReasonCode | text · max 30 | Read-onlySearchable |
ExternalSystemPackingUnit | text · max 150 | Read-onlySearchable |
ExternalSystemTransactionReference | text · max 300 | Read-onlySearchable |
FinalDischargeLocationId | number | Read-onlySearchable |
FirstPartyTaxRegistrationNumber | text | Searchable |
FirstPtyRegId | number | Read-onlySearchable |
FreightCode | text · max 30 | Read-onlySearchable |
IntegrationStatus | text · max 255 | Read-onlySearchable |
IntendedUse | text | Searchable |
IntendedUseClassifId | number | Read-onlySearchable |
InventoryItemId | number | Read-onlySearchable |
Item | text · max 300 | Read-onlySearchable |
ItemDescription | text · max 240 | Read-onlySearchable |
LPNId | number | Read-onlySearchable |
LPNNumber | text · max 255 | Read-onlySearchable |
LoadRequestId | number | Read-onlySearchable |
Location | text | Read-onlySearchable |
LocationOfFinalDischarge | text | Searchable |
LocationType | text · max 30 | Read-onlySearchable |
Locator | text | Searchable |
LocatorId | number | Read-onlySearchable |
Lot | text | Read-onlySearchable |
LotControlCode | number | Read-only |
LotTransactionGroupName | text · max 30 | Read-onlySearchable |
LotTransactionSource | text · max 255 | Read-onlySearchable |
ManualReceiptExpense | text · max 1 | Read-onlySearchable |
MaterialSequenceNumber | number | Read-onlySearchable |
MovementRequestLineId | number | Read-onlySearchable |
NumberOfContainers | number | Read-onlySearchable |
OperationNumber | text | |
OperationSequenceNumber | number | Read-onlySearchable |
OperationSequenceNumberId | number | Read-onlySearchable |
OperationTransaction | number | Read-onlySearchable |
Organization | text | Searchable |
OrganizationId | number | Read-onlySearchable |
OrganizationName | text | Searchable |
OwningOrganizationId | number | Read-onlySearchable |
OwningParty | text | Searchable |
OwningPartyLocation | text | Searchable |
OwningPartyLocationId | number | Searchable |
OwningPartyOrgName | text | Searchable |
OwningPartySite | text | Read-onlySearchable |
OwningPartyType | text | Read-onlySearchable |
OwningTpType | number | Read-onlySearchable |
PackingUnit | text · max 30 | Read-onlySearchable |
ParentTransaction | number | Read-onlySearchable |
PickSlip | number | Read-onlySearchable |
PjcProjectNumber | text · max 255 | Read-onlySearchable |
PjcTaskNumber | text · max 255 | Read-onlySearchable |
PrimaryUOMCode | text | Searchable |
ProductCategory | text | Searchable |
ProductCategoryCode | text · max 240 | Read-onlySearchable |
ProductFiscalClassification | text | Searchable |
ProductType | text | Searchable |
ProductTypeCode | text · max 240 | Read-onlySearchable |
ProjectId | number | Read-onlySearchable |
ProjectNumber | text · max 255 | Read-onlySearchable |
PurchaseOrder | text | Read-onlySearchable |
PurchaseOrderHeaderId | text | Read-onlySearchable |
PurchaseOrderLine | text | Read-onlySearchable |
PurchaseOrderLineId | text | Read-onlySearchable |
Quantity | number | Read-onlySearchable |
RcvShipmentHeaderId | number | Searchable |
RcvShipmentLineId | text | Searchable |
Reason | text | Searchable |
ReasonId | number | Read-onlySearchable |
Receipt | text | Searchable |
ReceiptLine | text · max 255 · default if (ReceivingTransaction!=null && RcvShipmentLineId!=null){ return ReceivingShipmentReceiptLinePVOVA?.first()?.getAttribute("LineNum"); } | Read-onlySearchable |
ReceiptRequiredAtExpenseDestination | text | Read-onlySearchable |
ReceivingTransaction | number | Read-onlySearchable |
Reference | text · max 240 | Read-onlySearchable |
ReferenceDesignator | text · max 15 | Read-onlySearchable |
RequesterId | number | Read-onlySearchable |
RequesterName | text | Searchable |
Revision | text · max 18 | Read-onlySearchable |
RfidEventActionId | number | Read-onlySearchable |
SecondaryQuantity | number | Read-onlySearchable |
SecondaryUOM | text · max 255 | Read-onlySearchable |
SecondaryUOMCode | text · max 3 | Read-onlySearchable |
SerialNumber | text | Read-onlySearchable |
SerialNumberControlCode | number | Read-only |
ShipFromLocationId | number | Read-onlySearchable |
ShipFromSite | text | Read-onlySearchable |
ShipToLocationId | number | Read-onlySearchable |
Shipment | text · max 30 | Read-onlySearchable |
Source | text · max 30 | Read-onlySearchable |
SourceLine | number | Read-onlySearchable |
SourceLotFlag | yes/no · max 3 | Read-onlySearchable |
SourceReference | text | Searchable |
StructureInstanceNumber | number | Searchable |
SubinventoryCode | text · max 10 | Read-onlySearchable |
SubinventoryId | number | Read-onlySearchable |
SubinventoryName | text · max 30 | Read-onlySearchable |
SupplierLot | text | Searchable |
TagCode | text · max 64 | Read-onlySearchable |
TaskId | number | Read-onlySearchable |
TaskNumber | text · max 255 | Read-onlySearchable |
TaxClassification | text · max 50 | Read-onlySearchable |
TaxClassificationCode | text | Searchable |
TaxExemptReasonCode | text | Searchable |
TaxExemptionCertificateNumber | text · max 80 | Read-onlySearchable |
TaxInvoiceDate | date | Read-onlySearchable |
TaxInvoiceNumber | text · max 150 | Read-onlySearchable |
TaxationCountry | text | Read-onlySearchable |
ThirdPartyTaxRegistrationNumber | text | Searchable |
ThirdPtyRegId | number | Read-onlySearchable |
TransactionAction | text | Searchable |
TransactionActionId | number | Read-onlySearchable |
TransactionBusinessCategory | text | Searchable |
TransactionDate | date-time | Read-onlySearchable |
TransactionId | number | Read-onlySearchable |
TransactionQuantity | number | Read-onlySearchable |
TransactionSet | number | Read-onlySearchable |
TransactionSourceId | number | Read-onlySearchable |
TransactionSourceName | text · max 120 | Read-onlySearchable |
TransactionSourceType | text | Searchable |
TransactionSourceTypeId | number | Read-onlySearchable |
TransactionType | text | Searchable |
TransactionTypeId | number | Read-onlySearchable |
TransactionUOM | text | Searchable |
TransactionUOMCode | text · max 3 | Read-onlySearchable |
TransferBusinessUnit | text | Read-onlySearchable |
TransferCost | number | Read-onlySearchable |
TransferLPNId | number | Read-onlySearchable |
TransferLPNNumber | text · max 255 | Read-onlySearchable |
TransferLocator | text | Read-onlySearchable |
TransferLocatorId | number | Read-onlySearchable |
TransferLocatorSIN | number | Read-only |
TransferOrgLocation | text | Read-onlySearchable |
TransferOrgLocationId | number | Searchable |
TransferOrganization | text | Searchable |
TransferOrganizationCode | text | Searchable |
TransferOrganizationId | number | Read-onlySearchable |
TransferOwningParty | text | Read-onlySearchable |
TransferOwningPartySite | text | Read-onlySearchable |
TransferOwningPartyType | text | Read-onlySearchable |
TransferOwningTpType | number | Read-onlySearchable |
TransferProjectId | number | Read-onlySearchable |
TransferProjectNumber | text · max 255 | Read-onlySearchable |
TransferSubinventory | text | Searchable |
TransferSubinventoryCode | text · max 10 | Read-onlySearchable |
TransferSubinventoryId | number | Read-only |
TransferSubinventoryName | text · max 30 | Read-onlySearchable |
TransferTaskId | number | Read-onlySearchable |
TransferTaskNumber | text · max 255 | Read-onlySearchable |
TransferTransaction | number | Read-onlySearchable |
TransportationCost | number | Read-onlySearchable |
TrxBusinessCategory | text · max 240 | Read-onlySearchable |
UOMName | text | Read-onlySearchable |
UserDefinedFiscClass | text · max 30 | Read-onlySearchable |
UserDefinedFiscalClassification | text | Searchable |
WIPSupplyType | text | Searchable |
WIPSupplyTypeCode | number | Read-onlySearchable |
Waybill | text · max 20 | Read-onlySearchable |
WorkCenter | text | Searchable |
WorkOrderExternalSystemGroupId | number | Read-onlySearchable |
XfrOwningOrganizationId | number | 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 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByPJCProjectTask·bindInventoryItemIdbindItembindOrganizationbindOrganizationIdbindPJCProjectIdbindPJCProjectNumberbindPJCTaskIdbindPJCTaskNumberbindTransactionDatebindTransactionId
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.
dFFsGET Flexfields for Completed Transactions · 3 fieldsTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotsGET Lots in Completed Transactions · 24 fieldsCreatedByCreationDateExpirationActionExpirationActionCodeExpirationActionDateGradeCodeHoldDateLotExpirationDateLotNumberMaturityDateOriginationDateOriginationTypeOriginationTypeCodeParentLotPrimaryQuantityReasonReasonIdReferenceDesignatorRetestDateSecondaryTransactionQuantityStatusStatusIdSupplierLotNumberTransactionQuantitylotAttributeDFFsGET Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotSerialsGET Serials in Lots in Completed Transactions · 8 fieldsCreatedByCreationDateLastUpdateDateLastUpdateLoginLastUpdatedByReferenceDesignatorSerialNumberSupplierSerialNumberserialAttributeDFFsGET Flexfields for Serial Attributes · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET Flexfields for Serials · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotStandardDFFsGET Flexfields for Lots · 4 fieldsLotNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValueprojectCostDFFsGET Flexfields for Project Costing · 3 fieldsTransactionId__FLEX_Context__FLEX_Context_DisplayValueserialsGET Serials in Lots in Completed Transactions · 8 fieldsCreatedByCreationDateLastUpdateDateLastUpdateLoginLastUpdatedByReferenceDesignatorSerialNumberSupplierSerialNumberserialAttributeDFFsGET Flexfields for Serial Attributes · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET Flexfields for Serials · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuetransactionAttachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserName
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactionsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByPJCProjectTaskfor 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:Account, notaccount. - 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.