Search Results convert_qty

Overview

INV_RCV_CACHE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides a cached access layer for inventory receiving operations, reducing redundant queries against inventory item master data and unit-of-measure conversion logic. Oracle classifies the package as API classification OTHER, indicating it is an internal helper rather than a public, supported interface.

The package is referenced by nine other packages, which confirms its role as a shared utility used across the receiving and inventory flows. Because it is not a documented public API, direct invocation by customers is discouraged; it is intended primarily for internal consumption by Oracle-developed code that needs fast, repeatable retrieval of UOM and control attributes for inventory items. Cache-style access is particularly valuable in receiving and mobile receiving screens, where the same item attributes are queried repeatedly within a session.

Key Procedures and Functions

The package exposes six documented units:

• CONVERT_QTY — The central function surfaced by the user search term p_inventory_item_id. It converts a quantity from one unit of measure to another, parameterized by inventory item, source and destination UOM codes, optional precision, and (via Bug#9570776) optional organization and lot number. When p_inventory_item_id is null, the package bypasses caching and calls INV_CONVERT.INV_UM_CONVERT directly, deriving the item's UOM relationships without a cached entry.
• GET_PRIMARY_UOM_CODE — Returns the primary unit of measure associated with an inventory item.
• GET_SECONDARY_UOM_CODE — Returns the secondary unit of measure for an item where dual-UOM tracking applies.
• GET_SN_CTRL_CODE — Returns the serial number control code for an item, indicating whether serial number capture is required.
• GET_LOT_CONTROL_CODE — Returns the lot control code for an item, indicating whether lot entry is mandatory.
• GET_CONVERSION_RATE — Returns the conversion rate between two UOMs for a given item, used as the basis for quantity conversion.

An internal PRIVATE procedure, print_debug, writes trace output when the profile option INV_DEBUG_TRACE is enabled, gated through INV_MOBILE_HELPER_FUNCTIONS.TRACELOG.

Tables Accessed

The documented table references are MTL_SYSTEM_ITEMS and PLITBLM, both accessed through APPS synonyms. MTL_SYSTEM_ITEMS is the item master, supplying primary and secondary UOM codes, serial number control, and lot control attributes. PLITBLM serves as the PL/SQL item cache table backing the package's caching behavior; it stores pre-fetched item attribute rows so that repeated calls avoid a full query against MTL_SYSTEM_ITEMS. Caching in this manner is consistent with the package name and the receiving context, where item attributes are read many times per transaction.

Usage Notes

INV_RCV_CACHE is invoked internally by the nine dependent packages that reference it, typically from receiving forms, mobile receiving pages, and concurrent programs that perform quantity validation and UOM conversion. Custom code should call documented public APIs such as INV_CONVERT rather than INV_RCV_CACHE directly, since Oracle does not guarantee the interface across releases. The package honors the INV_DEBUG_TRACE profile option, so debugging can be enabled without code changes—set the profile to 1 to emit trace statements through the mobile helper trace log. Because p_inventory_item_id is the key parameter for conversion, callers must supply a valid item ID to benefit from caching; null values force the slower, uncached conversion path.