CST Cost Groups – 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
Master data report that lists all item cost groups along with their corresponding GL posting codes and descriptions.
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
None
Oracle EBS Tables Used
cst_cost_groups, hr_all_organization_units_vl, cst_cost_group_accounts
Report Categories
Related Reports
CST Subinventory Account Value - Multi-Org, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Cost Group Accounts Setup, CAC Subinventory Accounts Setup, CAC Inventory Organization Summary, CAC Category Accounts Setup
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 Cost Groups 27-Jul-2018 134345.xlsx |
| Blitz Report™ XML Import | CST_Cost_Groups.xml |
| SQL Source | CST Cost Groups.sql |
| Full Report 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
© Enginatics GmbH