Oracle Apps Inventory Management Scripts

Inventory Transactions

a. Stuck interface transactions (Group By)

      PROMPT Stuck Transactions - GroupBy MTI

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,