Search Results validate_subinventory




Overview
Explore in AI Chat

Overview

APPS.WMS_PICK_LOAD_UI is a public PL/SQL package in the Oracle EBS Warehouse Management System (WMS) module. It exposes validation APIs used by the picking and loading user interface to confirm that operator-entered subinventory and locator/LPN values are valid before a transaction is committed. The package acts as a thin, intent-specific layer over core inventory validation logic: it applies organization-level restriction rules, item-level control attributes, and transaction-type context to determine whether a chosen subinventory or locator/LPN may be used for a given material movement. Because these checks are interactive (rather than batch), the package is designed to return validation flags, derived values, and user-facing messages to the calling form so that the operator receives immediate feedback without a round trip to the database on save.

Key Procedures and Functions

  • VALIDATE_SUBINVENTORY — Validates a subinventory code against the supplying organization, item, restriction rules, and transaction type. It returns an indicator of whether the subinventory is valid, an indicator of whether the subinventory is LPN (license plate number) controlled, and an output message describing the failure when validation does not pass. This is the procedure surfaced when a user searches on validate_subinventory.
  • VALIDATE_LOCATOR_LPN — Validates a locator or LPN reference supplied during pick/load activity. It evaluates the locator/LPN against organization restrictions, item, revision, subinventory, transaction type, project and task, and allocated/suggested location context. Outputs include validity flags for locator and LPN, the resolved subinventory code, locator name and locator ID, LPN ID, an LPN-controlled indicator, and the standard return status/message count/message data trio used for API error propagation.

The package also declares a t_genref REF CURSOR type used internally by the implementation.

Tables Accessed

The documented table access is MTL_SECONDARY_INVENTORIES (referenced through an APPS synonym). This table stores subinventory definitions, including material control flags, locator control, and restriction attributes, and is the authoritative source for determining whether a candidate subinventory is valid and LPN controlled. Locator and LPN resolution logically depends on the same inventory master data, but only MTL_SECONDARY_INVENTORIES is documented for this package.

Usage Notes

  • Source forms: The package is intended for the WMS pick/load UI, where it is invoked on field validation and navigation events so that invalid subinventory or locator/LPN entries are caught before transaction submission.
  • Server-side validation: Custom code should call these procedures rather than querying subinventory or locator tables directly, ensuring that restriction codes, LPN control, and transaction-type rules are consistently applied.
  • Error handling: Always inspect the output message and, for VALIDATE_LOCATOR_LPN, the x_return_status/x_msg_count/x_msg_data values to communicate failures to the user.
  • Version scope: The header revision (120.0.12010000.3) applies to 12.1.1 and the 12.2.x code line; behavior should be regression tested after any WMS or INV patch application.