Search Results mtl_uom_conversions




Deep Dive into MTL_UOM_CONVERSIONS Table in Oracle EBS 12.1.1/12.2.2

The MTL_UOM_CONVERSIONS table is a fundamental data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the repository for unit of measure (UOM) conversion rules. This table enables the system to perform automatic conversions between different units of measure for items, facilitating accurate inventory management, purchasing, order fulfillment, and manufacturing processes.

Table Purpose and Functional Context

In Oracle Inventory and related modules, items may be purchased, stocked, or transacted in different units of measure. The MTL_UOM_CONVERSIONS table stores conversion factors between:

  • Primary and secondary UOMs defined for items
  • Standard UOM pairs (e.g., pounds to kilograms)
  • Item-specific UOM conversions

Key Columns and Relationships

Column NameData TypeDescription
UOM_CONVERSION_IDNUMBERPrimary key identifier
INVENTORY_ITEM_IDNUMBERReferences MTL_SYSTEM_ITEMS_B
ORGANIZATION_IDNUMBERReferences ORG_ORGANIZATION_DEFINITIONS
UOM_CODEVARCHAR2(3)From UOM code
UOM_CLASSVARCHAR2(10)UOM classification
CONVERSION_RATENUMBERConversion factor
DISABLE_DATEDATEDate when conversion becomes inactive

Technical Implementation Details

The table participates in several critical processes:

  1. Inventory Transactions: Converts quantities when receiving, issuing, or transferring items
  2. Order Management: Facilitates UOM conversions between order entry and fulfillment units
  3. BOM Calculations: Supports component quantity conversions in manufacturing

Integration Points

MTL_UOM_CONVERSIONS integrates with:

  • Inventory module (MTL_SYSTEM_ITEMS_B)
  • Order Management (OE_ORDER_LINES)
  • Purchasing (PO_REQUISITION_LINES)
  • Work in Process (WIP_REQUIREMENTS)

Data Management Considerations

Key maintenance aspects include:

  • Conversion rates must be maintained for all active UOM pairs
  • Default conversions exist for standard UOMs (e.g., 1 DOZEN = 12 EACH)
  • Item-specific conversions override standard conversions
  • Conversions can be organization-specific or global

Performance Implications

The table is heavily accessed during:

  • Material transaction processing
  • Order entry and pricing calculations
  • Inventory reporting and valuation

Appropriate indexing on INVENTORY_ITEM_ID, ORGANIZATION_ID, and UOM_CODE is critical for performance.

Customization and Extension Points

The table can be extended through:

  • Custom conversion rules for specialized UOMs
  • Triggers for validation or derivation logic
  • Views for reporting purposes

Understanding MTL_UOM_CONVERSIONS is essential for accurate inventory management and transaction processing in Oracle EBS implementations. Proper configuration and maintenance of this table directly impacts operational efficiency and data integrity across supply chain modules.