Search Results cst_cost_group_assignments




Overview
Explore in AI Chat

Overview

CST_COST_GROUP_ASSIGNMENTS is a table owned by the BOM schema in Oracle E-Business Suite, categorized under the Bills of Material product family. As documented in the ETRM reference for releases 12.1.1 and 12.2.2, its purpose is to store the organization assignment for cost groups. In practical terms, the table acts as the intersection that determines which cost groups are enabled for which inventory organizations across the enterprise.

Cost groups are a foundational construct in Oracle Cost Management. They allow organizations to partition item costs, valuation accounts, and cost accumulation logic into logical buckets — for example, separating material, material overhead, resource, outside processing, and overhead cost elements into distinct groups. The CST_COST_GROUP_ASSIGNMENTS table governs the scope of each cost group by binding it to one or more inventory organizations defined in MTL_PARAMETERS. Without a row in this table, a cost group has no organizational footprint and cannot participate in cost rollups, transaction costing, or inventory valuation.

From a dimensional modeling perspective, the mined metadata suggests a Data Vault classification of link. This is a suitable heuristic: the table resolves a many-to-many relationship between cost groups and organizations, carrying no descriptive attributes of its own beyond the standard WHO audit columns. It functions as a pure associative entity, and modelers building a Data Vault or star schema should treat it accordingly.

Key Information Stored

The documented schema exposes eleven columns. The most operationally significant are:

The composite primary key CST_COST_GROUP_ASSIGNMENTS_PK spans COST_GROUP_ID and ORGANIZATION_ID. The unique index CST_COST_GROUP_ASSIGNMENTS_U1 is defined on the same two columns, meaning the business key and the surrogate (composite) key are identical here. There is no separate single-column surrogate; the pair of foreign keys forms the identity of each row. Consequently, no duplicate assignment of the same cost group to the same organization can exist, which enforces referential integrity at the business level.

Common Use Cases and Queries

Typical reporting and validation scenarios center on confirming which cost groups are active in a given organization, or conversely, listing all organizations assigned to a specific cost group. A representative query joining both parent tables returns a readable inventory:

  • Identify all cost groups for an organization: SELECT cg.cost_group_id, cg.cost_group FROM cst_cost_groups cg, cst_cost_group_assignments a WHERE cg.cost_group_id = a.cost_group_id AND a.organization_id = :org_id;
  • Audit assignment creation: filter on CREATION_DATE and CREATED_BY to trace when and by whom an organization was added to a cost group.
  • Detect orphaned cost groups: outer-join CST_COST_GROUPS to this table to find cost groups with no organizational assignment.
  • Reconcile concurrent program loads: query REQUEST_ID and PROGRAM_ID to link assignments back to the specific cost group assignment concurrent request.

These queries support cost accounting reconciliation, organization setup validation during implementations, and periodic audits of valuation configuration.

Related Objects

The most significant related objects, derived from the documented foreign key relationships, include:

  • CST_COST_GROUPS — parent table holding cost group definitions; joined on COST_GROUP_ID.
  • MTL_PARAMETERS — inventory organization master; joined on ORGANIZATION_ID.
  • CST_COST_GROUP_ASSIGNMENTS_PK and CST_COST_GROUP_ASSIGNMENTS_U1 — the primary key constraint and its supporting unique index.
  • CST_ITEM_COSTS and CST_COST_ELEMENTS — cost management tables that consume cost group assignments when valuing inventory transactions.
  • MTL_SYSTEM_ITEMS_B — item master, typically joined indirectly through organization to validate costing scope.

Together these objects form the configuration backbone for multi-organization cost management in Oracle EBS.