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...
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!