Search Results uom_noitem_err

Overview

GMICUOM is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides unit-of-measure (UOM) conversion services for Oracle Process Manufacturing (OPM). Its principal responsibility is to translate a quantity expressed in one unit of measure into an equivalent quantity in another unit of measure for a given item, optionally scoped by lot, formula, or laboratory type. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the package owner, which is significant in an environment where OPM schemas and their synonyms are widely distributed.

The source header identifies the file as gmicuoms.pls, version 115.2, last shipped in November 2002, indicating the package is a long-standing component of the OPM code base carried forward into EBS 12.1.1 and 12.2.2. It defines a set of subtypes, constants, and error codes that standardize the conversion contract across callers. Among these are subtypes for item, formula, lot, quantity, and UOM code, and a family of negative return codes (UOM_LAB_TYPE_ERR, UOM_CUR_UOMTYPE_ERR, UOM_NEW_UOMTYPE_ERR, UOM_INVUOM_ERR, UOM_INV_UOMTYPE_ERR, UOM_CUR_CONV_ERR, UOM_LAB_CONST_ERR, UOM_LAB_CONV_ERR, UOM_NEW_CONV_ERR, and UOM_NOITEM_ERR) that callers test to diagnose failed conversions involving laboratory types, UOM classes, and missing item conversion definitions. The package is referenced by 46 other packages, confirming its role as a shared, foundational utility rather than a module-specific routine.

Key Procedures and Functions

• ICUOMCV — A procedure that converts a quantity for a specified item and lot, taking the current quantity and current UOM as input and returning the equivalent quantity in a new UOM through an OUT NOCOPY parameter. It is the general-purpose conversion entry point for lot-scoped inventory quantities.
• ICUOMCVL — A procedure that performs conversion in the context of a formula and laboratory type, accepting a conversion factor in addition to the item, formula, quantity, and current and new UOM. It supports laboratory-specific conversion rules that differ from standard inventory conversions.
• UOM_CONVERSION — A function returning a numeric converted quantity, accepting item, lot, quantity, current UOM, new UOM, and an atomic flag. Per the inline comment, it is intended for all modules except Laboratory Management and CRP/I2 integration, making it the standard conversion path for general OPM processing.
• I2UOM_CV — The member associated with the user search term "i2uom_cv." It provides the conversion service required for the I2 (CRP) integration path, complementing UOM_CONVERSION, which explicitly excludes CRP/I2 usage. This separation exists because integration conversions must honor external system assumptions about atomic units and item conversion definitions.

Tables Accessed

The package reads OPM and Oracle Inventory conversion and master data through APPS synonyms. IC_ITEM_CNV supplies item conversion factors and lot associations; IC_LOCT_INV supplies on-hand quantities used to type the quantity parameter and validate inventory context; SY_UOMS_MST and SY_UOMS_TYP provide UOM codes and UOM class definitions required to validate that source and target units are compatible; LM_ITEM_DAT supplies formula and laboratory type data used by ICUOMCVL. MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE, and MTL_UOM_CONVERSIONS provide the Oracle Inventory item and UOM definition and conversion data needed when OPM conversions intersect with standard Inventory items.

Usage Notes

GMICUOM is invoked primarily from OPM forms and from other PL/SQL packages rather than directly by end users. Because it is referenced by 46 packages, changes to its behavior carry broad regression risk, and the AUTHID CURRENT_USER declaration requires callers to hold the necessary privileges on the underlying tables. Custom code performing OPM quantity conversions should call UOM_CONVERSION for standard processing or I2UOM_CV for CRP/I2 integration, testing the documented negative return codes and raising an application error when conversion cannot be resolved due to a missing item conversion, a mismatched UOM class, or an invalid laboratory type.