Search Results lot_uom_conv_orgtxf

Overview

APPS.INV_LOT_API_PUB is the public PL/SQL API for Oracle Inventory lot number operations in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the business rules governing lot creation, validation, attribute assignment, inter-organization UOM conversion, and child lot handling, providing a supported programmatic interface to the MTL_LOT_NUMBERS entity and its related tables. The package is a public (PUB) classification API, meaning it is intended to be called from external code rather than from within the package itself. Its header line (120.51.12020000.6, dated 2013/01/31) reflects maintenance through the 12.2 code line. Internally it defines a record type, non_wms_lot_att_rec_type, which mirrors the fifteen descriptive flexfield attribute columns and the attribute category on MTL_LOT_NUMBERS, and a helper procedure, get_lot_att_from_source(), used to propagate WMS and non-WMS lot attributes from a source lot when a transaction is intransit.

Key Procedures and Functions

The package exposes twenty-six documented procedures and functions. The core creation path is served by CREATE_INV_LOT, INSERTLOT, and INSERTTRXLOT, which respectively create a lot definition, insert a row into the lot master, and populate the transaction-level lot table. UPDATE_INV_LOT performs the corresponding maintenance operation.

Validation routines form a substantial portion of the API. VALIDATE_UNIQUE_LOT enforces uniqueness of a lot number within its organization and item context; VALIDATE_LOT_ATTR_INFO and VALIDATE_LOT_ATTR_IN_PARAM check lot attribute and parameter integrity; VALIDATE_CHILD_LOT and VALIDATE_LOT_INDIVISIBLE, together with CHECK_LOT_INDIVISIBILITY, enforce child lot relationships and indivisibility constraints; VALIDATE_QUANTITIES checks quantity consistency; and WMS_LOT_ATTR_VALIDATE validates Warehouse Management System lot attributes, supported by SET_WMS_INSTALLED_FLAG, which determines whether WMS integration is active.

Attribute handling is provided by POPULATEATTRIBUTESColumn, which fills the DFF attribute columns, and SET_FIRSTSCAN, which records first-scan behavior. Child lot maintenance uses INS_MTL_CHILD_LOT_NUM and UPD_MTL_CHILD_LOT_NUM. Lot number generation is handled by AUTO_GEN_LOT, which draws from the numeric suffix sequence.

The user search term lot_uom_conv_orgtxf corresponds to two documented members: LOT_UOM_CONV_ORGTXF and CREATE_LOT_UOM_CONV_ORGTXF. These functions/routines manage lot-specific unit-of-measure conversions across organizations, working with the lot UOM class conversion data so that lot-based UOM conversion factors are validated and stored consistently for an inventory organization.

Tables Accessed

The package reads and writes MTL_LOT_NUMBERS, the lot master, and MTL_LOT_UOM_CLASS_CONVERSIONS for lot-level UOM conversion data. Child lot relationships are held in MTL_CHILD_LOT_NUMBERS, while transaction context is captured in MTL_MATERIAL_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS_TEMP, with staging in MTL_TRANSACTION_LOTS_TEMP. Item validation uses MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and MTL_SYSTEM_ITEMS_KFV, and organization defaults come from MTL_PARAMETERS. Sequences MTL_CONVERSION_ID_S, MTL_GEN_OBJECT_ID_S, and MTL_LOT_NUMERIC_SUFFIX_S supply surrogate keys and auto-generated lot suffixes. FND_DUAL, FND_USER, and MTL_PARAMETERS support lookups and session context.

Usage Notes

INV_LOT_API_PUB is invoked from Inventory forms and transaction flows, from concurrent programs that create or validate lots in bulk, and from custom PL/SQL that needs to create lots without direct DML. Because it is referenced by twenty-seven other packages, it functions as a shared dependency and should not be modified in place; callers should be aware that the API performs its own validation, so redundant checks are unnecessary. Custom code should always consume the OUT return status rather than relying on exceptions, and should supply organization and item identifiers explicitly.