Oracle Inventory API Custom

In this post, i want to share about some reference for Inventory Material Transactions in Oracle R12 module Inventory. There was reference which can be used to learn Material Transactions Interface using in Oracle R12. The references were : 1. Reference for PLSQL Script Custom to process transaction type Inter Org Transfer. Source : Inter …

Receiving & Return with Receiving Open Interface (ROI)

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 also inserted into rcv_shipment_headers which creates the shipment header. Oracle using Receiving Transaction Processor processes receiving transactions with PENDING or UNPROCESSED status. We could receive Purchase Order either using Expected Receipt form, or by insert record into …