Oracle Inventory Integration with other modules

Oracle Inventory interacts with the other applications by sharing information:

Ø       Oracle Cost Management: From cost Information to transaction rates

Ø       Oracle Work in Progress: From WIP activity and ATP supply information to UOM, items, and on-hand quantity.

Ø       Oracle Master Scheduling/MRP: From ATP supply information to on-hand quantity and forecasts

Ø       Oracle Bill of Materials to UOM and items

Oracle Apps Inventory period closure monitoring scripts

To check if there is any unprocessed material

select transaction_header_id                Txn_hdr_id,

       mmtt.transaction_temp_id             Txn_tmp_id,

       mmtt.inventory_item_id               Inv_Item_id,

       revision                             Rev,

       subinventory_code                    Subinv_code,