Search Results cst_cost_groups

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:

• SELECT ccg.COST_GROUP, mmt.TRANSACTION_ID, mmt.TRANSACTION_QUANTITY FROM MTL_MATERIAL_TRANSACTIONS mmt, CST_COST_GROUPS ccg WHERE mmt.COST_GROUP_ID = ccg.COST_GROUP_ID;

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

• SELECT msi.SECONDARY_INVENTORY_NAME, ccg.COST_GROUP FROM MTL_SECONDARY_INVENTORIES msi, CST_COST_GROUPS ccg WHERE msi.DEFAULT_COST_GROUP_ID = ccg.COST_GROUP_ID;

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:

• Transaction Processing: MTL_MATERIAL_TRANSACTIONS, CST_RCV_ACQ_COSTS, and WIP_PAC_ACTUAL_COST_DETAILs store the COST_GROUP_ID for each costed transaction.
• Cost Accumulation: CST_PAC_QUANTITY_LAYERS, CST_PAC_ITEM_COSTS, and MTL_PAC_COST_SUBELEMENTS use it to segregate perpetual cost layers.
• Inventory Control: MTL_CYCLE_COUNT_ENTRIES, MTL_PHYSICAL_INVENTORY_TAGS, and MTL_PHYSICAL_ADJUSTMENTS link physical counts to specific cost groups.
• Configuration: MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES define default cost groups at the organization and subinventory levels, respectively.