Search Results mtl_lot_uom_conv_pkg




Overview
Explore in AI Chat

Overview

MTL_LOT_UOM_CONV_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Inventory (INV) module and supports the lot-specific unit of measure conversion infrastructure. In Oracle EBS, standard UOM conversions defined in MTL_UOM_CONVERSIONS apply globally across items. However, certain industries — most notably process manufacturing and lot-controlled environments — require conversions that vary from lot to lot, because physical characteristics such as density, concentration, or specific gravity can differ for each manufactured or received lot. This package provides the DML and concurrency layer for the lot UOM class conversion setup, allowing conversion factors to be defined and maintained on a per-lot, per-UOM-class basis.

The package is classified as an OTHER API in the ETRM repository and has a companion private package, MTL_LOT_UOM_CONV_PVT, which contains the underlying validation and business logic. The public package is a VALID object and is referenced by that private package, reflecting the standard Oracle EBS pattern of separating a thin public DML wrapper from private implementation code.

Key Procedures and Functions

The documented interface exposes four procedures, corresponding to the standard insert/update/delete/lock row pattern used throughout Oracle EBS table-handler packages:

  • INSERT_ROW — Inserts a new lot UOM class conversion record, creating the association between a lot, a UOM class, and the applicable conversion factor.
  • UPDATE_ROW — Modifies an existing lot UOM class conversion record, typically to correct or revise the conversion factor or its effective attributes.
  • DELETE_ROW — Removes a lot UOM class conversion record that is no longer required.
  • LOCK_ROW — Acquires a row-level lock on the target record to enforce concurrency control, ensuring that a record cannot be modified by another session while it is being edited.

These procedures are invoked by the private package MTL_LOT_UOM_CONV_PVT, which applies validation rules and derives the surrogate key from the sequence before delegating the actual DML to this public package.

Tables Accessed

The package operates against the following tables, referenced through APPS synonyms:

  • MTL_LOT_UOM_CLASS_CONVERSIONS — The primary transactional table. Rows in this table define the conversion relationship between a lot and a unit of measure class. The INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW procedures perform their operations directly against this table.
  • MTL_CONVERSION_ID_S — The sequence that supplies the unique conversion identifier for each new row inserted into MTL_LOT_UOM_CLASS_CONVERSIONS.
  • FND_DUAL — The standard Oracle Applications dummy table, used for context lookups and single-row SELECT statements within the package logic.

Usage Notes

MTL_LOT_UOM_CONV_PKG is an internal implementation package and is not intended for direct invocation by end users or custom extensions. It is called exclusively by MTL_LOT_UOM_CONV_PVT, which in turn is surfaced through the Oracle Inventory lot UOM conversion setup user interface. In Oracle EBS 12.1.1 and 12.2.2, the typical entry point is the lot-specific UOM conversion maintenance form or an equivalent setup screen used by inventory administrators to define conversion factors for individual lots.

Because the package performs only row-level DML and locking, it does not implement the validation logic (such as verifying that the lot exists, that the UOM class is valid, or that the conversion factor is positive). Those checks reside in the private package. Custom code should never call MTL_LOT_UOM_CONV_PKG directly, since doing so bypasses the validation layer and can introduce inconsistent conversion data that affects inventory transactions, costing, and quantity calculations across lot-controlled items.