Internal Orders process through INV, PO and OM.

The internal order process can start with Inventory, MRP or it can start in  the purchasing module. All requisitions imported from Inventory or MRP will be loaded with an AUTHORIZATION_STATUS='APPROVED' unless the requisitions are created by Inventory's Min-Max Planning Report and those can only have an AUTHORIZATION_STATUS='INCOMPLETE' when the profile option called 'INV: Minmax Reorder Approval to Approved' is set to prevent requisitions from being created in an approved status.  The Min-Max Planning Report must be run with the Restock parameter set to Yes in order for the requisitions to be imported. 

For the requisitions created from the MRP and Inventory modules, the Requisition Import program must be run in order to move records from the requisition interface tables to the historical PO_REQUISITION_HEADERS_ALL,  PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL.

All internal requisitions created in the Purchasing module will directly  insert into the historical requisition tables bypassing the interface tables.  When each requisition is approved, data will be inserted into the MTL_SUPPLY table.  When the items on the requisition are stocked in inventory, the supply data can be viewed from the inventory form called Item Supply/Demand.

Once the Internal Requisition is approved, a user should run Create Internal Sales Orders (from a Purchasing responsibility) to load the internal sales orders interface tables called in Order Entry.

After the Create Internal Sales Orders has completed, a user should run Import Orders from an Order Management or Order Entry responsibility, using the Order Source and Type as it is shown in the Purchasing Options form under the Internal Requisition tab.

At that point, Oracle Workflow will process the internal sales order using the workflow definition listed for the Transaction Type definition in Order Management. When the workflow completes the Shipping Network is checked to see if the Transfer Type between the source and destination organization is In transit or Direct.

If the Transfer Type is In transit, then the Inventory manager will load the Receiving tables so the Internal Requisition can be found in the Receipts form [PO-Receiving: Receipts]. At the same time, the Inventory manager will insert an issue transaction into MTL_TRANSACTIONS_INTERFACE and will process it through to MTL_MATERIAL_TRANSACTIONS and
MTL_ONHAND_QUANTITIES. This will decrement the source inventory organization's on-hand quantity.  When the receipt is delivered, the receipt will be inserted into the receiving historical table called RCV_TRANSACTIONS.  If the internal requisition's Destination Type is Expense, there will be no receipt transactions added to the inventory tables. If the internal requisition's Destination Type is Inventory, the receipt transaction will move through TL_MATERIAL_TRANSACTIONS_TEMP
and insert into MTL_MATERIAL_TRANSACTIONS and MTL_ONHAND_QUANTITIES. This will increment the on-hand quantity in the receiving inventory organization.

If the Transfer Type is Direct, then the Inventory manager will insert an issue transaction into MTL_TRANSACTIONS_INTERFACE and will process it through to MTL_MATERIAL_TRANSACTIONS and MTL_ONHAND_QUANTITIES. This will decrement the source inventory organizations on hand quantity. For Direct Transfer Types with a destination type of Expense, the only transaction that will move through inventory will be the issue transaction; however for destination types of Inventory will additionally have a receipt transaction created, which will automatically move through MTL_MATERIAL_TRANSACTIONS_TEMP and insert into MTL_MATERIAL_TRANSACTIONS
and MTL_ONHAND_QUANTITIES without any user actions needed. This will automatically increment the on-hand quantity in the receiving inventory organization.

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules