Search Results whseinv_id

Overview

The IC_WHSE_INV table is a core data structure within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the primary repository for warehouse-specific inventory rules and parameters. This table establishes and maintains the business logic that governs how individual items are managed within specific warehouses, acting as a critical junction between the item master (IC_ITEM_MST) and the warehouse master (IC_WHSE_MST). Its configuration directly impacts inventory transactions, costing, shipping, and cycle counting processes for process manufacturing operations.

Key Information Stored

The table stores configuration attributes that define item-warehouse relationships. Its structure is anchored by a composite primary key on ITEM_ID and WHSE_CODE, ensuring a unique rule set per item per warehouse. Important columns include WHSEINV_ID (a surrogate primary key), WHSE_ABCCODE for ABC analysis ranking, and various classification codes that link to other control tables. These classification codes—such as COUNT_CLASS (cycle counting), FRT_CLASS (freight), GL_CLASS (general ledger), and SHIP_CLASS (shipping)—are foreign keys that determine the specific policies applied. The TEXT_CODE column allows for attaching descriptive notes or instructions.

Common Use Cases and Queries

This table is central to operational and reporting activities. A common use case is validating or retrieving the applicable rules before processing a material transaction for an item in a given warehouse. For reporting, it is frequently joined to item and warehouse masters to analyze rule coverage. Key SQL patterns include identifying items missing warehouse-specific rules or listing all GL classes assigned across warehouses. For example, a query to find the cycle counting class for an item in a specific warehouse would join IC_WHSE_INV to IC_CRUL_CLS via the COUNT_CLASS column. Data maintenance typically occurs through the application's warehouse rules form, not via direct SQL updates.

Related Objects

As indicated by its foreign keys, IC_WHSE_INV has extensive relationships within the GMI schema. It is a child table of IC_ITEM_MST (item master) and IC_WHSE_MST (warehouse master). It references multiple classification masters: IC_CRUL_CLS, IC_FRGT_CLS, IC_GLED_CLS, IC_SHIP_CLS, and IC_RANK_MST. It also relates to IC_TEXT_HDR for descriptive text. Crucially, it is a parent table to IC_ITEM_CDT (item cost details), meaning cost records are maintained at the same item and warehouse grain. This network of relationships underscores its role as a pivotal control point in the Process Manufacturing inventory model.