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***
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:
WHERE TO_ORGANIZATION_ID = :B2
AND TRANSACTION_DATE <= :B1
AND DESTINATION_TYPE_CODE IN ('INVENTORY','SHOP FLOOR');
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