Search Results set_pick_lots

Overview

GMI_RESERVATION_UTIL is an internal utility package in the Oracle Process Manufacturing (OPM) reservation subsystem. Its stated purpose, per the package header, is to house private utilities relating to OPM reservation, bridging Oracle Order Management (OM) demand with OPM lot, inventory, and warehouse data. The package supports reservation, allocation, and default lot creation for sales order lines that must be satisfied from OPM-controlled inventory. Because reservation logic in OPM requires translating between Oracle Applications items/UOMs and their OPM equivalents, and because lot selection must respect item control rules and horizon periods, this body consolidates the supporting lookups, validations, and transactions used by higher-level reservation APIs. It is classified as a UTIL package in ETRM 12.2.2, owned by APPS, and is referenced by 38 other packages, confirming its role as a shared internal dependency rather than a user-facing entry point.

Key Procedures and Functions

• CHECK_MISSING — identifies missing or incomplete reservation data prior to processing; historically included validation of the demand source header (later commented out per B2418860).
• VALIDATION_FOR_QUERY — validates inputs used when querying reservation candidates.
• VALIDATION_BEFORE_ALLOCATE — performs pre-allocation checks before quantities are assigned.
• GET_DEFAULT_LOT / CREATE_DEFAULT_LOT / CREATE_EMPTY_DEFAULT_LOT / CREATE_DFLT_LOT_FROM_SCRATCH / DEFAULT_LOT_EXIST / GET_DEFAULTLOT_FROM_ITEMCTL / BALANCE_DEFAULT_LOT — resolve, create, test for, and balance default lots, honoring item control rules stored in IC_ITEM_MST.
• GET_ALLOCATION — retrieves allocation details for a reservation.
• GET_OPMUOM_FROM_APPSUOM / GET_APPSUOM_FROM_OPMUOM — convert units of measure between Oracle Applications and OPM representations.
• GET_ORG_FROM_SO_LINE / GET_OPM_ITEM_FROM_APPS — derive the OPM organization and item from sales order and Apps item context.
• REALLOCATE — reassigns reserved quantities when allocation must be revised.
• PRINTLN — diagnostic output utility.
• VALIDATION_ICTRAN_REC / CREATE_TRANSACTION_FOR_RCV — validate pending inventory transactions and create receiving transactions.
• SET_PICK_LOTS — the procedure most often searched: it establishes pick lot assignments for reservation, using default lot logic where a lot is not yet determined.

Tables Accessed

Through APPS synonyms the package reads and writes OPM master and transaction tables including IC_ITEM_MST, IC_LOCT_INV, IC_LOCT_MST, IC_LOTS_MST, IC_TRAN_PND, IC_TXN_REQUEST_LINES, and IC_WHSE_MST for item control, location, lot, pending transaction, and warehouse data. It references Oracle Inventory tables MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, MTL_UNITS_OF_MEASURE, and MTL_SALES_ORDERS for item, subinventory, UOM, and sales order linkage. Order Management data is read from OE_ORDER_HEADERS_ALL, and FND_LANGUAGES and FND_USER supply language and user context for messaging and audit.

Usage Notes

GMI_RESERVATION_UTIL is not invoked directly by end users. It is called from OPM reservation and order fulfillment flows, including OM file OEXVIIFB.pls (per bug fix 2536589), and from other PL/SQL packages—38 documented dependents. Typical invocation occurs during sales order reservation, pick release, and default lot assignment, including the SET_PICK_LOTS path. Customizations should not call these private utilities directly; the supported approach is to use the public reservation APIs that internally delegate here.