Search Results conversion_id

Overview

The IC_ITEM_CNV 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 definitive repository for storing conversion factors associated with items and specific lots. This functionality is critical in process manufacturing environments where a single item, particularly a bulk material or chemical, can be measured, purchased, or sold in multiple units of measure (e.g., pounds, kilograms, liters, gallons). The table enables the system to accurately perform calculations for transactions, costing, and reporting by maintaining the precise mathematical relationships between different units of measure for a given item-lot combination. Its integrity is enforced through primary and unique keys, ensuring data consistency across the inventory management system.

Key Information Stored

The table's primary purpose is to store conversion factors, which are anchored to specific item and lot identifiers. The key columns, as defined by its constraints, are fundamental to its operation. The CONVERSION_ID serves as the primary key's unique identifier. The combination of ITEM_ID, LOT_ID, and UM_TYPE forms a unique key, guaranteeing that only one conversion factor record exists for a specific unit of measure type per item-lot. The UM_TYPE column categorizes the conversion (e.g., primary, secondary, purchasing, shipping). Other essential columns, implied by its relationships, would store the actual conversion factor values and a link to descriptive text via the TEXT_CODE foreign key to the IC_TEXT_HDR table.

Common Use Cases and Queries

This table is central to any process manufacturing transaction requiring unit of measure conversion. Common use cases include calculating the quantity in the primary unit of measure when a goods receipt is entered in a different unit, determining the cost per transaction unit, and generating reports that standardize quantities across lots. A typical query would join IC_ITEM_CNV with the item master (IC_ITEM_MST) and lot master (IC_LOTS_MST) to retrieve conversion details for reporting or data validation.

• Sample Query Pattern: SELECT i.item_no, l.lot_no, c.um_type, c.conversion_factor FROM gmi.ic_item_cnv c, gmi.ic_item_mst i, gmi.ic_lots_mst l WHERE c.item_id = i.item_id AND c.item_id = l.item_id AND c.lot_id = l.lot_id AND i.item_no = '<ITEM>';
• Reporting Use Case: Generating a list of all active lots for a bulk chemical item, showing available quantities converted from storage units (e.g., drums) into a standard weight unit (e.g., kilograms) for a production planning report.

Related Objects

The IC_ITEM_CNV table is integrated into the GMI schema through defined foreign key relationships, as documented in the ETRM metadata. These relationships are crucial for maintaining referential integrity and for constructing accurate joins in queries and reports.

• IC_LOTS_MST: Linked via ITEM_ID and LOT_ID. This is the primary relationship, tethering conversion factors to a specific inventory lot.
• SY_UOMS_TYP: Linked via UM_TYPE. This validates the unit of measure type code against a central reference table.
• IC_TEXT_HDR: Linked via TEXT_CODE. This allows for attaching descriptive notes or instructions to the conversion factor record.