Some companies use Warehouse Management Systems (WMS) such as Oracle Warehouse Management or Manhattan Active Warehouse Management /third party WMS systems for goods receiving, shipping the products to customers, and inventory movements such as sub-inventory transfers and inter-organization transfers etc., In such cases, all inventory transactions generated in the WMS must be interfaced back to Oracle Fusion Cloud Inventory Management to ensure accurate inventory balances, costing, and financial accounting.
The Oracle Receiving Open Interface allows external systems, REST Services or FBDI files to import shipment notices (ASNs) and receipts. The Oracle Inventory Review Receipts Interface allows users to manage, correct, and resubmit pending or error-prone receiving transactions (ASNs, PO receipts) that failed to process through the Receiving Open Interface.
When Purchase Orders (POs) or Transfer Orders (TOs) are received in the Warehouse Management System (WMS), the PO/TO receipt integration inserts the receipt data into the Receiving (RCV) interface tables in Oracle Fusion Cloud Inventory Management and processes the transactions. The Manage Receiving Transactions scheduled process validates and processes receipt transactions loaded into the open interfaces, automatically without user intervention. In case of any interface errors, users can review, correct, and reprocess the staged records using the “Review Receipts Interface” task in the Inventory Management work area.
Receiving Interface Tables:
RCV_HEADERS_INTERFACE: Receipt header and shipment header information.
RCV_TRANSACTIONS_INTERFACE: Receipt line information.
INV_TRANSACTION_LOTS_INTERFACE: Lot information.
INV_SERIAL_NUMBERS_INTERFACE: Serial information.
INV_LPN_INTERFACE: Packing unit information.
Here are the detailed steps to review pending or error RCV transactions, correct errors, and resubmit them for processing using Excel Spreadsheet.
Navigation: Supply Chain Execution > Inventory Management > Receipts > Tasks > Review Receipts Interface.
- System downloads the ReceivingInterfaceDi.xlsx ADFDI Spreadsheet
- Open the ADFDI Spreadsheet ReceivingInterfaceDi.xlsx
- Once the file is open, the system prompts for the username and password of the Fusion environment.
- Enter the username and password to connect to the ERP instance.
- The Excel Spreadsheet has Summary and Details excel sheets
- Go to the Detail tab
- Enter Organization Name
- Enter Transaction Status = ERROR
Then Click Search from the Excel Menu under “Review Receipts Interface” tab. It returns error RCV Trx Interface records.
- Review the error messages for the failed record(s) and take corrective action to correct the interface record(s).
- Once the data is corrected for any row(s), The row will be marked as changed automatically.
- Once the failed record(s) are corrected, Re-submit for processing by clicking “Save & Submit” in the menu to process the changed records.
- Refresh the Search to view the processed record status.