Receiving Transactions History
receivingTransactionsHistory Based on 26C
Look up Receiving Transactions History, 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
- 152 fields1 finders14 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/receivingTransactionsHistory?fields=AccrualStatusCode,Amount,AmountBilled,AssessableValue,BackToBackFlag&limit=25&onlyData=true
{
"items": [
{
"AccrualStatusCode": "<string, max 25>",
"Amount": 0,
"AmountBilled": 0,
"AssessableValue": 0,
"BackToBackFlag": false
}
],
"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 152
| Attribute | Type | Use |
|---|---|---|
AccrualStatusCode | text · max 25 | Read-onlySearchable |
Amount | number | Read-onlySearchable |
AmountBilled | number | Read-onlySearchable |
AssessableValue | number | Read-onlySearchable |
BackToBackFlag | yes/no · max 1 | Read-onlySearchable |
BillingUOMCode | text · max 3 | Read-onlySearchable |
BillingUnitOfMeasure | text · max 25 | Read-onlySearchable |
BusinessEventPublishedFlag | yes/no · max 1 | Read-onlySearchable |
Comments | text · max 240 | Read-onlySearchable |
ConsignedFlag | yes/no · max 1 | Read-onlySearchable |
CountryOfOriginCode | text · max 2 | Read-onlySearchable |
CreatedBy | text · max 255 | Read-only |
CreationDate | date-time | Read-only |
CrossdockOrderLineNumber | text · max 150 | Read-only |
CrossdockOrderNumber | text · max 150 | Read-only |
CrossdockOrderType | text · max 80 | Read-only |
CrossdockOrderTypeCode | text · max 30 | Read-only |
CurrencyCode | text · max 15 | Read-onlySearchable |
CurrencyConversionDate | date | Read-onlySearchable |
CurrencyConversionRate | number | Read-onlySearchable |
CurrencyConversionType | text · max 30 | Read-onlySearchable |
CurrencyName | text · max 80 | Read-onlySearchable |
CustomerId | number | Read-onlySearchable |
CustomerName | text · max 360 | Read-onlySearchable |
DefaultTaxationCountryCode | text · max 2 | Read-onlySearchable |
DeliverToLocationId | number | Read-onlySearchable |
DeliverToLocationName | text · max 240 | Read-onlySearchable |
DeliverToPersonId | number | Read-onlySearchable |
DeliverToPersonName | text · max 2000 | Read-onlySearchable |
DestinationType | text · max 80 | Read-onlySearchable |
DestinationTypeCode | text · max 25 | Read-onlySearchable |
DocumentFiscalClassification | text · max 240 | Read-onlySearchable |
ElectronicRecordId | number | Read-onlySearchable |
EmployeeId | number | Read-onlySearchable |
EmployeeName | text · max 2000 | Read-onlySearchable |
EnteredLotsCount | number | Read-only |
EnteredSerialsCount | number | Read-only |
ExternalSystemPackingUnit | text · max 150 | Read-onlySearchable |
ExternalSystemTransactionReference | text · max 300 | Read-onlySearchable |
FinalDischargeLocationId | number | Read-onlySearchable |
FirstPartyTaxRegistrationId | number | Read-onlySearchable |
FromLocator | text · max 4000 | Read-onlySearchable |
FromLocatorId | number | Read-onlySearchable |
FromOrganizationCode | text · max 18 | Read-onlySearchable |
FromOrganizationId | number | Read-onlySearchable |
FromOrganizationName | text · max 240 | Read-onlySearchable |
FromSubinventory | text · max 240 | Read-onlySearchable |
FromSubinventoryName | text · max 30 | Read-onlySearchable |
GroupId | number | Read-onlySearchable |
InspectionQuality | text · max 80 | Read-onlySearchable |
InspectionStatus | text · max 80 | Read-onlySearchable |
InspectionStatusCode | text · max 25 | Read-onlySearchable |
IntendedUseClassificationId | number | Read-onlySearchable |
IntendedUseCode | text · max 240 | Read-onlySearchable |
InterfaceReturnsToShippingFlag | yes/no · max 1 | Read-onlySearchable |
ItemDescription | text · max 240 | Read-onlySearchable |
ItemId | number | Read-onlySearchable |
ItemNumber | text · max 300 | Read-onlySearchable |
ItemRevision | text · max 18 | Read-onlySearchable |
ItemTrackingQuantityIndicator | text · max 30 | Read-only |
LPNId | number | Read-onlySearchable |
LastUpdateDate | date-time | Read-only |
LastUpdatedBy | text · max 255 | Read-only |
LicensePlateNumber | text · max 30 | Read-onlySearchable |
LineNumber | number | Read-onlySearchable |
Locator | text · max 4000 | Read-onlySearchable |
LocatorId | number | Read-onlySearchable |
LotControlCode | number | Read-onlySearchable |
OrganizationCode | text · max 18 | Read-onlySearchable |
OrganizationId | number | Read-onlySearchable |
OrganizationName | text · max 240 | Read-onlySearchable |
PODistributionId | number | Read-onlySearchable |
PODistributionNumber | number | Read-onlySearchable |
POHeaderId | number | Read-onlySearchable |
POLineId | number | Read-onlySearchable |
POLineLocationId | number | Read-onlySearchable |
POLineNumber | number | Read-onlySearchable |
PONumber | text · max 30 | Read-onlySearchable |
POShipmentNumber | number | Read-onlySearchable |
ParentTransactionId | number | Read-onlySearchable |
ParentTransactionType | text · max 25 | Read-onlySearchable |
ParentTransactionTypeCode | text · max 25 | Read-onlySearchable |
PhysicalReturnRequiredFlag | yes/no · max 1 | Read-onlySearchable |
PrimaryQuantity | number | Read-onlySearchable |
PrimaryUOMCode | text · max 3 | Read-onlySearchable |
PrimaryUnitOfMeasure | text · max 25 | Read-onlySearchable |
ProductCategoryCode | text · max 240 | Read-onlySearchable |
ProductFiscalClassificationId | number | Read-onlySearchable |
ProductTypeCode | text · max 240 | Read-onlySearchable |
Quantity | number | Read-onlySearchable |
QuantityBilled | number | Read-onlySearchable |
RMAReference | text · max 30 | Read-onlySearchable |
Reason | text · max 30 | Read-onlySearchable |
RecallHeaderId | number | Read-only |
RecallLineId | number | Read-only |
RecallNoticeLineNumber | text · max 18 | Read-only |
RecallNoticeNumber | text · max 60 | Read-only |
ReceiptAdviceDocument | text · max 80 | Read-onlySearchable |
ReceiptAdviceDocumentCode | text · max 25 | Read-onlySearchable |
ReceiptAdviceDocumentLineNumber | text · max 80 | Read-onlySearchable |
ReceiptAdviceDocumentNumber | text · max 80 | Read-onlySearchable |
ReceiptAdviceHeaderId | number | Read-onlySearchable |
ReceiptAdviceLineId | number | Read-onlySearchable |
ReceiptAdviceLineNumber | text · max 80 | Read-onlySearchable |
ReceiptConfirmationMessageNumber | number | Read-onlySearchable |
ReceiptConfirmationStatusCode | text · max 25 | Read-onlySearchable |
ReceiptExceptionFlag | yes/no · max 1 | Read-onlySearchable |
ReceiptNumber | text · max 30 | Read-onlySearchable |
ReturnForCreditFlag | yes/no · max 1 | Read-onlySearchable |
ReturnTransferOrderHeaderId | number | Read-onlySearchable |
ReturnTransferOrderLineId | number | Read-onlySearchable |
ReturnTransferOrderLineNumber | number | Read-onlySearchable |
ReturnTransferOrderNumber | text · max 50 | Read-onlySearchable |
SecondaryQuantity | number | Read-only |
SecondaryUOMCode | text · max 3 | Read-only |
SecondaryUnitOfMeasure | text · max 25 | Read-only |
SerialNumberControlCode | number | Read-onlySearchable |
ShipFromLocationId | number | Read-onlySearchable |
ShipmentHeaderId | number | Read-onlySearchable |
ShipmentLineId | number | Read-onlySearchable |
ShipmentNumber | text · max 30 | Read-onlySearchable |
SourceDocument | text · max 80 | Read-onlySearchable |
SourceDocumentCode | text · max 25 | Read-onlySearchable |
StructureInstanceNumber | number | Read-only |
Subinventory | text · max 10 | Read-onlySearchable |
SubinventoryId | number | Read-only |
SubinventoryName | text · max 30 | Read-onlySearchable |
TaxClassificationCode | text · max 50 | Read-onlySearchable |
TaxInvoiceDate | date | Read-onlySearchable |
TaxInvoiceNumber | text · max 150 | Read-onlySearchable |
ThirdPartyTaxRegistrationId | number | Read-onlySearchable |
TransactionBusinessCategoryCode | text · max 240 | Read-onlySearchable |
TransactionDate | date | Read-onlySearchable |
TransactionDateTime | date-time | Read-onlySearchable |
TransactionId | number | Read-onlySearchable |
TransactionType | text · max 25 | Read-onlySearchable |
TransactionTypeCode | text · max 25 | Read-onlySearchable |
TransferLPNId | number | Read-onlySearchable |
TransferLicensePlateNumber | text · max 30 | Read-onlySearchable |
TransferOrderDistributionId | number | Read-onlySearchable |
TransferOrderDistributionNumber | number | Read-onlySearchable |
TransferOrderHeaderId | number | Read-onlySearchable |
TransferOrderLineId | number | Read-onlySearchable |
TransferOrderLineNumber | number | Read-onlySearchable |
TransferOrderNumber | text · max 50 | Read-onlySearchable |
UOMCode | text · max 3 | Read-onlySearchable |
UnitOfMeasure | text · max 25 | Read-onlySearchable |
UserDefinedFiscalClassificationCode | text · max 30 | Read-onlySearchable |
VendorId | number | Read-onlySearchable |
VendorName | text · max 360 | Read-onlySearchable |
VendorSiteCode | text · max 240 | Read-onlySearchable |
VendorSiteId | 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.
findByLotAndSerial·ItemIdItemNumberLotNumberOrganizationCodeOrganizationIdSerialNumber
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 14
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/receivingTransactionsHistory/{TransactionId}/child/<name>. Add them to a GET with expand.
inventoryStripingDFFGET Inventory Attributes Descriptive Flexfields · 9 fieldsTransactionId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_DisplaylotsGET Lots · 3 fieldsLotNumberSecondaryTransactionQuantityTransactionQuantitylotAttributeDFFsGET Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotSerialsGET Serials for Lots · 1 fieldsSerialNumberlotSerialAttributeDFFsGET Flexfields for Lot Serial Attributes · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotSerialStandardDFFsGET Flexfields for Lot Serials · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuelotStandardDFFsGET Flexfields for Lots · 4 fieldsLotNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuereceiptAttachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamereceiptDFFGET Flexfields for Receipt Headers · 3 fieldsShipmentHeaderId__FLEX_Context__FLEX_Context_DisplayValueserialsGET Serials · 1 fieldsSerialNumberserialAttributeDFFsGET Flexfields for Lot Serial Attributes · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValueserialStandardDFFsGET Flexfields for Lot Serials · 4 fieldsSerialNumberTransactionId__FLEX_Context__FLEX_Context_DisplayValuetransactionAttachmentsGET · POST · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNametransactionDFFsGET · PATCH Receiving Transaction Descriptive Flexfields · 3 fieldsTransactionId__FLEX_Context__FLEX_Context_DisplayValue
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/receivingTransactionsHistoryand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByLotAndSerialfor 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:AccrualStatusCode, notaccrualstatuscode. - 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.