Period Close SQL Counts: What Tables / Queries are Used to Display the Counts in the Inventory Account Periods form (INVTTGPM.fmb)?

(Doc ID 357997.1)

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***

Goal

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:

Steps
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
... etc...

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