Results for “ic_invn_cls”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IC_INVN_CLS is a foundational master data table within the Oracle E-Business Suite Process Manufacturing (OPM) module, specifically belonging to the GMI – Process Manufacturing Inventory product. It stores the definition of inventory classes, which are user-defined groupings used to categorize inventory items throughout the OPM (Oracle Process Manufacturing) application. Inventory classes allow planners, warehouse personnel, and reporting systems to segment items by functional, physical, or reporting characteristics — for example, distinguishing raw materials, packaging, intermediates, or finished goods.

Under the heuristic Data Vault classification derived from its foreign key structure, IC_INVN_CLS is assessed as satellite-leaning. This suggests the table behaves primarily as a descriptive attribute container that hangs off a central business key rather than acting as an independent hub or a many-to-many link. The classification should be treated as a modeling suggestion rather than a definitive architectural mandate, particularly because the table also serves as a parent reference for other master data objects.

The documented metadata notes that the table is not implemented in the reference database, meaning its presence depends on whether OPM Inventory class functionality has been configured in a given environment.

Key Information Stored

The primary key of IC_INVN_CLS is defined by the constraint IC_INVN_CLS_PK, which enforces uniqueness on the ICINV_CLASS column. This column is the business identifier for the inventory class — the value that operators see when assigning a class to an item or a purchasing parameter. It therefore functions simultaneously as the surrogate primary key and the principal business-key candidate, since no separate alternate unique index is documented beyond the PK constraint.

Because the documented metadata exposes only a limited column set, the following are the most significant columns and their roles:

• ICINV_CLASS — The inventory class code. This is the primary key column and the value referenced by downstream tables. It is the single most important attribute in the table.
• TEXT_CODE — A foreign key to IC_TEXT_HDR. This links the inventory class to the text header infrastructure used throughout OPM for storing descriptive or multilingual text blocks associated with master data records.
• REPORTING_UOM — A foreign key to SY_UOMS_MST. This designates the unit of measure used when the inventory class is referenced in reporting contexts, allowing classes to standardize quantity presentation across items that may otherwise carry differing stocking UOMs.

Additional descriptive columns likely exist (such as class description and status flags), but they are not documented in the supplied metadata and should be confirmed against the database dictionary in a live instance.

Common Use Cases and Queries

IC_INVN_CLS is most commonly queried when validating or reporting on item classification hierarchies, cost grouping, and UOM-driven reporting. A typical validation query joins items to their assigned class:

• Listing all items within a given inventory class: SELECT i.ITEM, i.DESCRIPTION, c.ICINV_CLASS FROM IC_ITEM_MST i, IC_INVN_CLS c WHERE i.INV_CLASS = c.ICINV_CLASS;
• Resolving the reporting UOM for a class: SELECT c.ICINV_CLASS, u.UM, u.DESCRIPTION FROM IC_INVN_CLS c, SY_UOMS_MST u WHERE c.REPORTING_UOM = u.UM;
• Auditing classes that carry associated text: SELECT c.ICINV_CLASS, t.TEXT_CODE FROM IC_INVN_CLS c, IC_TEXT_HDR t WHERE c.TEXT_CODE = t.TEXT_CODE;
• Identifying purchasing parameters tied to a class: SELECT p.INV_CLASS, p.PURCHASING_UM FROM IC_PURG_PRM p, IC_INVN_CLS c WHERE p.INV_CLASS = c.ICINV_CLASS;

Reporting use cases include inventory valuation summaries grouped by class, UOM conversion audits where reporting UOMs differ from stocking UOMs, and referential integrity checks before deleting or reclassifying a class definition.

Related Objects

The following objects participate in documented foreign key relationships with IC_INVN_CLS:

• IC_ITEM_MST — References IC_INVN_CLS via IC_ITEM_MST.INV_CLASS = IC_INVN_CLS.ICINV_CLASS. This is the principal consumer of inventory classes, assigning each item to exactly one class.
• IC_PURG_PRM — References IC_INVN_CLS via IC_PURG_PRM.INV_CLASS = IC_INVN_CLS.ICINV_CLASS, linking purchasing parameter defaults to inventory classes.
• IC_TEXT_HDR — Referenced by IC_INVN_CLS via IC_INVN_CLS.TEXT_CODE = IC_TEXT_HDR.TEXT_CODE, providing descriptive text storage.
• SY_UOMS_MST — Referenced by IC_INVN_CLS via IC_INVN_CLS.REPORTING_UOM = SY_UOMS_MST.UM, supplying unit-of-measure validation for the reporting UOM.

Together these relationships position IC_INVN_CLS as a central classification reference within OPM Inventory, mediating between item master data, purchasing defaults, text metadata, and UOM master data.