How to resolve Oracle Inventroy Pending Transactions

Resolution Required Transactions:

“Unprocessed Material” indicate there are unprocessed material transactions in the
MTL_MATERIAL_TRANSACTONS_TEMP table.

- To resolve Unprocessed Material

transactions, users need to identify and resolve the errors and issues preventing a record from being processed through the MTL_MATERIAL_TRANSACTIONS_TEMP table. Details of transactions can be viewed through the Applications by navigating to the Pending Transactions form .- By using the Pending Transactions window, users view, edit, correct and resubmit unprocessed material transactions. There are five tabs to select the type of information: Error, Location, Source, Intransit
and Others, which provide detailed Information on the transactions. - In the Pending Transactions window either select the Resubmit check box to resubmit one record or choose Select All to Resubmit from the Special Menu and selectively deselect individual transaction you do not want to resubmit, save your work.
- Verify transactions to be resubmitted since there may be Move Order Transactions that must be processed through the Transact Move Order Form.

“Uncosted Material” indicate there are material transactions in the
MTL_MATERIAL_TRANSACTIONS table with unprocessed accounting entries.

- To resolve uncosted Material Transactions you need to determine and fix what is preventing a record from being processed through the MTL_MATERIAL_TRANSACTIONS table. Details of uncosted transactions can be viewed through the Applications by navigating to the Material Transactions form.

In the find Parameter Window there is a field “Costed” and from the list of values “Yes, No, Error or Null” can be selected. The failed transactions are the ones that will need to be corrected and the transactions that are not costed will need to be costed to close the period.

Cost > View Transactions > Material Transactions

“Pending WIP Costing” transactions indicate there are unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table.

“Uncosted WSM txn” indicate there are uncosted transactions in the
WSM_SPLIT_MERGE_TRANSACTIONS table.

“Pending WSM interface” indicate there are pending transactions in the
WSM_SPLIT_MERGE_TXN_INTERFACE table.

Resolution Recommended Transactions:

“Pending Receiving” transactions indicate there are unprocessed purchasing transactions in the RCV_TRANSACTIONS_INTERFACE table. These transactions include purchase order receipts and returns for inventory. These transactions are not included in your receiving value if they are not resolved prior to closing the period.

“Pending Material” transactions indicate there are unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table.

“Pending Shop Floor Move” transactions indicate there are unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table.

Unprocessed Shipping Transactions:

“Pending Transactions” in the Unprocessed Shipping Transactions zone indicate there are transactions in the WSH_DELIVERY_DETAILS table in a status of shipped and next step is Run Interfaces. Run the Tripstop Interface SRS Program with either Trip or Delivery number and see. If COGS workflow customized you may see request get completed with Warning. Verify Request log for the error details. Mostly we can see here error # Unable to get account for delivery detail id XXXXX    For more details and complete detailed approach..pls refer this document Inventory Transactions Guide [ID 102878.1]