CST Period Close Subinventory Value Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Cost Management · all Cost Management reports
Overview
Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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
CST Period Close Subinventory Value, INV Material Transactions, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC ICP PII Inventory Pending Cost Adjustment, CAC Cost Type Costs Not in Period Close Inventory Snapshot, CAC Inventory and Intransit Value (Period-End), CAC Inventory to G/L Reconciliation (Restricted by Org Access), CAC Inventory Out-of-Balance, CAC ICP PII Inventory and Intransit Value (Period-End)
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
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 |
| SQL Source | CST Period Close Subinventory Value Summary.sql |
| Full Report 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
© Enginatics GmbH