My Oracle Support Banner

How To Identify Pending Receiving Transactions Referenced On The Inventory Accounting Periods Form (Doc ID 430890.1)

Last updated on JULY 24, 2023

Applies to:

Oracle Inventory Management - Version 11.0.3 to 12.1.3 [Release 11.0 to 12.1]
Information in this document applies to any platform.
FORM:RCVTXVTX.FMB - View Transactions Status GUI


In the  Inventory Accounting Periods form (Nav > Accounting Close Cycle -> Inventory Accounting Periods)  after you select the Organization and select the open period and click on Pending button to see the Pending Transactions in the Resolutions Recommended block, you will see Pending Receiving column and find the count.

How can we tell what those pending transactions are?

"These rows are not 'Pending' in the Receiving sense of the word because they may be marked as in ERROR in the table RCV_TRANSACTIONS_INTERFACE.

The SQL used by the Inventory Accounting Period form does not distinguish between Receiving PENDING and Receiving ERROR transactions.
The SQL simply returns the count of rows for a given period for the Inventory Organization that are in the table RCV_TRANSACTIONS_INTERFACE:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.