Search Results inv_cache




Overview
Explore in AI Chat

Overview

INV_CACHE is a PL/SQL package body owned by the APPS schema that functions as a session-level caching and memoization layer for Oracle Inventory and Order Management transaction processing. Rather than serving a single business function, it provides a shared repository of cached record handles for the inventory entities most frequently re-queried during high-volume transaction flows: organizations and their parameters, items, subinventories, locators, locator/subinventory transfer combinations, material transaction records, on-hand quantity detail rows, sales orders, delivery details, and picking batches.

The package is classified as OTHER (not a published open interface or public API). It contains no user-facing business rule; its value is performance. During transaction manager processing, move order execution, pick release, and shipping confirmation, the same rows in MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_ITEM_LOCATIONS, and related tables are referenced repeatedly. INV_CACHE allows these records to be resolved once and reused, and also allows derived attributes (such as organization installation status and order-line identifiers) to be propagated to calling routines. The object is reported VALID in the ETRM 12.2.2 metadata and is heavily relied upon, being referenced by 88 other database objects, while itself referencing no external database objects of its own.

Key Procedures and Functions

The documented interface comprises 23 procedures and functions. They are uniformly structured as setter routines, each establishing the current value of a cached entity that subsequent processing can read.

Tables Accessed

The package resolves rows through APPS synonyms. Organization and setup context comes from MTL_PARAMETERS and MTL_CLIENT_PARAMETERS. Item and location data come from MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, and MTL_SECONDARY_INVENTORIES. Transaction processing uses MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TRANSACTION_TYPES, MTL_TXN_REQUEST_HEADERS, and MTL_TXN_REQUEST_LINES. Availability and on-hand checks use MTL_ONHAND_QUANTITIES_DETAIL. Order Management integration uses OE_ORDER_LINES_ALL and MTL_SALES_ORDERS. Shipping and pick release use WSH_DELIVERY_DETAILS and WSH_PICKING_BATCHES, and project context uses PJM_ORG_PARAMETERS.

Usage Notes

INV_CACHE is an internal dependency rather than an invocable API. It is not exposed through Oracle Forms as a user-facing call and is not intended for direct invocation by custom code; the Oracle EBS 12.1.1 and 12.2.2 technical documentation does not publish it as a supported public interface. Its documented dependents and the breadth of its referencing objects indicate it is invoked from within Inventory transaction manager, move order, pick release, and shipping internals, including calls originating from INV_INSTALL, OE_INSTALL, OE_HEADER_UTIL, and the STANDARD schema. Customizations should treat it as opaque and avoid relying on its procedure signatures, as they are subject to change between releases and are protected by Oracle proprietary and confidentiality terms.