Results for “cm_whse_src_pk”

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

Overview

CM_WHSE_SRC is a Process Manufacturing Financials (GMF) table that stores costing source warehouse definitions used by the Rollup process. In Oracle EBS 12.1.1 and 12.2.2, the table functions as a configuration bridge between inventory organizations, cost calendars, cost classes and items, allowing the cost rollup engine to determine which warehouse supplies costed quantities for a given organization, period and item. Each row effectively declares a sourcing relationship: a source warehouse contributing cost data into a target organization for a specified calendar period and item cost class.

Under the heuristic Data Vault classification supplied in the ETRM metadata, CM_WHSE_SRC is modelled as a link. This is consistent with its structure: the primary key, SRC_WHSE_ID, is a surrogate assigned by the CM_WHSE_SRC_PK sequence, while the substantive business content is the association between organization, warehouse, item, cost class and period. The table therefore behaves as a relationship component rather than a descriptive hub or a pure satellite.

Key Information Stored

Each of the 23 documented columns contributes to the sourcing definition, but the following are the most functionally significant:

• SRC_WHSE_ID — surrogate primary key (CM_WHSE_SRC_PK); uniquely identifies each costing source warehouse record.
• ORGN_CODE — the organization consuming the costed quantity; part of the unique business key CM_WHSE_SRC_U1.
• CALENDAR_CODE and PERIOD_CODE — the cost calendar and period in which the sourcing applies.
• ITEMCOST_CLASS — the cost class governing how the item is costed during rollup.
• ITEM_ID — the item for which the source warehouse is defined.
• WHSE_CODE — the source warehouse supplying the costed quantity.
• SOURCING_ALLOC_PCT — the percentage allocation of cost sourcing attributed to the warehouse.
• COST_CATEGORY_ID — the cost category associated with the rollup sourcing entry.
• INVENTORY_ITEM_ID, ORGANIZATION_ID, PERIOD_ID, SOURCE_ORGANIZATION_ID, MASTER_ORGANIZATION_ID, LEGAL_ENTITY_ID — the ID-based counterparts supporting multi-org and legal-entity reporting.
• DELETE_MARK — the standard soft-delete flag; active sourcing rows must have this set to zero.
• TRANS_CNT, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — concurrency and audit columns maintained by the application.

The unique index CM_WHSE_SRC_U1 covers ORGN_CODE, CALENDAR_CODE, PERIOD_CODE, ITEMCOST_CLASS, ITEM_ID and WHSE_CODE, establishing the true business key of a sourcing assignment.

Common Use Cases and Queries

The primary use case is troubleshooting and validating the costing rollup. Cost accountants query CM_WHSE_SRC to confirm which source warehouse contributes to an item's cost in a given period, and to verify that allocation percentages sum correctly where multiple warehouses are defined.

A typical pattern filters active rows for an organization and period, then joins to the warehouse and item masters:

• SELECT s.WHSE_CODE, s.ITEM_ID, s.ITEMCOST_CLASS, s.SOURCING_ALLOC_PCT FROM GMF.CM_WHSE_SRC s WHERE s.ORGN_CODE = :orgn AND s.CALENDAR_CODE = :cal AND s.PERIOD_CODE = :period AND s.DELETE_MARK = 0;
• Validate allocation integrity: SELECT ITEM_ID, SUM(SOURCING_ALLOC_PCT) FROM GMF.CM_WHSE_SRC WHERE ORGN_CODE = :orgn AND DELETE_MARK = 0 GROUP BY ITEM_ID HAVING SUM(SOURCING_ALLOC_PCT) <> 100;
• Resolve the source warehouse description by joining WHSE_CODE to IC_WHSE_MST and ORGN_CODE to SY_ORGN_MST.
• Audit recently changed sourcing definitions using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Reporting extracts frequently drive from the ID columns (ORGANIZATION_ID, INVENTORY_ITEM_ID, PERIOD_ID, LEGAL_ENTITY_ID) where a dimensional or multi-org view is required.

Related Objects

CM_WHSE_SRC is referenced by, and depends upon, the following significant GMF and EBS objects through documented foreign keys:

• IC_WHSE_MST — joined on WHSE_CODE; provides warehouse master details.
• IC_ITEM_MST and IC_ITEM_MST_B — joined on ITEM_ID; supply the item definition.
• IC_COST_CLS — joined on ITEMCOST_CLASS; defines the cost class.
• SY_ORGN_MST and SY_ORGN_MST_B — joined on ORGN_CODE; provide organization details.
• CM_CLDR_DTL — joined on CALENDAR_CODE and PERIOD_CODE; supplies calendar period detail.
• CM_TEXT_HDR — joined on TEXT_CODE; supplies descriptive text.
• FV_LEGAL_ENTITIES — joined on LEGAL_ENTITY_ID; supports legal-entity level reporting.

These relationships confirm that CM_WHSE_SRC acts as the intersection point between inventory, cost, calendar and organization masters within the Process Manufacturing costing rollup.