Period Close SQL Counts: What Tables / Queries are Used to Display the Counts in the Inventory Account Periods form (INVTTGPM.fmb)?
Last updated on MAY 16, 2017
Applies to:Oracle Inventory Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***
What tables / queries are used to display the counts in the Inventory Account Periods form (INVTTGPM.fmb)?
R11i Pending Transactions screen:
Note: The "Uncosted Material" and "Pending WIP Costing" fields from R11i were merged into one count : "Uncosted Material/WSM". A new "Pending LCM Interface" count was added for Landed Cost Management (LCM).
R12 Pending transactions screen:
1. Goto Inventory > Accounting Close Cycle > Inventory Accounting Periods
2. Choose an inventory organization
3. The inventory accounting periods form opens
4. Press the "Pending..." button
5. The Pending Transactions Appear
6. See the following:
0 Unprocessed Material
3 Uncosted Material
0 Pending Transactions
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms