Resolving Period Close Pending Transaction

Resolving Period Close Pending Transaction R11


PURPOSE


There are a variety of reasons for pending transactions. This paper will serve as a guide for troubleshooting and resolving pending transactions preventing an accounting period from being closed.


VIEWING PENDING TRANSACTIONS


You can view the number of pending transactions by navigating to the Inventory Accounting Periodsform.

Navigate > Cost > Accounting Close Cycle > Inventory Accounting Periods

Put your cursor on the appropriate open accounting period and click on the [Pending]
button. There are three zones titled “Resolution Required” , “Resolution Recommended” and “Unprocessed Shipping Transactions”.

The Resolution Required zone displays the number of Unprocessed material, Uncosted material, PendingWIP Costing, Uncosted WSM txn and Pending WSM interface transactions existing in this period. Transactions appearing in this zone must be resolved before the period can be closed.

The Resolution Recommended zone displays the number of Pending Receiving, Pending Material and Pending Shop Floor Move transactions existing in this period. Transactions appearing in this zone will not prevent closingof the accounting period. However, once the accounting period is closed, unresolved transactions in this zone cannot be processed because they have a transaction date for a closed period.

The Unprocessed Shipping Transactions zone displays the number of Pending Transactions existing in this period. Transactions appearing in this zone must be resolved before the period can be closed.Resolution Required Transactions:

“Unprocessed Material” indicate there are unprocessed material transactions in the MTL_MATERIAL_TRANSACTONS_TEMP table . (page 3)

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

“Pending WIP Costing” transactions indicate there are unprocessed resource andoverhead accounting transactions in the WIP_COST_TXN_INTERFACE table.
(page 10)

“Uncosted WSM txn” indicate there are uncosted transactions in the WSM_SPLIT_MERGE_TRANSACTIONS table. (page 13)


“Pending WSM interface” indicate there are pending transactions in the WSM_SPLIT_MERGE_TXN_INTERFACE table. (page 16)


Resolution Recommended Transactions:

“Pending Receiving” transactions indicatethere 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. (page 17)

“Pending Material” transactions indicate there are unprocessed material transactions in theMTL_TRANSACTIONS_INTERFACE table. (page 20)

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


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.
(page 27)UNPROCESSED MATERIAL TRANSACTIONS


To resolve Unprocessed Material transactions, you need to determine and fix what is
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.

Inventory > Transactions > Pending Transactions


By using the PendingTransactions window, you can 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.

The Main Descriptive fields give detailed information on they type of transaction:
Primary UOM, Transaction quantity in terms of the...