Search Results ic_item_mst

Overview

The IC_ITEM_MST table is the foundational item master data table 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 central repository for defining all items, including raw materials, intermediates, and finished goods, that are managed under the specialized requirements of process manufacturing. Its primary role is to store the comprehensive definition of an item, encompassing its inventory, costing, planning, and quality control characteristics. The table's extensive network of foreign keys to various classification tables underscores its central role in enforcing business rules and enabling detailed process control.

Key Information Stored

The table is structured to hold a wide array of item attributes. The primary identifiers are ITEM_ID (the system-generated primary key) and ITEM_NO (the unique item number, which has a separate unique key constraint). Beyond these identifiers, the table's columns are predominantly foreign keys that link to classification and control tables, defining the item's behavior across the enterprise. Key stored information includes lot and sublot control flags, the primary unit of measure (ITEM_UM), and designations for numerous classes and types. These include inventory class (INV_CLASS), inventory type (INV_TYPE), cost class (ITEMCOST_CLASS), planning class (PLANNING_CLASS), and quality control attributes like grade (QC_GRADE) and hold resolution codes (QCHOLD_RES_CODE). The table also supports relationships to a warehouse item (WHSE_ITEM_ID), a bulk item (BULK_ID), and a quality control item (QCITEM_ID), often via self-referential foreign keys to its own ITEM_ID.

Common Use Cases and Queries

This table is critical for any process manufacturing operation, reporting, or data integration. Common use cases include generating item master data reports, validating item attributes during transaction entry, and supporting custom inventory valuations. A fundamental query retrieves the complete definition of an item by joining IC_ITEM_MST with its many referenced classification tables. For example, to list all active items with their primary unit of measure and inventory class description, one might query:

• SELECT i.ITEM_NO, i.ITEM_DESC, u.UOM_CODE, c.CLASS_DESC FROM IC_ITEM_MST i, SY_UOMS_MST u, IC_INVN_CLS c WHERE i.ITEM_UM = u.UOM_CODE AND i.INV_CLASS = c.INV_CLASS_CODE AND i.DELETE_MARK = 0;

Another critical pattern involves tracing the relationship between a finished good and its bulk or quality control counterpart using the self-referential foreign keys, which is essential for understanding product structures in process manufacturing.

Related Objects

IC_ITEM_MST is the hub for item-related data in GMI, with a vast number of dependent tables and referencing objects. As indicated by its foreign keys, it has direct relationships to over twenty classification tables, such as IC_INVN_CLS, IC_COST_CLS, PS_PLNG_CLS, and QC_GRAD_MST. Crucially, it is referenced by numerous transactional and control tables within the inventory module, including lot master (IC_LOTS_MST), material status (IC_ITEM_STS), and item locations (IC_ITEM_CPS). The table is also central to the GMI Item Master Open Interface (IC_ITEM_IN), which is the standard API for loading item data. Any reporting or analysis of process inventory items will invariably begin with or join to the IC_ITEM_MST table.