CST Period Close Subinventory Value – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Summary report that lists selected operating units with corresponding sub inventory code and Inventory value on a historic basis.
Report Parameters
Ledger, Organization Code, Period, Category Set 1, Category Set 2, Show Last PO Price
Oracle EBS Tables Used
gl_ledgers, org_organization_definitions, org_acct_periods, org_access_view, oap, cst_period_close_summary, mtl_secondary_inventories, mtl_system_items_vl, mtl_default_category_sets, cst_cost_groups, mtl_transaction_types, mtl_material_transactions
Report Categories
Related Reports
CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Pending Cost Adjustment - No Currencies, CAC Inventory Pending Cost Adjustment, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End), CAC Inventory Out-of-Balance, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory to G/L Reconciliation (Restricted by Org Access)
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 27-Jul-2018 095956.xlsx |
| Blitz Report™ XML Import | CST_Period_Close_Subinventory_Value.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cst-period-close-subinventory-value/ |
Executive Summary
The CST Period Close Subinventory Value report provides a historical snapshot of inventory value at the subinventory level, specifically aligned with the accounting period close. Unlike real-time on-hand reports, this report is designed to match the General Ledger balance for a closed period. It is a critical tool for the month-end reconciliation process.
Business Challenge
- GL Reconciliation: The GL Inventory account balance is a single number. To validate it, Finance needs a detailed breakdown that sums up to exactly that number for the closed period.
- Backdated Transactions: Real-time reports change constantly. This report captures the value as it stood at the period end, respecting the accounting date of transactions.
- Subinventory Analysis: Understanding which storage locations held the value at month-end.
Solution
This report lists the inventory value by subinventory for a specific closed period.
Key Features:
- Period-Based: Parameters are driven by the Accounting Period (e.g., “Jan-24”), ensuring alignment with the GL.
- Historical Accuracy: Uses the period-end snapshot data.
- Category Grouping: Can group items by category for high-level analysis.
Architecture
The report queries the CST_PERIOD_CLOSE_SUMMARY table, which is populated by the Period Close process.
Key Tables:
CST_PERIOD_CLOSE_SUMMARY: Stores the summarized value of inventory at period close.ORG_ACCT_PERIODS: Defines the accounting periods.MTL_SECONDARY_INVENTORIES: Subinventory definitions.
Impact
- Audit Compliance: Provides the “Sub-Ledger” detail required to support the General Ledger inventory balance.
- Reconciliation Speed: Drastically reduces the time spent investigating differences between the GL and the perpetual inventory records.
- Trend Analysis: Allows for month-over-month comparison of inventory levels by location.
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