Period Close SQL Counts: What Tables / Queries are Used to Display the Counts in the Inventory Account Periods form (INVTTGPM.fmb)?
Last updated on MARCH 26, 2018
Applies to:Oracle Inventory Management - Version 11.5.9 and later
Oracle Work in Process - Version 11.5.9 and later
Oracle Shipping Execution - Version 11.5.9 and later
Information in this document applies to any platform.
INVTTGPM.fmb: Inventory Accounting Periods > Pending Transactions
Number of Transactions: Unprocessed Material, Incomplete Work Orders
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
EAM Enabled Organization
If the organization is Enterprise Asset Management (EAM) Enabled, the form also includes "Incomplete Work Orders" in the Resolution Recommended section:
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms