Search Results trgt_whse_id

Overview

The CM_WHSE_EFF 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 is designated as a costing warehouse effectivities table, primarily serving the critical Cost Rollup Process. This table functions as a control mechanism, defining the specific combinations of inventory organizations, cost calendars, items, and warehouses for which cost calculations are effective and should be processed during cost rollup operations. Its existence is fundamental to ensuring accurate and organization-specific product costing in a process manufacturing environment.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which indicate the essential data entities it links together. The primary keys enforce uniqueness on specific business dimensions. The table stores key identifiers that establish effectivity rules, including the organization code (ORGN_CODE), the cost calendar and period codes (CALENDAR_CODE, PERIOD_CODE), the item cost class (ITEMCOST_CLASS), and the item identifier (ITEM_ID). A critical column is TRGT_WHSE_ID, which is part of a primary key, and COSTING_WHSE, which is referenced in a foreign key relationship. These likely distinguish between a target warehouse for the cost effectivity and the costing warehouse from which costs are sourced. The TEXT_CODE column provides a link to descriptive text headers for additional notes or descriptions related to the effectivity rule.

Common Use Cases and Queries

The principal use case for CM_WHSE_EFF is the execution and validation of the Cost Rollup Process. A rollup process would query this table to determine the complete set of item-warehouse-organization-period combinations that require new cost calculations. Common analytical queries involve verifying setup data or troubleshooting rollup issues. For example, to list all effective cost rules for a specific organization and period, one might use a query such as:

• SELECT org.ORGN_NAME, cal.CALENDAR_CODE, itm.ITEM_NO, whse.WHSE_CODE FROM GMF.CM_WHSE_EFF eff JOIN SY_ORGN_MST org ON eff.ORGN_CODE = org.ORGN_CODE JOIN IC_ITEM_MST itm ON eff.ITEM_ID = itm.ITEM_ID JOIN IC_WHSE_MST whse ON eff.COSTING_WHSE = whse.WHSE_ID WHERE eff.PERIOD_CODE = 'JAN-2024';

Data integrity checks are also frequent, ensuring that all foreign key references (e.g., items, calendars) are valid before initiating a costly rollup job.

Related Objects

As evidenced by its foreign key constraints, CM_WHSE_EFF is a central hub that integrates data from several fundamental EBS tables. Key related objects include:

• CM_CLDR_DTL: Provides the cost calendar period details (CALENDAR_CODE, PERIOD_CODE).
• IC_ITEM_MST / IC_ITEM_MST_B: Master inventory item definitions (ITEM_ID).
• IC_COST_CLS: Item cost class definitions (ITEMCOST_CLASS).
• IC_WHSE_MST: Warehouse master information (COSTING_WHSE).
• SY_ORGN_MST / SY_ORGN_MST_B: Inventory organization master data (ORGN_CODE).
• CM_TEXT_HDR: Stores descriptive text blocks (TEXT_CODE).

These relationships underscore the table's role in consolidating master data from inventory, costing, and organizational modules to govern the cost rollup scope.