Search Results process_prj_dynamic_locator

Overview

INV_PICK_RELEASE_PVT is a private PL/SQL package in the APPS schema that supports the pick release and move order release logic within Oracle Inventory and Oracle Warehouse Management. In Oracle EBS 12.1.1 and 12.2.2, this package is the internal worker module for the family of public APIs exposed by INV_PICK_RELEASE_PUB and INV_MOVE_ORDER_PUB. It resolves picking rules, identifies source locators, allocates and reserves material against move orders and delivery details, generates pick slip numbers, and manages backorder caching during selection and allocation.

Because it is a private (PVT) API, it is not intended for direct customer invocation. It is documented here primarily because it appears in the dependency chain of INV_MOVE_ORDER_PUB, the public entry point most frequently referenced by customers extending move order and pick release functionality. The package is linked to FND_API for the standard concurrent-processing and error-handling framework, and to INV_RESERVATION_GLOBAL and WSH_INV_DELIVERY_DETAILS_V for reservation and shipping delivery detail access.

Key Procedures and Functions

• PROCESS_LINE — Core routine that processes an individual move order or pick release line, applying picking rules and allocation logic to determine the source locator and quantity.
• PROCESS_PRJ_DYNAMIC_LOCATOR — Resolves dynamic locators for project or project-related transactions, supporting project-enabled inventory picking.
• GET_PICK_SLIP_NUMBER — Generates or retrieves the pick slip number used to group released picking lines for printing and picking execution.
• PROCESS_RESERVATIONS — Creates and manages reservations against the move order or sales order demand, interacting with INV_RESERVATION_GLOBAL.
• CHECK_BACKORDER_CACHE — Inspects the internal backorder cache to determine whether unfulfilled quantities should be treated as backordered.
• CLEAR_BACKORDER_CACHE — Clears the backorder cache between processing cycles to prevent stale backorder data from affecting subsequent allocations.
• RELEASE_MO_TASKS — Releases move order tasks, driving the transition from allocation to pick confirmation for WMS-enabled and non-WMS organizations.
• GET_TOLERANCE — Returns the quantity or picking tolerance used to determine whether an allocation is considered complete.

Tables Accessed

• MTL_INV_PICKING_RULES, MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, MTL_ITEM_SUB_DEFAULTS — Used to determine the picking rule set and the source locator for each line.
• MTL_RESERVATIONS — Stores and updates reservation records created during pick release.
• MTL_MATERIAL_TRANSACTIONS_TEMP — Holds pending move order and pick transactions prior to posting.
• MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES — The move order header and line tables being processed and released.
• MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_SYSTEM_ITEMS — Provide organization, subinventory, and item defaults and controls.
• MTL_SALES_ORDERS — Links move orders to sales order demand for pick release.
• MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP — Support serialized item picking and generation of serial records during release.
• MTL_TRANSACTION_TYPES — Supplies transaction type validation for move order transactions.
• WSH_INV_DELIVERY_DETAILS_V — Provides delivery detail context for shipping-related pick release.

Usage Notes

INV_PICK_RELEASE_PVT is invoked indirectly through INV_PICK_RELEASE_PUB and INV_MOVE_ORDER_PUB, and is referenced by WMS_RULE_EXTN_PVT, WMS_UT_PKG, and WMS_WAVE_PLANNING_PVT in warehouse management flows. In typical EBS usage it is triggered by the Pick Release concurrent program, the Move Order concurrent programs, and the Move Orders and Transact Move Orders forms (INVTOMWO, INVTRANMO). Customers extending move order or pick release logic should call the public APIs rather than this package, since the private interfaces and signatures may change between patch levels and releases. For diagnostics, the package appears in the dependency chain when tracing why a move order line failed allocation, reservation, or release.