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 JULY 23, 2024

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

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

EAM Enabled Organization

If the organization is Enterprise Asset Management (EAM) Enabled, the form also includes "Incomplete Work Orders" in the Resolution Recommended section:

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