Oracle Inventory Interface – Misc Receipt for Consignment

Oracle R12 Inventory Module had given a feature for consignment item. In Oracle implementation, on June 2013, there was a customer which had material transaction for consignment item by interface. Which is the interface was, Oracle, as Back End Application, had to received report or query from Front End Application.

Customer had consignment inventory, and Oracle assigned it with owning organization data. The interface was needed to receipt consignment material transaction data, which were given by Front End Application. This requirement could be covered with Oracle Open Interface feature. It has used script to insert data to MTL_TRANSACTIONS_INTERFACE table, and then run Material Transactions Manager.

I have used custom script for Issue Return transaction, which is in Oracle Standard Transaction Type was Miscellaneous Receipt.