CST Period Close Subinventory Value Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability.
Report Parameters
Ledger, Organization Code, Period
Oracle EBS Tables Used
gl_ledgers, org_organization_definitions, mtl_secondary_inventories, org_acct_periods, org_access_view, cst_period_summary_v
Report Categories
Related Reports
CAC Inventory to G/L Reconciliation (Restricted by Org Access), CAC Inventory Out-of-Balance, CST Period Close Subinventory Value, CAC Missing Material Accounting Transactions, CAC Inventory Pending Cost Adjustment - No Currencies, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End), CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End) - Discrete/OPM
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | CST Period Close Subinventory Value Summary 06-Jul-2019 173524.xlsx |
| Blitz Report™ XML Import | CST_Period_Close_Subinventory_Value_Summary.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cst-period-close-subinventory-value-summary/ |
Executive Summary
The CST Period Close Subinventory Value Summary is a high-level version of the period close report, designed for multi-org or multi-ledger analysis. It aggregates the period-end inventory values by Subinventory, Organization, and Ledger. This report is ideal for corporate controllers who need to review inventory positions across the entire enterprise at month-end.
Business Challenge
- Consolidated Reporting: Running separate detailed reports for 50 different warehouses is impractical for executive review.
- Ledger Visibility: Need to see inventory values grouped by the Primary Ledger they belong to.
- Trend Monitoring: Quickly identifying which organizations or subinventories have spiking inventory levels.
Solution
This report provides a summarized view of period-end inventory values.
Key Features:
- Ledger Export: Explicitly supports export by Ledger, facilitating financial consolidation.
- Multi-Org: Can report on multiple organizations in a single run.
- Summary Level: Focuses on the total value per subinventory, rather than item-level detail.
Architecture
The report uses the CST_PERIOD_SUMMARY_V view, which aggregates data from the underlying period close tables.
Key Tables:
CST_PERIOD_SUMMARY_V: The view providing the summarized data.GL_LEDGERS: Ledger definitions.ORG_ORGANIZATION_DEFINITIONS: Organization hierarchy.
Impact
- Executive Insight: Provides a “Dashboard” style view of inventory assets across the company.
- Financial Consolidation: Simplifies the process of aggregating inventory values for corporate financial statements.
- Exception Management: Highlights organizations with unusual inventory balances at period end.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics