Results for “ic_cost_cls”

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

Overview

IC_COST_CLS is the item costing class definition table in the Oracle E-Business Suite GMI (Process Manufacturing Inventory) module. It represents the master list of costing classes that can be assigned to process manufacturing items, warehouses, and cost components in order to drive valuation, burdening, and cost rollup behavior. In Oracle Process Manufacturing, a costing class is a grouping mechanism that determines which cost elements, burden percentages, and valuation rules apply to a given item or warehouse context. The table therefore acts as a controlled reference or lookup domain rather than a transactional fact table.

Consistent with the heuristic Data Vault classification mined from its foreign key topology, IC_COST_CLS is best modeled as a hub. It holds a stable business concept — the costing class — and is referenced by multiple satellite-like or link-like dependent tables through the ITEMCOST_CLASS column. The primary key is IC_COST_CLS_PK, defined on the column ITEMCOST_CLASS.

Key Information Stored

The documented metadata is comparatively narrow, so the descriptions below focus on columns that appear explicitly in the ETRM documentation and the columns implied by its key structure.

• ITEMCOST_CLASS — the business key and single-column primary key (IC_COST_CLS_PK). This is the identifier used throughout the module to associate an item, component material, warehouse effectiveness record, warehouse sourcing record, or burden percentage with a costing class.
• TEXT_CODE — a foreign key to IC_TEXT_HDR. This links the costing class to a text/description header record, supplying descriptive or multilingual text associated with the class.

Because the documentation notes that the object is "Not implemented in this database," the authoritative column list may vary by installation or patch level. The primary key and the TEXT_CODE foreign key are the only columns explicitly documented in the ETRM metadata, and both should be treated as the core reference attributes. In a Data Vault model, ITEMCOST_CLASS would serve as the hub hash key source, while TEXT_CODE may be treated as a secondary descriptive attribute or modeled in the associated text hub.

Common Use Cases and Queries

IC_COST_CLS is typically queried as a lookup source: joining it to items, warehouses, or burden tables to resolve a costing class code into descriptive text and to validate that referenced classes exist before assignment. Typical reporting scenarios include listing all items by costing class, auditing which burden percentages apply to a class, and reconciling cost components to their class definition.

A representative validation query joins the costing class to its text header:

SELECT c.ITEMCOST_CLASS, t.TEXT_CODE FROM IC_COST_CLS c, IC_TEXT_HDR t WHERE c.TEXT_CODE = t.TEXT_CODE;

A common reporting query resolves the costing class for each item:

SELECT i.ITEM, i.ITEMCOST_CLASS, c.TEXT_CODE FROM IC_ITEM_MST i LEFT JOIN IC_COST_CLS c ON i.ITEMCOST_CLASS = c.ITEMCOST_CLASS ORDER BY i.ITEMCOST_CLASS;

Given that the documentation marks the table as not implemented in the reference database, queries should include existence checks and left joins where costing class assignment is optional.

Related Objects

The following objects depend on or reference IC_COST_CLS through the ITEMCOST_CLASS column, based on the documented foreign key relationships:

• IC_ITEM_MST.ITEMCOST_CLASS — master item records; the primary consumer of costing class assignments.
• CM_CMPT_MTL.ITEMCOST_CLASS — component material records, linking components to their costing class.
• CM_WHSE_EFF.ITEMCOST_CLASS — warehouse effectiveness records, applying costing classes by warehouse context.
• CM_WHSE_SRC.ITEMCOST_CLASS — warehouse sourcing records, associating sourcing rules with costing classes.
• GMF_BURDEN_PERCENTAGES.ITEMCOST_CLASS — definition of cost burden percentages per costing class.
• IC_TEXT_HDR — referenced by IC_COST_CLS.TEXT_CODE to provide descriptive text for the class.

Together these relationships establish IC_COST_CLS as a central hub for costing behavior across process manufacturing item, warehouse, and burden configuration.