Search Results cm_whse_asc_pk

Overview

The CM_WHSE_ASC (Costing Warehouse Association) table is a core data object within the Oracle Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to establish and maintain a critical mapping relationship between inventory warehouses and costing warehouses. This association is fundamental for the accurate flow of financial data, enabling the OPM (Oracle Process Manufacturing) system to correctly attribute inventory transaction costs from operational inventory warehouses to the designated financial or costing warehouses used for ledger accounting and cost management.

Key Information Stored

The table stores the association rules, which are uniquely identified by its primary key columns. The most significant columns include the warehouse codes and the effective date range for the association.

• COST_WHSE_CODE: The code for the costing warehouse to which financial transactions are posted.
• WHSE_CODE: The code for the physical or logical inventory warehouse where material transactions occur.
• EFF_START_DATE: The date from which the warehouse association becomes active. This, along with the two warehouse codes, forms the table's primary key (CM_WHSE_ASC_PK).
• TEXT_CODE: A foreign key to the CM_TEXT_HDR table, allowing for descriptive comments or notes to be attached to the association rule.

The structure ensures that a single inventory warehouse can be linked to a specific costing warehouse for a defined period, supporting complex organizational and accounting structures.

Common Use Cases and Queries

This table is central to cost collection and accounting integrity. A primary use case is during inventory transactions (e.g., issues, receipts, transfers), where the system queries CM_WHSE_ASC to determine the correct costing warehouse for general ledger impact. It is also crucial for period-end closing procedures and cost reconciliation reports. Common queries involve retrieving active associations for reporting or validation.

-- Find all active inventory warehouses mapped to a specific costing warehouse
SELECT whse_code, cost_whse_code, eff_start_date
FROM gmf.cm_whse_asc
WHERE cost_whse_code = 'MAIN_COST_WHSE'
  AND SYSDATE >= eff_start_date
  AND (eff_end_date IS NULL OR SYSDATE <= eff_end_date);

-- Validate warehouse associations for a transaction date
SELECT *
FROM gmf.cm_whse_asc
WHERE whse_code = :p_inv_whse
  AND :p_txn_date >= eff_start_date
  AND (:p_txn_date <= eff_end_date OR eff_end_date IS NULL);

Related Objects

CM_WHSE_ASC has defined relationships with other key GMF and inventory tables, as indicated by its foreign keys.

• IC_WHSE_MST: The table is referenced twice via foreign keys. Both CM_WHSE_ASC.COST_WHSE_CODE and CM_WHSE_ASC.WHSE_CODE must be valid warehouse codes existing in IC_WHSE_MST (Inventory Warehouse Master).
• CM_TEXT_HDR: The TEXT_CODE column is a foreign key to this table, enabling descriptive text storage for the association.

Given its purpose, this table is also intrinsically linked to core costing and inventory transaction tables (e.g., CM_OPM_TRANS, IC_TRAN_PND) which rely on the mapping it provides to post financial data correctly.