Search Results cst_cost_groups




Overview
Explore in AI Chat

Overview

The CST_COST_GROUPS table is a core master data table within the Oracle E-Business Suite (EBS) Bills of Material (BOM) module, specifically for Release 12.1.1 and 12.2.2. Its primary function is to store the definition of cost groups, which are fundamental entities in the Product and Cost Accounting (PAC) and Average Costing methodologies. Cost groups enable organizations to segregate and track inventory costs based on specific business criteria, such as different legal entities, product lines, or valuation methods within a single inventory organization. This segregation is critical for accurate cost accumulation, reporting, and compliance in complex manufacturing and distribution environments.

Key Information Stored

While the provided metadata does not list individual columns, the table's primary key is documented as COST_GROUP_ID. This unique identifier is the critical column referenced extensively by foreign keys across the cost management and inventory schemas. Based on its role, the table typically contains descriptive and control columns for each cost group definition. Common columns include COST_GROUP (a user-defined name or code), a DESCRIPTION, an associated LEGAL_ENTITY identifier, and links to the inventory ORGANIZATION_ID. The table also houses configuration flags that determine the cost group's behavior, such as whether it is used for standard costing, average costing, or PAC.

Common Use Cases and Queries

The primary use case is defining and maintaining cost groups through the "Cost Groups" form in the EBS application, which writes to this table. These definitions are then referenced in transaction processing and cost calculations. Common reporting and diagnostic SQL queries involve joining CST_COST_GROUPS to related transaction tables. For instance, to analyze inventory transactions by cost group, one might query:

Another critical query is to identify the default cost group assigned to a subinventory for proper cost assignment during material receipts:

Related Objects

The CST_COST_GROUPS table is a central hub in the cost accounting schema, as evidenced by the extensive list of foreign key relationships. Key dependent objects include: