Search Results inv_rcv_cache




Overview
Explore in AI Chat

Overview

INV_RCV_CACHE is an internal PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, documented under ETRM 12.2.2 and valid in both 12.1.1 and 12.2.2 environments. It forms part of the Receiving (RCV) and Inventory (INV) execution layer, providing low-level caching and attribute lookup services consumed by higher-level integration, reservation, delivery, inspection, and receipt APIs. The package does not expose a user-facing business workflow; rather, it centralises frequently repeated lookups against inventory master data so that receiving transactions avoid redundant queries. Its name reflects this caching role: callers depend on it to resolve quantity conversions, unit-of-measure codes, and item control attributes within a single transaction context. Documented dependencies are minimal at the package level—only SYS and the STANDARD package—but it sits beneath a broad set of APPS packages, which confirms its position as a foundational helper rather than an entry point.

Key Procedures and Functions

Six program units are documented for the package:

  • CONVERT_QTY — Performs unit-of-measure quantity conversion, allowing callers to express received or inspected quantities in an alternate UOM.
  • GET_PRIMARY_UOM_CODE — Returns the primary unit of measure assigned to an item, used as the base for conversion and validation.
  • GET_SECONDARY_UOM_CODE — Returns the secondary unit of measure for items that carry dual-UOM tracking.
  • GET_SN_CTRL_CODE — Retrieves the serial number control code for an item, indicating whether serial tracking is applied.
  • GET_LOT_CONTROL_CODE — Retrieves the lot control code, indicating whether lot or batch tracking governs the item.
  • GET_CONVERSION_RATE — Supplies the conversion factor between the primary and a target UOM for the item in question.

Parameter lists are not reproduced here; callers should obtain exact signatures from the ETRM dependent-code view. Collectively, these routines answer the attribute questions that receiving and putaway logic must resolve before creating or validating a transaction.

Tables Accessed

The package reads from two tables through APPS synonyms:

  • MTL_SYSTEM_ITEMS — The item master table, source of the primary and secondary UOM codes, serial control code, and lot control code returned by the lookup functions.
  • PLITBLM — Referenced for conversion-rate resolution supporting CONVERT_QTY and GET_CONVERSION_RATE.

No write operations are documented; the package is read-only with respect to these objects, consistent with its caching and lookup purpose.

Usage Notes

INV_RCV_CACHE is not typically invoked directly from Oracle Forms or a concurrent program. It is called indirectly by the receiving and inventory processing stack. Nine documented dependents reference it: INV_RCV_INTEGRATION_APIS, INV_RCV_INTEGRATION_PVT, INV_RCV_RESERVATION_UTIL, INV_RCV_STD_DELIVER_APIS, INV_RCV_STD_INSPECT_APIS, INV_RCV_STD_RCPT_APIS, WMS_ITEM_LOAD, WMS_PUTAWAY_UTILS, and WMS_RCV_PUP_PVT. This dependency set confirms that the package supports standard receipt creation, delivery, inspection, reservation, receiving integration, and Warehouse Management putaway flows.

Custom code should treat INV_RCV_CACHE as an internal API. It is not classified as a public interface (API classification: OTHER), and Oracle may alter it without notice. Where custom development requires identical lookups, the supported route is to call the higher-level APIs—INV_RCV_STD_RCPT_APIS or INV_RCV_INTEGRATION_APIS—rather than invoking INV_RCV_CACHE directly. Analysts tracing performance or conversion discrepancies in receiving transactions should nonetheless inspect this package, since its cached values underpin quantity and control-code resolution across the dependent modules listed above.