Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

ReceivingReceiptTransactionRequests

The Requests for Receiving Transactions resource is used to communicate requests to inspect, put away, correct, and return received goods and services with Oracle Fusion applications and process these requests. These transactions are created after creating a receipt to move the material and for acknowledging services. If there are errors in processing, you can search for the error records. After the search, the source application can either make the necessary corrections and resubmit the request or delete the requests that have resulted in errors.

Columns

Name Type Description
InterfaceTransactionId [KEY] Long Value that uniquely identifies the interfaced receipt transaction line request.
HeaderInterfaceId Long Value that uniquely identifies the header interfaced receipt transaction line request.
CreatedBy String CreatedBy of ReceivingReceiptTransactionRequests
CreationDate Datetime CreationDate of ReceivingReceiptTransactionRequests
LastUpdateDate Datetime LastUpdateDate of ReceivingReceiptTransactionRequests
LastUpdatedBy String LastUpdatedBy of ReceivingReceiptTransactionRequests
TransactionType String Type of transaction for the receipt transaction line request. Valid values include ACCEPT, REJECT, TRANSFER, DELIVER, CORRECT, RETURN TO VENDOR, RETURN TO RECEIVING, RETURN TO CUSTOMER, and RETURN TO ORGANIZATION.
AutoTransactCode String This attribute is not applicable and should be left blank.
TransactionDate Datetime Date when the transaction for the current line is created. This attribute is used for receipt accounting, invoicing, and other related processes. The default value is the current date and time. If the time zone is not provided, the value stored is the time zone of the database. This value cannot be a future date.
OrganizationCode String Abbreviation that identifies the receiving organization. This attribute is used to derive OrganizationId. For every receipt transaction request, you must provide one of the following attributes: OrganizationCode or OrganizationId, otherwise the request will fail.
OrganizationId Long Value that uniquely identifies the receiving organization. For every receipt transaction request, you must provide one of the following attributes: OrganizationCode or OrganizationId, otherwise the request will fail.
ItemDescription String Description of the item corresponding to the receipt transaction request. When you create a receipt transaction for a purchase order, it should match the item description of the corresponding purchase order line. For receipt transactions against In-transit shipment, transfer order, and return material authorization (RMA), this attribute should match the description of the inventory item. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription. If left blank, the value from the source document is used.
ItemId Long Value that uniquely identifies the inventory item. If left blank, the value from the source document is used. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription.
ItemNumber String Number that identifies the item. This attribute is used to derive ItemId. If blank, the value from the source document is used. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription.
ItemRevision String Revision number of the item. This attribute is mandatory when delivering receipt lines whose item is revision controlled.
ReceiptSourceCode String Value that identifies the source of the advanced shipment notice (ASN) or the receipt. Valid values include VENDOR when creating an ASN, receiving a purchase order, or receiving an ASN, INVENTORY when receiving an in-transit shipment, TRANSFER ORDER when receiving a transfer order, CUSTOMER when receiving a return material authorization (RMA). This attribute is mandatory.
SourceDocumentCode String Abbreviation that identifies the type of source document. Valid values include PO to create an advanced shipment notice (ASN), receive a purchase order, or an ASN, INVENTORY to receive an in-transit shipment, TRANSFER ORDER to receive a transfer order, RMA to receive a transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. This attribute is mandatory.
DocumentNumber String Number that identifies the document for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order or an ASN), this attribute is the purchase order number. When the source document code is INVENTORY, this attribute is the in-transit shipment number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment number. When the source document code is RMA, this attribute is the return material authorization (RMA) number. This attribute is mandatory.
DocumentLineNumber Long Number that identifies the document line number for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order, or receive an ASN), this attribute is the purchase order line number. When the source document code is INVENTORY, this attribute is the in-transit shipment line number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment line number. When the source document code is RMA, this attribute is the return material authorization (RMA) line number. This attribute is mandatory.
DocumentShipmentLineNumber Long Number that identifies the document schedule for the receiving transaction. When the source document code is PO (create an advanced shipment notice (ASN), receive a purchase order, or receive an ASN), this attribute is the purchase order schedule number. When receiving a purchase order or creating an ASN line, this attribute is mandatory.
DocumentDistributionNumber Long Number that identifies the document distribution for the receiving transaction. When receiving a purchase order that has multiple distributions, this attribute is the respective purchase order distribution number. When receiving a purchase order with multiple distributions, this attribute is mandatory.
PODistributionId Long Value that uniquely identifies the purchase order distribution. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POHeaderId Long Value that uniquely identifies the purchase order header. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POLineId Long Value that uniquely identifies the purchase order line. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
POLineLocationId Long Value that uniquely identifies the purchase order schedule. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN.
ShipmentHeaderId Long Value that uniquely identifies the receiving shipment or receipt header. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order.
ShipmentLineId Long Value that uniquely identifies the shipment line. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order.
ShipmentNumber String Number that identifies the shipment that the shipment source assigns. This number corresponds to the number that identifies one of the following objects: advance shipment notice, in-transit shipment, or transfer-order shipment.
ASNLineNumber Long Number that identifies the line on the advance shipment notice. Either this attribute or ShipmentLineId must be provided when receiving an advanced shipment notice (ASN).
TransferOrderHeaderId Long Value that uniquely identifies the transfer order header. This attribute is applicable when receiving a transfer order.
TransferOrderLineId Long Value that uniquely identifies the transfer order line. This attribute is applicable receiving a transfer order.
TransferOrderDistributionId Long Value that uniquely identifies the transfer order distribution. This attribute is applicable when receiving a transfer order with multiple distributions and direct routing.
SoldtoLegalEntity String Name of the sold-to legal entity. Populate this attribute with the sold-to legal entity associated to the purchase order. This is used to derive SoldtoLegalEntityId.
SoldtoLegalEntityId Long Value that uniquely identifies the sold-to legal entity. The combination of DocumentNumber and SoldtoLegalEntityId is needed to derive POHeaderId, which identifies the purchase order header for a purchase order-based transaction.
DestinationTypeCode String Abbreviation that identifies the destination type for the receiving transaction. This attribute should be left blank. It will be derived from the source document.
Subinventory String Name of the destination subinventory for the receiving transaction. This attribute is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, subinventory is not specified on the document distribution or line (if provided in the document line, the default value is used), or no item transaction default exists (if item transaction default exists, it will be derived).
Locator String Name of the destination locator for the receiving transaction. This is used to derive LocatorId. This attribute or LocatorId is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived).
LocatorId Long Value that uniquely identifies the destination locator for the receiving transaction. This attribute or Locator is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived).
Quantity Decimal Transaction quantity in the unit of measure that the receipt transaction request uses.
UnitOfMeasure String Unit of measure for the receipt transaction request. This attribute is used to derive UOMCode.
UOMCode String Abbreviation that identifies the unit of measure that the receipt transaction uses.
PrimaryQuantity Decimal Transaction quantity in the primary unit of measure that the item uses.
PrimaryUOMCode String Abbreviation that identifies the primary unit of measure that the item in the receiving organization uses.
PrimaryUnitOfMeasure String Primary unit of measure that the item in the receiving organization uses. This attribute is used to derive PrimaryUOMCode.
ProcessingStatusCode String Value that indicates the processing status for the line request. Valid values include PENDING, RUNNING, COMPLETED. The default value is PENDING. Only the interface records with value PENDING will be picked for processing. If there is an error in the derive, default, and validate cycle, the status moves to ERROR. This attribute should be left blank during POST operation so that the default value of PENDING is picked.
SecondaryUOMCode String Abbreviation that identifies the secondary unit of measure that the item in the receiving organization uses.
SecondaryUnitOfMeasure String Secondary unit of measure that the item in the receiving organization uses.
SecondaryQuantity Decimal Transaction quantity in the secondary unit of measure that the item uses.
EmployeeId Long Value that uniquely identifies the employee who performed the receiving transaction. If this attribute is blank, the value from the parent transaction is used.
EmployeeName String Name of the employee who performed the receiving transaction. This attribute is used to derive EmployeeId. If this attribute is blank, the value from the parent transaction is used.
ParentTransactionId Long Value that uniquely identifies the parent receiving transaction. This attribute is mandatory. Without this attribute, inspections, put away, corrections, and returns will not be processed.
SourceTransactionNumber String Number that identifies the unique transaction identifier in the source application. There can be only one record in receiving transactions for a source transaction number.
ParentSourceTransactionNumber String Number that identifies the source transaction number of the parent receiving transaction.
InterfaceSourceCode String Abbreviation that identifies the source that interfaced the receiving transaction. It can be populated with the source application name.
InterfaceSourceLineId Long Value that uniquely identifies the interfaced source line. This can be populated with the identifier of the line in the source application that initiated the receipt.
ShipToLocationCode String Abbreviation that identifies the receiving location. This is used to derive ShipTolocationId. This attribute is applicable only when transaction type is ACCEPT, REJECT, and TRANSFER. If this attribute is blank, the value from the parent transaction is used.
ShipToLocationId Long Value that uniquely identifies the receiving location. If this attribute is blank during a POST operation, the value is derived from ShipToLocationId of the source document. This attribute is applicable only when transaction type is ACCEPT, REJECT, and TRANSFER. If this attribute is blank, the value from the parent transaction is used.
DeliverToLocationCode String Abbreviation that identifies the deliver-to location. This attribute is used to derive DeliverTolocationId. If this attribute is blank, the default value from the purchase order distribution or transfer order distribution is used.
DeliverToLocationId Long Value that uniquely identifies the deliver-to location. If this attribute is blank, the default value from the purchase order distribution or transfer order distribution is used. DeliverToLocationId is mandatory when transaction type is DELIVER and source document code is PO or TRANSFER ORDER and the destination type code of the distribution is EXPENSE.
DeliverToPersonId Long Value that uniquely identifies the deliver-to person or requester. If this attribute is blank, the default value of the requester specified on the purchase order distribution or transfer order distribution is used.
DeliverToPersonName String Name of the deliver-to person or requester. This attribute is used to derive DeliverToPersonId.
RoutingCode String Value that indicates the receiving routing. This attribute need not be populated for this resource. It is derived from the parent transaction.
RoutingHeaderId Long Value that uniquely identifies the receiving routing. This attribute need not be populated for this resource. It is derived from the parent transaction.
InspectionQualityCode String Abbreviation that identifies the inspection quality. This attribute is applicable only when the transaction type is ACCEPT or REJECT. A list of accepted values is defined in the lookup type RCV_QUALITY_CODE.
Exception String Value that indicates whether or not the receive transaction being created has an exception. If you want to flag the receiving transaction as an exception, populate this attribute with Y. Else, leave it blank.
RMAReference String Number that identifies the return material authorization that the supplier provides when returning goods to the supplier. This attribute is applicable only when the transaction type is RETURN TO VENDOR.
RMANumber String Number of the return material authorization (RMA) against which receipt is being done. This attribute along with RMASourceSystemName of the header is used to derive ReceiptAdviceHeaderId. This attribute is applicable when creating receipt transactions for RMA.
RMALineNumber String Line number of the return material authorization (RMA) against which receipt is being created. This attribute is used to derive ReceiptAdviceLineId. This attribute is mandatory when creating receipt for RMA.
RMAScheduleNumber String Schedule number of the return material authorization against which receipt is being done.
ReceiptAdviceHeaderId Long Value that uniquely identifies the receipt advice header.
ReceiptAdviceLineId Long Value that uniquely identifies the receipt advice line.
CustomerId Long Value that uniquely identifies the customer. This attribute can be blank and the value is derived from the parent transaction.
CustomerPartyName String Name of the customer. This attribute can be blank and the value is derived from the parent transaction.
CustomerPartyNumber String Number that uniquely identifies the customer. This attribute can be blank and the value is derived from the parent transaction.
CustomerItemNumber String Number that the customer uses to identify the item. This attribute can be blank and the value is derived from the parent transaction.
CustomerItemId Long Value that the customer uses to uniquely identify the item. This attribute can be blank and the value is derived from the parent transaction.
Amount Decimal Receipt amount in the purchase order currency. This attribute is mandatory when creating receipt for a fixed price service purchase order line.
CountryOfOriginCode String Abbreviation that identifies the country of manufacture for this item. This attribute can be blank for this resource.
CurrencyCode String Receipt amount in the purchase order currency. This attribute is mandatory when creating receipt for a fixed price service purchase order line.
CurrencyConversionDate Date Date when the currency conversion occurred for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt and the order currency is different from the ledger currency of the receiving organization.
CurrencyConversionRate Decimal Currency conversion rate for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt, the order currency is different from the ledger currency of the receiving organization, and the rate type on the purchase order is User.
FromOrganizationCode String Abbreviation that identifies the source organization for an interorganization transfer. This is applicable for receipts against in-transit shipment or transfer order shipment.
FromOrganizationId Long Value that uniquely identifies the source organization for an in-transit shipment.
ContainerNumber String Container number. This attribute is not currently used.
SubstituteItemNumber String Substitute item number for the item on the receipt line. This attribute is not currently used.
SubstituteItemId Long Value that uniquely identifies the substitute item. This attribute is not currently used.
SubstituteUnorderedCode String Value that indicates whether the transaction is for a substitute item. This attribute is not currently used.
VendorName String Name of the supplier. This attribute can be blank for this resource and is derived from the parent transaction.
VendorId Long Value that uniquely identifies the supplier. This attribute can be blank for this resource and is derived from the parent transaction.
VendorNumber String Number that identifies the supplier. This attribute can be blank for this resource and is derived from the parent transaction.
VendorSiteCode String Abbreviation that identifies the supplier site for a business unit. This attribute can be blank for this resource and is derived from the parent transaction.
VendorSiteId Long Value that uniquely identifies the supplier site. This attribute can be blank for this resource and is derived from the parent transaction.
VendorItemNumber String Number that the supplier uses to identify the item. This attribute can be blank for this resource and is derived from the parent transaction.
BusinessUnit String Name of the business unit. This attribute can be blank for this resource and is derived from the parent transaction.
BusinessUnitId Long Value that uniquely identifies the business unit. This attribute can be blank for this resource and is derived from the parent transaction.
ConsignedLine String Value that indicates whether or not the receiving transaction is for consigned material. If this attribute is blank, the value is derived from the parent transaction. Enter N if returning an owned (once consigned) material. Else, leave this attribute blank.
ReasonId Long Value that uniquely identifies the inventory transaction reason for the receiving transaction.
ReasonName String Name of the inventory transaction reason for the receiving transaction. This attribute is used to derive ReasonId.
PackingSlip String Packing slip number for the container that contains this item. This attribute can be blank for this resource.
Comments String Text that the used entered when receiving the item.
FromSubinventory String Name of the source subinventory for the receiving transaction. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away.
FromLocator String Name of the source locator for the receiving transaction. This attribute is used to derive FromLocatorId. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away.
FromLocatorId Long Value that uniquely identifies the source locator for the receiving transaction. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away.
TransactionStatusCode String Value that indicates the status of the advanced shipment notice (ASN) line request or receipt transaction request. Valid values include PENDING, RUNNING or ERROR. The default value is PENDING. Only the interface records with value PENDING are picked for processing. If there is an error in running the transaction, the status changes to ERROR. This attribute should be blank during POST operations so that the default value of PENDING is used.
GroupId Long Value that uniquely identifies the group of interface records submitted together for processing.
ExternalSystemPackingUnit String License plate number of the external warehouse management application.
DefaultTaxationCountry String Value that indicates the default taxation country. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
DocumentFiscalClassification String Fiscal classification for the document. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
FirstPartyRegistrationId Long Value that uniquely identifies the first party registration. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ThirdPartyRegistrationId Long Value that uniquely identifies the third party registration. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
TransactionBusinessCategory String Business category of the transaction. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
TaxInvoiceNumber String Number of the tax invoice. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
TaxInvoiceDate Date Date when the tax invoice is created. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
EwayBillNumber Long Number that identifies the electronic waybill provided by supplier for shipment of goods. This attribute is not applicable and should be left blank.
EwayBillDate Date Date when the electronic waybill was generated. This attribute is not applicable and should be left blank.
UserDefinedFiscalClassification String Value that indicates the fiscal classification defined by the user. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ProductFiscalClassificationId Long Value that uniquely identifies the product fiscal classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
TaxClassificationCode String Value that indicates the tax classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
IntendedUseClassificationId Long Value that uniquely identifies the intended use classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
IntendedUse String Value that indicates the intended use. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ProductCategory String Value that indicates the product category. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
AssessableValue Decimal Assessable value of the transaction for taxation purposes. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
FinalDischargeLocationId Long Value that uniquely identifies the final discharge location. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ProductType String Value that indicates the product type for taxation purposes. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
FirstPartyRegistrationNumber String Number that is used for the first party registration. This attribute is used to derive FirstPartyRegistrationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ThirdPartyRegistrationNumber String Number that is used for the third party registration. This attribute is used to derive ThirdPartyRegistrationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
ProductFiscalClassName String Name used to indicate the product fiscal classification. This attribute is used to derive ProductFiscalClassificationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used.
FinalDischargeLocationCode String Value that indicates the final discharge location. This attribute is used to derive FinalDischargeLocationId. Applicable only for return transactions. Even for returns, if left blank, defaulted from the parent transaction.
BarcodeLabel String Label of the barcode on the product. This attribute is not currently used.
TruckNumber String Number of the truck. This attribute is not currently used.
InsertAndProcessFlag Bool Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API processes the posted interface data automatically and immediately returns the response. If false, then the records are created in interface tables but no processing is done. These interface records can subsequently processed by the Manage Receiving Transactions scheduled process. The default value is true.
ReturnStatus String Value that indicates the status of the application call that's sent to the client. When the input payload is processed synchronously, values include SUCCESS or ERROR. When the input payload is processed asynchronously, values include SUBMITTED or QUEUED.
LPNId Long Value that uniquely identifies the source license plate number. This attribute can be blank for this resource.
LicensePlateNumber String Source license plate number. This attribute can be blank for this resource.
SaveAndSubmitFlag Bool Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API resubmits the patched interface data automatically and immediately returns the response. If false, then the records are updated in interface tables but not resubmitted. The default value is false.
CreateDebitMemoFlag Bool Contains one of the following values: true or false. If true, then the supplier site of the purchase order is setup to create a debit memo and the receipt (for which return is performed) has a corresponding evaluated receipt settlement (ERS) invoice. If false, then the supplier site of the purchase order is not setup for creating debit memo. The default value is false. This attribute determines whether to create the debit memo. This attribute is applicable only when transaction type is RETURN TO VENDOR.
PhysicalMaterialReturnRequiredFlag Bool Contains one of the following values: true or false. If true, then a new return transfer order is created that needs to be shipped to the source organization. If false, then the material is issued to scrap. The default value is false. This attribute determines whether the return against a transfer order requires a physical return of the item. This attribute is applicable only when the transaction type is RETURN TO ORGANIZATION.
RecallHeaderId Long Value that uniquely identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallLineId Long Value that uniquely identifies the line corresponding to the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallLineNumber Long Number that identifies the recall notice line. This attribute should only be used for the RETURN TO VENDOR transaction type.
RecallNoticeNumber String Number that identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type.
ExternalSystemTransactionReference String Value that contains reference information for the corresponding transaction in external applications.
DefaultLotsAndSerialNumbersFromASNFlag Bool Contains one of the following values: true or false. If true, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will be are defaulted when executing a receipt or a put away transaction. If false, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will not be defaulted when executing a receipt or a put away transaction. The default value is false.
DefaultLotsAndSerialNumbersFromTransferOrderFlag Bool Contains one of the following values: true or false. If true, then the lots and serial numbers from a transfer order are defaulted when executing a receipt or a put away transaction. If false, then the lots and serial numbers from a transfer order aren't defaulted when executing a receipt or a put away transaction. The default value is false.
ReturnMessage String Contains the message that's returned to the caller when the input payload is processed asynchronously through immediate or background processing.
Finder String Finder of ReceivingReceiptTransactionRequests
FromDate Datetime FromDate of ReceivingReceiptTransactionRequests
ToDate Datetime ToDate of ReceivingReceiptTransactionRequests

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060