Search Results ic_invn_cls




Overview
Explore in AI Chat

Overview

The table IC_INVN_CLS is a foundational data object within the Oracle Process Manufacturing (OPM) module, specifically under the GMI - Process Manufacturing Inventory product. Its primary role is to serve as a master repository for inventory class definitions. An inventory class is a critical classification used to group and manage items with similar characteristics throughout the OPM system, influencing costing, reporting, and inventory control policies. While the provided metadata indicates it is "Not implemented in this database" for the specific instance documented, its defined structure and relationships confirm its intended purpose as a core reference table for standardizing inventory item categorization in a fully implemented environment.

Key Information Stored

The table's structure is centered around the inventory class identifier. The primary key column is ICINV_CLASS, which uniquely identifies each inventory class code. Based on the foreign key relationships documented, other significant columns include TEXT_CODE, which links to descriptive text in the IC_TEXT_HDR table, and REPORTING_UOM, which links to a unit of measure defined in SY_UOMS_MST to specify the default reporting unit for items belonging to that class. This establishes the inventory class as a carrier for both descriptive and procedural metadata for items.

Common Use Cases and Queries

The primary use case is the classification and consistent management of inventory items. During item master setup (IC_ITEM_MST), an inventory class is assigned, thereby inheriting the class's reporting UOM and other defined attributes. Common queries involve listing all defined classes or identifying items associated with a specific class for reporting or analysis. For example, a query to find all items and their reporting UOM based on their inventory class would join IC_ITEM_MST to IC_INVN_CLS and then to SY_UOMS_MST. Another critical use case is in defining purge parameters, as shown by the foreign key from IC_PURG_PRM, where inventory classes can be used as criteria for data archival or purging processes.

Related Objects

  • IC_ITEM_MST: The primary consumer of this table. The INV_CLASS column in IC_ITEM_MST is a foreign key referencing IC_INVN_CLS, assigning each item to a class.
  • IC_PURG_PRM: References IC_INVN_CLS via its INV_CLASS column to specify which inventory classes are subject to purge rules.
  • IC_TEXT_HDR: Linked via TEXT_CODE to store multilingual descriptions for the inventory class.
  • SY_UOMS_MST: Linked via REPORTING_UOM to define the standard unit of measure for reporting on items within the class.