How to Resubmit Unprocessed Transactions Stuck in the MTL_MATERIAL_TRANSACTION_TEMP Table

Pending Transactions may be resubmitted through the Pending Transactions screen or via sqlplus.

For screen resubmission:

Navigation Inventory>Transactions>Pending Transactions

 Click the checkbox under the "Submit" column to select specific rows.

 Click the Save icon

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,