Search Results ic_whse_mst

Overview

The IC_WHSE_MST table is the central warehouse master data repository within the Process Manufacturing (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It defines and stores the fundamental attributes for every warehouse used in the manufacturing and inventory management processes. As a core foundation table, it establishes the physical and logical storage locations for items, directly supporting inventory transactions, costing, planning, and financial integration. Its integrity is critical, as evidenced by its extensive network of foreign key relationships with transactional and control tables across the GMI, Cost Management (CM), and other integrated modules.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key structures reveal the essential data points. The table is uniquely identified by the WHSE_CODE, which serves as the primary business key. A second unique key constraint on MTL_ORGANIZATION_ID indicates a critical integration point with Oracle Inventory's organization structure, ensuring a one-to-one mapping between a GMI warehouse and an Inventory organization. Other significant foreign key columns include ORGN_CODE (linking to the SY_ORGN_MST organization master), ADDR_ID for the warehouse's physical address, TEXT_CODE for descriptive flexfields or notes, and TAXLOC_CODE for tax location details.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and as a lookup source. Common operational and analytical queries include retrieving a list of all active warehouses for a given organization, validating a warehouse code during transaction entry, and joining to transactional data for inventory analysis. A typical query pattern involves joining IC_WHSE_MST to the Inventory organization master (MTL_PARAMETERS) via MTL_ORGANIZATION_ID or to item-specific warehouse data in IC_ITEM_WHS.

• Sample Query: SELECT whse_code, description, mtl_organization_id FROM gmi.ic_whse_mst WHERE orgn_code = :p_org_code ORDER BY whse_code;
• Use Case: Generating a warehouse listing for a cycle count setup in IC_CYCL_HDR.
• Use Case: Sourcing valid warehouse codes for a parameter list in a cost accumulation report (CM_ACST_LED, CM_SCST_LED).

Related Objects

IC_WHSE_MST has a vast number of dependent objects, underscoring its foundational role. Key related tables include:

• Core Inventory: IC_ITEM_WHS (item-warehouse specifics), IC_LOCT_INV (location-level inventory), IC_ADJS_JNL (adjustment journals).
• Cost Management: CM_ACST_LED, CM_SCST_LED (cost ledgers), CM_WHSE_ASC (warehouse associations for costing).
• Manufacturing & Planning: GMP_FORM_EFF (formula effectiveness), GMP_ITEM_APS (item planning data).
• Financial Integration: GL_ACCT_MAP, GL_ALOC_BAS (account mapping and allocation bases).
• Master Reference Tables: SY_ORGN_MST (organization), SY_ADDR_MST (address), IC_TEXT_HDR (descriptive text).