Requests for Receiving Transactions
receivingReceiptTransactionRequests Based on 26C
Create, change, delete and look up Requests for Receiving Transactions, with ASN packing units, lot item lots and lot serial item lots. Actions include process inline approval outcome and submit for approval.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE2 actions
- Record key
InterfaceTransactionId- Required on create
- none marked
- At a glance
- 160 fields1 finders18 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/receivingReceiptTransactionRequests?fields=ASNLineNumber,Amount,AssessableValue,AutoTransactCode,BarcodeLabel&limit=25&onlyData=true
{
"items": [
{
"ASNLineNumber": 0,
"Amount": 0,
"AssessableValue": 0,
"AutoTransactCode": "<string, max 25>",
"BarcodeLabel": "<string, max 35>"
}
],
"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 160
| Attribute | Type | Use |
|---|---|---|
ASNLineNumber | number | Optional on createUpdatableSearchable |
Amount | number | Optional on createUpdatableSearchable |
AssessableValue | number | Optional on createUpdatableSearchable |
AutoTransactCode | text · max 25 | Optional on createUpdatableSearchable |
BarcodeLabel | text · max 35 | Optional on createUpdatableSearchable |
BusinessUnit | text · max 240 | Optional on createUpdatableSearchable |
BusinessUnitId | number | Optional on createUpdatableSearchable |
Comments | text · max 240 | Optional on createUpdatableSearchable |
ConsignedLine | text · max 1 | Optional on createUpdatableSearchable |
ContainerNumber | text · max 35 | Optional on createUpdatableSearchable |
CopyLotsAndSerialNumbersFromParentTransactionFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
CountryOfOriginCode | text · max 2 | Optional on createUpdatableSearchable |
CreateDebitMemoFlag | yes/no | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CrossDockSuggestionId | number | Optional on createUpdatableSearchable |
CurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
CurrencyConversionDate | date | Optional on createUpdatableSearchable |
CurrencyConversionRate | number | Optional on createUpdatableSearchable |
CurrencyConversionType | text · max 30 | Optional on createUpdatableSearchable |
CustomerId | number | Optional on createUpdatableSearchable |
CustomerItemId | number | Optional on createUpdatableSearchable |
CustomerItemNumber | text · max 50 | Optional on createUpdatableSearchable |
CustomerPartyName | text · max 360 | Optional on createUpdatableSearchable |
CustomerPartyNumber | text · max 30 | Optional on createUpdatableSearchable |
DefaultLotsAndSerialNumbersFromASNFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
DefaultLotsAndSerialNumbersFromTransferOrderFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
DefaultTaxationCountry | text · max 2 | Optional on createUpdatableSearchable |
DeliverToLocationCode | text · max 60 | Optional on createUpdatableSearchable |
DeliverToLocationId | number | Optional on createUpdatableSearchable |
DeliverToPersonId | number | Optional on createUpdatableSearchable |
DeliverToPersonName | text · max 240 | Optional on createUpdatableSearchable |
DestinationTypeCode | text · max 25 | Optional on createUpdatableSearchable |
DocumentDistributionNumber | number | Optional on createUpdatableSearchable |
DocumentFiscalClassification | text · max 240 | Optional on createUpdatableSearchable |
DocumentLineNumber | number | Optional on createUpdatableSearchable |
DocumentNumber | text · max 30 | Optional on createUpdatableSearchable |
DocumentShipmentLineNumber | number | Optional on createUpdatableSearchable |
EmployeeId | number | Optional on createUpdatableSearchable |
EmployeeName | text · max 240 | Optional on createUpdatableSearchable |
EwayBillDate | date | Optional on createUpdatableSearchable |
EwayBillNumber | number | Optional on createUpdatableSearchable |
Exception | text · max 1 | Optional on createUpdatableSearchable |
ExternalSystemPackingUnit | text · max 150 | Optional on createUpdatableSearchable |
ExternalSystemTransactionReference | text · max 300 | Optional on createSearchable |
FOBCode | text · max 30 | Optional on createUpdatable |
FinalDischargeLocationCode | text · max 60 | Optional on createUpdatableSearchable |
FinalDischargeLocationId | number | Optional on createUpdatableSearchable |
FirstPartyRegistrationId | number | Optional on createUpdatableSearchable |
FirstPartyRegistrationNumber | text · max 30 | Optional on createUpdatableSearchable |
FromLocator | text · max 81 | Optional on createUpdatableSearchable |
FromLocatorId | number | Optional on createUpdatableSearchable |
FromOrganizationCode | text · max 18 | Optional on createUpdatableSearchable |
FromOrganizationId | number | Optional on createUpdatableSearchable |
FromSubinventory | text · max 10 | Optional on createUpdatableSearchable |
GroupId | number | Optional on createUpdatableSearchable |
HeaderInterfaceId | number | Optional on createSearchable |
InsertAndProcessFlag | yes/no · default true | Optional on createUpdatable |
InspectionQualityCode | text · max 25 | Optional on createUpdatableSearchable |
IntendedUse | text · max 240 | Optional on createUpdatableSearchable |
IntendedUseClassificationId | number | Optional on createUpdatableSearchable |
InterfaceSourceCode | text · max 30 · default REST | Optional on createUpdatableSearchable |
InterfaceSourceLineId | number | Optional on createUpdatableSearchable |
InterfaceTransactionId | number | Optional on createSearchable |
ItemDescription | text · max 240 | Optional on createUpdatableSearchable |
ItemId | number | Optional on createUpdatableSearchable |
ItemNumber | text · max 300 | Optional on createUpdatableSearchable |
ItemRevision | text · max 18 | Optional on createUpdatableSearchable |
LPNId | number | Optional on createUpdatableSearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LicensePlateNumber | text · max 30 | Optional on createUpdatableSearchable |
Locator | text · max 81 | Optional on createUpdatableSearchable |
LocatorId | number | Optional on createUpdatableSearchable |
OrganizationCode | text · max 18 | Optional on createUpdatableSearchable |
OrganizationId | number | Optional on createUpdatableSearchable |
PODistributionId | number | Optional on createUpdatableSearchable |
POHeaderId | number | Optional on createUpdatableSearchable |
POLineId | number | Optional on createUpdatableSearchable |
POLineLocationId | number | Optional on createUpdatableSearchable |
PackingSlip | text · max 25 | Optional on createUpdatableSearchable |
ParentSourceTransactionNumber | text · max 25 | Optional on createUpdatableSearchable |
ParentTransactionId | number | Optional on createUpdatableSearchable |
PhysicalMaterialReturnRequiredFlag | yes/no | Optional on createUpdatableSearchable |
PrimaryQuantity | number | Optional on createUpdatableSearchable |
PrimaryUOMCode | text · max 3 | Optional on createUpdatableSearchable |
PrimaryUnitOfMeasure | text · max 25 | Optional on createUpdatableSearchable |
ProcessingStatusCode | text · max 25 · default PENDING | Optional on createUpdatableSearchable |
ProductCategory | text · max 240 | Optional on createUpdatableSearchable |
ProductFiscalClassName | text · max 250 | Optional on createUpdatableSearchable |
ProductFiscalClassificationId | number | Optional on createUpdatableSearchable |
ProductType | text · max 240 | Optional on createUpdatableSearchable |
QualityInspectionEventId | number | Optional on createUpdatable |
Quantity | number | Optional on createUpdatableSearchable |
RMALineNumber | text · max 80 | Optional on createUpdatableSearchable |
RMANumber | text · max 80 | Optional on createUpdatableSearchable |
RMAReference | text · max 30 | Optional on createUpdatableSearchable |
RMAScheduleNumber | text · max 80 | Optional on createUpdatableSearchable |
ReasonId | number | Optional on createUpdatableSearchable |
ReasonName | text · max 30 | Optional on createUpdatableSearchable |
RecallHeaderId | number | Optional on createUpdatableSearchable |
RecallLineId | number | Optional on createUpdatableSearchable |
RecallLineNumber | number | Optional on createUpdatableSearchable |
RecallNoticeNumber | text · max 60 | Optional on createUpdatableSearchable |
ReceiptAdviceHeaderId | number | Optional on createUpdatableSearchable |
ReceiptAdviceLineId | number | Optional on createUpdatableSearchable |
ReceiptSourceCode | text · max 25 | Optional on createUpdatableSearchable |
ReceivingLocation | text · max 60 | Optional on createUpdatableSearchable |
ReturnForCreditFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ReturnMessage | text · max 20000 | Optional on createUpdatableSearchable |
ReturnStatus | text | Optional on createUpdatable |
RoutingCode | text · max 30 | Optional on createUpdatableSearchable |
RoutingHeaderId | number | Optional on createUpdatableSearchable |
SaveAndSubmitFlag | yes/no · default false | Optional on createUpdatable |
SecondaryQuantity | number | Optional on createUpdatableSearchable |
SecondaryUOMCode | text · max 3 | Optional on createUpdatableSearchable |
SecondaryUnitOfMeasure | text · max 25 | Optional on createUpdatableSearchable |
ShipFromLocationId | number | Optional on createUpdatableSearchable |
ShipToLocationCode | text · max 60 | Optional on createUpdatableSearchable |
ShipToLocationId | number | Optional on createUpdatableSearchable |
ShipmentHeaderId | number | Optional on createUpdatableSearchable |
ShipmentLineId | number | Optional on createUpdatableSearchable |
ShipmentNumber | text · max 30 | Optional on createUpdatableSearchable |
SkipAutoCreateDeliveryFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
SkipQualityInspectionFlag | yes/no · max 1 | Optional on createUpdatable |
SoldtoLegalEntity | text · max 240 | Optional on createUpdatableSearchable |
SoldtoLegalEntityId | number | Optional on createUpdatableSearchable |
SourceDocumentCode | text · max 25 | Optional on createUpdatableSearchable |
SourceTransactionNumber | text · max 25 | Optional on createUpdatableSearchable |
StructureInstanceNumber | number | Read-only |
Subinventory | text · max 10 | Optional on createUpdatableSearchable |
SubinventoryId | number | Read-only |
SubinventoryName | text · max 30 | Optional on createUpdatableSearchable |
SubstituteItemId | number | Optional on createUpdatableSearchable |
SubstituteItemNumber | text · max 300 | Optional on createUpdatableSearchable |
SubstituteUnorderedCode | text · max 25 | Optional on createUpdatableSearchable |
TaxClassificationCode | text · max 50 | Optional on createUpdatableSearchable |
TaxInvoiceDate | date | Optional on createUpdatableSearchable |
TaxInvoiceNumber | text · max 150 | Optional on createUpdatableSearchable |
ThirdPartyRegistrationId | number | Optional on createUpdatableSearchable |
ThirdPartyRegistrationNumber | text · max 30 | Optional on createUpdatableSearchable |
TransactionBusinessCategory | text · max 240 | Optional on createUpdatableSearchable |
TransactionDate | date-time | Optional on createUpdatableSearchable |
TransactionStatusCode | text · max 25 · default PENDING | Optional on createUpdatableSearchable |
TransactionType | text · max 25 · default RECEIVE | Optional on createUpdatableSearchable |
TransferLPNId | number | Optional on createUpdatableSearchable |
TransferLicensePlateNumber | text · max 30 | Optional on createUpdatableSearchable |
TransferOrderDistributionId | number | Optional on createUpdatableSearchable |
TransferOrderHeaderId | number | Optional on createUpdatableSearchable |
TransferOrderLineId | number | Optional on createUpdatableSearchable |
TruckNumber | text · max 35 | Optional on createUpdatableSearchable |
UOMCode | text · max 3 | Optional on createUpdatableSearchable |
UnitOfMeasure | text · max 25 | Optional on createUpdatableSearchable |
UserDefinedFiscalClassification | text · max 30 | Optional on createUpdatableSearchable |
VendorId | number | Optional on createUpdatableSearchable |
VendorItemNumber | text · max 300 | Optional on createUpdatableSearchable |
VendorName | text · max 240 | Optional on createUpdatableSearchable |
VendorNumber | text · max 30 | Optional on createUpdatableSearchable |
VendorSiteCode | text · max 240 | Optional on createUpdatableSearchable |
VendorSiteId | number | 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.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByTransactionAttributes·DocumentNumberExternalSystemTransactionReferenceFromDateGroupIdItemIdItemNumberOrganizationCodeOrganizationIdPOHeaderIdProcessingStatusCodeRMANumberReceiptAdviceHeaderIdShipmentHeaderIdShipmentNumberSourceDocumentCodeToDateTransactionStatusCodeTransactionTypeTransferOrderHeaderId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 18
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/receivingReceiptTransactionRequests/{InterfaceTransactionId}/child/<name>. Add them to a GET with expand.
ASNLineDFFFields depend on your pod's flexfield setup (check
/describe).ASNPackingUnitsGET · POST · PATCH · DELETE Packing Units · 10 fieldsCreatedByCreationDateLPNIdLPNInterfaceIdLastUpdateDateLastUpdateLoginLastUpdatedByLicensePlateNumberParentLPNIdParentLicensePlateNumberDFFGET · POST · PATCH Flexfields for Receipt Transactions · 3 fieldsInterfaceTransactionId__FLEX_Context__FLEX_Context_DisplayValueattachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameinventoryStripingDFFGET · POST · PATCH Flexfields for Inventory Striping Attributes · 9 fieldsInterfaceTransactionId__FLEX_Context__FLEX_Context_DisplayValuecountryOfOriginCodecountryOfOriginCode_DisplayprojectIdprojectId_DisplaytaskIdtaskId_DisplaylotItemLotsGET · POST · PATCH · DELETE Lots That Control Items · 20 fieldsExpirationActionCodeExpirationActionDateGradeCodeHoldDateLotExpirationDateLotNumberMaturityDateOriginationDateOriginationTypeParentLotNumberPrimaryQuantityProductTransactionIdReasonIdReasonNameRetestDateSecondaryTransactionQuantityStatusIdTransactionInterfaceIdTransactionQuantityVendorLotNumberlotAttributesDFFGET · POST · PATCH Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotNumbersDFFGET · POST · PATCH Flexfields for Lots · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotSerialItemLotsGET · POST · PATCH · DELETE Serials and Lots That Control Items · 20 fieldsExpirationActionCodeExpirationActionDateGradeCodeHoldDateLotExpirationDateLotNumberMaturityDateOriginationDateOriginationTypeParentLotNumberPrimaryQuantityProductTransactionIdReasonIdReasonNameRetestDateSecondaryTransactionQuantityStatusIdTransactionInterfaceIdTransactionQuantityVendorLotNumberlotAttributesDFFGET · POST · PATCH Flexfields for Lot Attributes · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotNumbersDFFGET · POST · PATCH Flexfields for Lots · 4 fieldsLotNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValuelotSerialItemSerialsGET · POST · PATCH · DELETE Lots and Serials That Control Items · 5 fieldsFromSerialNumberProductTransactionIdToSerialNumberTransactionInterfaceIdVendorSerialNumberserialAttributesDFFGET · POST · PATCH Flexfields for Serial Attributes · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueserialNumbersDFFGET · POST · PATCH Flexfields for Serials · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueprocessingErrorsGET Processing Errors · 9 fieldsBatchIdColumnNameErrorMessageErrorMessageNameErrorTypeInterfaceErrorIdInterfaceHeaderIdInterfaceLineIdTableNameserialItemSerialsGET · POST · PATCH · DELETE Serials That Control Items · 5 fieldsFromSerialNumberProductTransactionIdToSerialNumberTransactionInterfaceIdVendorSerialNumberserialAttributesDFFGET · POST · PATCH Flexfields for Serial Attributes · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValueserialNumbersDFFGET · POST · PATCH Flexfields for Serials · 4 fieldsFromSerialNumberTransactionInterfaceId__FLEX_Context__FLEX_Context_DisplayValue
Actions 2
POST …/action/processInlineApprovalOutcome·transactionTypegroupIdoutcomePOST …/action/submitForApproval·TransactionDisplayValueTransactionTypeTransactionKeyOrganizationIdGroupId
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/receivingReceiptTransactionRequestsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByTransactionAttributesfor 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.
- 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:ASNLineNumber, notasnlinenumber. - 6 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.