Results for “cst_cost_groups”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CST_COST_GROUPS is a foundational reference table in Oracle E-Business Suite Release 12.1.1 and 12.2.2, owned by the BOM schema and delivered under the Bills of Material product. It stores the definitions of cost groups — user-defined classifications that partition inventory, receiving, work-in-process, and costing transactions into logical buckets for costing, valuation, and reporting purposes. Cost groups enable organizations to segregate costs by category (such as material type, product line, or warehouse zone) so that quantities and values can be summarized and audited independently within the perpetual and periodic costing processes.

The table serves as a central reference point across the Oracle Cost Management, Inventory, and Work in Process modules. Numerous transactional and summary tables carry a COST_GROUP_ID foreign key back to this table, making it a highly referenced parent entity. From a dimensional-modeling perspective, the documented relationship structure suggests a hub-leaning classification: CST_COST_GROUPS behaves as a durable business entity referenced by many dependent tables rather than as a transaction or a change-history satellite.

Key Information Stored

The documented physical schema contains 33 columns. The most significant are:

• COST_GROUP_ID — surrogate primary key defined by CST_COST_GROUPS_PK; the value propagated into all referencing foreign-key tables.
• COST_GROUP — the user-facing business name of the cost group.
• DESCRIPTION — free-text description of the cost group's purpose.
• ORGANIZATION_ID — the inventory organization to which the cost group belongs, anchoring the record to an operating unit and warehouse context.
• DISABLE_DATE — date on which the cost group was inactivated, supporting soft-delete and historical reporting.
• COST_GROUP_TYPE — discriminates the classification or category of the cost group.
• LEGAL_ENTITY — the legal entity associated with the cost group, relevant for intercompany and multi-entity costing.
• ZD_EDITION_NAME — the edition column introduced for the Enterprise Command Center and editioning framework; it participates in unique index CST_COST_GROUPS_U1 alongside COST_GROUP_ID.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns enabling client-specific extensions without schema changes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard auditing (WHO) columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program tracking columns that identify the batch job which last touched the record.

The surrogate key is COST_GROUP_ID. The documented unique index CST_COST_GROUPS_U1 covers (COST_GROUP_ID, ZD_EDITION_NAME), which serves as the edition-aware business-key candidate rather than a natural business key on COST_GROUP alone.

Common Use Cases and Queries

Because the user searched for mtl_physical_inventory_tags, the most immediate practical link is the physical inventory process. MTL_PHYSICAL_INVENTORY_TAGS.COST_GROUP_ID references CST_COST_GROUPS, so cost group definitions determine how counted tags are grouped for adjustment and valuation. A typical query joins the two tables to report tag counts and book quantities by cost group:

• Listing active cost groups: SELECT cost_group_id, cost_group, description FROM cst_cost_groups WHERE disable_date IS NULL;
• Physical inventory reconciliation: SELECT t.tag_number, t.cost_group_id, c.cost_group FROM mtl_physical_inventory_tags t, cst_cost_groups c WHERE t.cost_group_id = c.cost_group_id;
• Reviewing cost group assignments across organizations using CST_COST_GROUP_ASSIGNMENTS.
• Reporting material transaction costing by cost group via MTL_MATERIAL_TRANSACTIONS.COST_GROUP_ID and TRANSFER_COST_GROUP_ID.
• Analyzing period balances using MTL_PERIOD_CG_SUMMARY and CST_PAC_PERIOD_BALANCES.

Related Objects

CST_COST_GROUPS is referenced by a large set of transactional, summary, and interface tables. The most significant dependents include:

• MTL_PHYSICAL_INVENTORY_TAGS (COST_GROUP_ID) — physical inventory tag records.
• MTL_PHYSICAL_ADJUSTMENTS (COST_GROUP_ID) — adjustments generated from physical counts.
• MTL_MATERIAL_TRANSACTIONS (COST_GROUP_ID, TRANSFER_COST_GROUP_ID) — the core inventory transaction table.
• CST_COST_GROUP_ASSIGNMENTS (COST_GROUP_ID) — maps cost groups to items or inventory contexts.
• MTL_PERIOD_CG_SUMMARY (COST_GROUP_ID) — period quantity and value summaries by cost group.
• CST_PAC_ITEM_COSTS and CST_PAC_QUANTITY_LAYERS (COST_GROUP_ID) — perpetual average costing detail and layers.
• MTL_SECONDARY_INVENTORIES (DEFAULT_COST_GROUP_ID) and MTL_PARAMETERS (DEFAULT_COST_GROUP_ID) — default cost group configuration for subinventories and organizations.
• WIP_PAC_PERIOD_BALANCES and WIP_PAC_ACTUAL_COST_DETAILS (COST_GROUP_ID) — work-in-process costing balances.
• CST_RCV_ACQ_COSTS and RCV_SHIPMENT_LINES (COST_GROUP_ID) — receiving and acquisition cost references.
• MTL_CYCLE_COUNT_ENTRIES (COST_GROUP_ID) — cycle count transaction entries.

These relationships confirm that CST_COST_GROUPS acts as a shared reference entity whose integrity is enforced through foreign keys from costing, inventory, receiving, and WIP processes, and whose definition must be established before transactions referencing it can be recorded.