CST Period Close Subinventory Value – 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 operating units with corresponding sub inventory code and Inventory value on a historic basis.
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, 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, 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 ICP PII Inventory and Intransit Value (Period-End), CAC Inventory and Intransit Value (Period-End), INV Items, CAC ICP PII vs. Item Costs, GL Account Analysis
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 27-Jul-2018 095956.xlsx |
| Blitz Report™ XML Import | CST_Period_Close_Subinventory_Value.xml |
| SQL Source | CST Period Close Subinventory Value.sql |
| Full Report 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
© Enginatics GmbH