Receiving and Return Transaction with Receiving Open Interface (ROI)

Posted by: Edi Yanto on: January 20, 2012

• In: Oracle
• Comment!

The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so the PO will be received.
Records needs to be inserted into rcv_transactions_interface with processing_status_code and transaction_status_code as ‘PENDING’ and transaction_type of ‘RECEIVE’ and ‘DELIVER’ (Receiving). For Return Receiving transaction use the transaction_type of ‘RETURN TO RECEIVING’ (parent_transaction_id of transaction_id for DELIVER transaction) and transaction_type of ‘RETURN TO VENDOR’ (parent_transaction_id of transaction_id for RECEIVE transaction).

• Interface Tables (for Lot and Serial Controlled Item)
  • RCV_HEADER_INTERFACE
  • RCV_TRANSACTIONS_INTERFACE
  • RCV_LOTS_INTERFACE
  • RCV_SERIALS_INTERFACE
  • MTL_TRANSACTION_LOTS_INTERFACE
  • MTL_SERIAL_NUMBER_INTERFACE
• Base Tables
  • RCV_SHIPMENT_HEADERS
  • RCV_SHIPMENT_LINES
  • RCV_LOT_TRANSACTIONS
  • RCV_SERIAL_TRANSACTIONS
  • MTL_LOT_NUMBERS
  • MTL_SERIAL_NUMBERS
  • MTL_MATERIAL_TRANSACTIONS

• Error Table
  • PO_INTERFACE_ERRORS

Tags: ebiz