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

Last updated on AUGUST 08, 2017

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:INVTTGPM.FMB - Cost Periods
FORM:RCVTXVTX.FMB - View Transactions Status GUI
***Checked for relevance on 26-MAY-2016***

Goal

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:



Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms