Search Results fetch_inv_controls

Overview

WSH_DELIVERY_DETAILS_INV is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the inventory validation and defaulting logic used by the Shipping Execution (WSH) module. In Oracle EBS 12.1.1 and 12.2.2, delivery details represent the individual lines that make up a delivery, and each line must be associated with a valid inventory organization, subinventory, locator, revision, lot, and serial number before the material can be picked, staged, and shipped. WSH_DELIVERY_DETAILS_INV centralizes those validations so that multiple shipping processes apply a consistent set of inventory-aware edits.

The package has an API classification of OTHER, meaning it is an internal, non-public utility package rather than a formally published open interface. It is nevertheless heavily reused: the ETRM metadata records that it is referenced by 15 other packages, including WSH_DELIVERY_VALIDATIONS, WSH_DETAILS_VALIDATIONS, WSH_DELIVERY_DETAILS_ACTIONS, WSH_DELIVERY_DETAILS_PKG, WSH_SHIP_CONFIRM_ACTIONS2, WSH_PROCESS_INTERFACED_PKG, WSH_CONTAINER_ACTIONS, WSH_NEW_DELIVERY_ACTIONS, WSH_EXCEPTIONS_GRP, and several USA and TP release packages. A user searching for "wsh_delivery_validations" will therefore encounter this package as a principal dependency of the delivery validation layer.

Key Procedures and Functions

The documented package exposes 25 procedures and functions. The principal groupings are:

• Inventory control and defaulting: FETCH_INV_CONTROLS, DETAILS_REQUIRED, SUB_LOC_CTL, GET_ORG_LOC, DEFAULT_SUBINVENTORY, DEFAULT_LOCATOR, LOCATOR_CTL_CODE, and GET_RESERVABLE_FLAG retrieve the inventory control settings and defaulting rules used to populate or constrain delivery detail inventory attributes.
• Validation routines: VALIDATE_LOCATOR, VALIDATE_REVISION, VALIDATE_SUBINVENTORY, VALIDATE_LOT_NUMBER, VALIDATE_SERIAL, and VALIDATE_SERIAL_RANGE verify that the subinventory, locator, revision, lot, and serial values entered against a delivery detail are valid for the item and organization.
• Serial number handling: MARK_SERIAL_NUMBER, UNMARK_SERIAL_NUMBER, CREATE_DYNAMIC_SERIAL, and GET_SERIAL_QTY support selecting, releasing, and dynamically generating serial numbers for on-the-fly serialized items.
• Reservation and update support: LINE_RESERVED and UPDATE_LOCATOR_SUBINV manage reservation status and propagate locator and subinventory changes back to the delivery detail.

Tables Accessed

WSH_DELIVERY_DETAILS_INV reads and writes through APPS synonyms. WSH_DELIVERY_DETAILS is the primary transaction table updated with validated subinventory, locator, revision, lot, and serial values. MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_SECONDARY_LOCATORS, MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, and MTL_ITEM_SUB_DEFAULTS supply organization-level inventory controls and defaulting hierarchies. MTL_SYSTEM_ITEMS supplies item attributes, including serial, lot, and revision control flags. MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, and MTL_SERIAL_NUMBERS_TEMP validate and track lot and serial numbers, while MTL_MATERIAL_TRANSACTIONS_S is used during serial marking. MTL_INTERORG_PARAMETERS supports transfer and interorg validation, and OE_ORDER_LINES_ALL and PO_REQUISITION_LINES_ALL provide source-document context for delivery details originating from order management and purchasing.

Usage Notes

This package is not intended for direct invocation by end users. It is called by Shipping Execution forms and concurrent programs whenever delivery detail inventory attributes are entered, changed, or confirmed, most notably through the WSH_DELIVERY_VALIDATIONS and WSH_DETAILS_VALIDATIONS packages. Because it is a dependency of Ship Confirm and interface processing logic, customizations should avoid modifying the package body. Developers extending shipping functionality should invoke the validation routines indirectly through the documented Shipping public APIs, or reference the package only for read-only diagnostics, since its signature and behavior are not guaranteed across patch levels.