My Oracle Support Banner

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 01, 2023

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!


In this Document
Goal
 R11i Pending Transactions screen
 R12 Pending transactions screen
 EAM Enabled Organization
Solution
 A. Resolution Required
 1 Unprocessed Material
 2 Uncosted Material
 3 Pending WIP Transactions
 4 Uncosted WSM (Separate Prior to R12)
 5 Pending WSM Interface
 X  Pending LCM Interface (New in R12)
 B. Resolution Recommended
 6 Pending Receiving
 7 Pending Material
 8 Pending Shop Floor Move
 X Incomplete Work Orders
 C. Resolution Required / Recommended
 9 Unprocessed Shipping Transactions (Pending Transactions)
 ... Full SQL Script
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.