Search Results cm_whse_src_pk




Overview
Explore in AI Chat

Overview

The CM_WHSE_SRC table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a configuration and transactional table that defines and tracks source warehouses used in the costing rollup process. The rollup process is a critical financial operation in manufacturing that aggregates detailed cost data from various sources, such as production batches and inventory transactions, to generate summarized cost information for reporting and analysis. This table essentially maps which specific warehouses, for a given organization, calendar period, and item, are considered as source data points for these cost calculations.

Key Information Stored

The table's structure is designed to uniquely identify a costing source warehouse record through a composite business key and a system-generated surrogate key. The primary business key columns are ORGN_CODE, CALENDAR_CODE, PERIOD_CODE, ITEMCOST_CLASS, ITEM_ID, and WHSE_CODE. This combination ensures that for a specific organization, accounting period, item, and cost class, a designated warehouse is identified as a source. The SRC_WHSE_ID column serves as the unique primary key (CM_WHSE_SRC_PK). Additional descriptive metadata is stored in the TEXT_CODE column, which links to descriptive flexfield text in the CM_TEXT_HDR table. The table's integrity is maintained through foreign key relationships to master data tables for organizations (SY_ORGN_MST), calendars (CM_CLDR_DTL), items (IC_ITEM_MST), warehouses (IC_WHSE_MST), and cost classes (IC_COST_CLS).

Common Use Cases and Queries

The primary use case is the execution and troubleshooting of the cost rollup process. A system administrator or cost accountant may query this table to verify the source warehouse configuration before running a rollup. A common query would be to list all source warehouses for a specific organization and period to validate setup.

  • Validation Query: SELECT orgn_code, calendar_code, period_code, item_id, whse_code FROM gmf.cm_whse_src WHERE orgn_code = '<ORG>' AND calendar_code = '<CAL>' AND period_code = '<PER>' ORDER BY item_id;
  • Rollup Support: The rollup engine internally queries this table to determine the precise set of inventory and production cost transactions to aggregate for each cost dimension.
  • Reporting: Custom reports on rollup source data or audits of costing configurations would join this table with its referenced master data tables (e.g., IC_ITEM_MST for item descriptions).

Related Objects

CM_WHSE_SRC is centrally connected to numerous master data and transactional tables via foreign key constraints. Its primary relationships are as follows:

  • Master Data Tables: SY_ORGN_MST (Organization), CM_CLDR_DTL (Calendar Period), IC_ITEM_MST (Item), IC_WHSE_MST (Warehouse), and IC_COST_CLS (Cost Class).
  • Descriptive Flexfield: CM_TEXT_HDR, via the TEXT_CODE, for storing additional user-defined attributes.
  • Dependent Processes: The table is directly referenced by the costing rollup engine and any related custom programs or interfaces that create or consume rollup source data. While not listed in the metadata, it is logically a key input to the CM_ROLLUP process and related cost calculation packages within GMF.