Search Results mtl_lot_uom_class_conversions




Overview
Explore in AI Chat

Overview

MTL_LOT_UOM_CLASS_CONVERSIONS is an Inventory (INV) module table that stores lot specific unit of measure conversions in Oracle EBS 12.1.1 and 12.2.2. While standard UOM conversions are defined at the item or UOM class level, this table allows a conversion rate to be overridden for a specific lot number, reflecting the reality that batch-manufactured or process-manufactured goods frequently exhibit physical characteristics (density, concentration, potency) that differ from the item standard. The object is owned by the INV schema and is documented as VALID in the ETRM repository, with 22 physical columns.

The heuristic Data Vault classification mined from the foreign key structure is standalone, meaning the table is not modeled as a dependent hub, link, or satellite within a Data Vault construct. From a dimensional modeling perspective, it is best treated as a reference or lookup table keyed by the natural business key of organization, item, lot, and the from/to UOM pair.

Key Information Stored

The surrogate primary key is CONVERSION_ID, enforced by the unique index MTL_LOT_UOM_CLASS_CONV_PK. The documented business-key candidate is the unique index MTL_LOT_UOM_CLASS_CONV_U1, comprising ORGANIZATION_ID, INVENTORY_ITEM_ID, LOT_NUMBER, FROM_UOM_CODE, and TO_UOM_CODE. This composite uniquely identifies the conversion context for a given inventory organization and lot.

Common Use Cases and Queries

The primary use case is resolving the effective conversion rate applicable when transacting a specific lot, particularly where the item standard rate would produce inaccurate quantity-on-hand values. A typical query retrieves the active rate for an organization, item, and lot:

  • Join to MTL_SYSTEM_ITEMS_B and MTL_PARAMETERS on ORGANIZATION_ID to validate the item and organization context.
  • Filter on DISABLE_DATE IS NULL or DISABLE_DATE > SYSDATE to return only active lot conversions.
  • Aggregate by FROM_UOM_CODE and TO_UOM_CODE to report which UOM pairs require lot-level overrides.
  • Compare CONVERSION_RATE against alternate UOM class conversions to detect lots requiring physical re-measurement.

Reporting use cases include lot conversion exception reports, reconciliation between item-level and lot-level rates, and process-manufacturing yield analysis where the event specification disposition drives the conversion.

Related Objects

  • GMD_EVENT_SPEC_DISP — referenced via EVENT_SPEC_DISP_ID; the sole documented foreign key relationship.
  • MTL_SYSTEM_ITEMS_B — supplies the item definition matched on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • MTL_PARAMETERS — provides organization context on ORGANIZATION_ID.
  • MTL_LOT_NUMBERS / MTL_ONHAND_QUANTITIES_DETAIL — supply lot and on-hand context joined on INVENTORY_ITEM_ID and LOT_NUMBER.
  • MTL_UOM_CLASS_CONVERSIONS / MTL_UOM_CONVERSIONS — the class-level and item-level conversion tables that lot-specific rows can override.
  • INV_CONVERT — the public Inventory API that resolves and applies UOM conversion factors, consuming lot-specific rates where defined.