CST Cost Groups – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report that lists all item cost groups along with their corresponding GL posting codes and descriptions.
Report Parameters
Oracle EBS Tables Used
cst_cost_groups, &xle_table, cst_cost_group_accounts
Report Categories
Related Reports
CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CST Inventory Value - Multi-Organization (Element Costs) 11i, CAC Onhand Lot Value (Real-Time)
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 Cost Groups 27-Jul-2018 134345.xlsx |
| Blitz Report™ XML Import | CST_Cost_Groups.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cst-cost-groups/ |
Executive Summary
The CST Cost Groups report is a master data configuration report that details the setup of Cost Groups within the organization. In Project Manufacturing or Weighted Average Costing environments, Cost Groups are used to segregate inventory costs for different projects or purposes within the same inventory organization. This report provides a clear view of the account mappings associated with each group.
Business Challenge
Cost Groups allow for the same item to have different costs depending on who owns it (e.g., Project A vs. Project B).
- Account Mapping: Each Cost Group has its own set of valuation accounts (Material, Material Overhead, WIP, etc.). Incorrect mapping leads to financial misstatements.
- Complexity Management: As the number of projects or cost groups grows, maintaining visibility into the underlying account structure becomes difficult.
- Audit: Verifying that specific projects are pointing to the correct GL accounts.
Solution
This report lists all defined Cost Groups and their associated General Ledger accounts.
Key Features:
- Account Detail: Shows the full GL account string for each cost element (Material, Resource, Overhead, etc.).
- Description: Includes the description of the Cost Group for context.
Architecture
The report queries CST_COST_GROUPS and CST_COST_GROUP_ACCOUNTS.
Key Tables:
CST_COST_GROUPS: Defines the cost group name and type.CST_COST_GROUP_ACCOUNTS: Stores the GL account assignments for the group.
Impact
- Configuration Validation: Ensures that new Cost Groups are set up with the correct accounting rules.
- Troubleshooting: Helps explain why inventory transactions for a specific project are hitting unexpected GL accounts.
- System Documentation: Provides a reference for the financial structure of the manufacturing organization.
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