Search Results cst_cost_group_assignments_u1

Overview

CST_COST_GROUP_ASSIGNMENTS is an Oracle E-Business Suite table owned by the BOM schema that stores the association between one or more inventory organizations within a legal entity and an organization cost group. In Oracle Cost Management, periodic costs are calculated at the organization cost group level rather than at the individual inventory organization level, so this table acts as the mapping layer that determines which inventory organizations roll up into which cost group for costing runs, cost rollups, and periodic cost calculations.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with a transactional data table that receives inserts and updates as organizations are assigned to or removed from cost groups. It carries the standard FND design data registration (BOM.CST_COST_GROUP_ASSIGNMENTS) and is marked VALID in the ETRM 12.2.2 documentation.

From a Data Vault modeling perspective, the mined link classification is appropriate: this is a link-style object that resolves a many-to-many relationship between cost groups and inventory organizations, carrying descriptive Who columns rather than a dependent satellite of a single parent. The modeling suggestion is therefore to treat it as a link table sitting between the cost group and organization hubs.

Key Information Stored

• COST_GROUP_ID — Cost group identifier; a foreign key to CST_COST_GROUPS. Part of the composite primary key.
• ORGANIZATION_ID — Organization identifier assigned to the cost group; a foreign key to MTL_PARAMETERS. Part of the composite primary key.
• LAST_UPDATE_DATE — Standard Who column recording the last modification date.
• LAST_UPDATED_BY — Standard Who column identifying the user who last updated the row.
• CREATION_DATE — Standard Who column recording row creation date.
• CREATED_BY — Standard Who column identifying the creating user.
• REQUEST_ID — Extended Who column capturing the concurrent request that created or updated the row.
• PROGRAM_APPLICATION_ID — Extended Who column identifying the application of the concurrent program.
• PROGRAM_ID — Extended Who column identifying the concurrent program.
• PROGRAM_UPDATE_DATE — Extended Who column recording the concurrent program update date.
• LAST_UPDATE_LOGIN — Standard Who column capturing the login of the last updating session.

The documented primary key is CST_COST_GROUP_ASSIGNMENTS_PK (COST_GROUP_ID, ORGANIZATION_ID), and the unique index CST_COST_GROUP_ASSIGNMENTS_U1 also covers (COST_GROUP_ID, ORGANIZATION_ID). Because the primary key and the unique index are identical, the business key is the composite of the two foreign keys; there is no separate surrogate key column beyond that composite. This guarantees that any given inventory organization may be assigned to only one cost group at a time.

Common Use Cases and Queries

Typical usage centers on identifying which organizations belong to a cost group before running periodic costing, and on validating that all inventory organizations in a legal entity have been assigned. A common reporting query joins this table to CST_COST_GROUPS and MTL_PARAMETERS to produce an organization-to-cost-group listing:

• SELECT ccga.cost_group_id, ccga.organization_id, mp.organization_code FROM bom.cst_cost_group_assignments ccga, bom.cst_cost_groups ccg, mtl_parameters mp WHERE ccga.cost_group_id = ccg.cost_group_id AND ccga.organization_id = mp.organization_id;
• Identifying organizations with no cost group assignment by outer-joining from MTL_PARAMETERS to CST_COST_GROUP_ASSIGNMENTS and filtering for NULL COST_GROUP_ID.
• Auditing recent changes using LAST_UPDATE_DATE, LAST_UPDATED_BY, and REQUEST_ID to trace which concurrent program introduced assignments.
• Grouping costing results by COST_GROUP_ID after joining to cost tables, since periodic costs are calculated at cost group level.

Related Objects

• CST_COST_GROUPS — referenced via COST_GROUP_ID; the parent cost group definition.
• MTL_PARAMETERS — referenced via ORGANIZATION_ID; holds inventory organization attributes.
• CST_COST_GROUP_ASSIGNMENTS# — the referenced derived object noted in the ETRM dependencies.
• MTL_ORGANIZATIONS — commonly joined for organization naming and legal entity context.
• HR_OPERATING_UNITS / legal entity tables — used to scope cost groups to legal entities for periodic costing.
• CST_PERIOD_CLOSE / periodic costing concurrent programs — consume these assignments during cost calculation.