Search Results wms_rule_pvt




Overview
Explore in AI Chat

Overview

WMS_RULE_PICK_PKG2 is an Oracle Warehouse Management (WMS) package in the APPS schema that provides the executable rule-evaluation engine for the picking rule framework. In Oracle EBS 12.1.1 and 12.2.2, picking strategies such as order picking, wave picking, zone picking, and bulk picking are modeled as rules that must be evaluated at runtime against current inventory, order, and warehouse conditions. This package implements the physical execution of those rules: it opens a rule context, retrieves the candidate rule set, evaluates eligibility against available on-hand inventory, and closes the context once processing is complete. The package functions as a private implementation partner of WMS_RULE_PVT, sharing the same rule metadata and invocation conventions.

Key Procedures and Functions

  • EXECUTE_OPEN_RULE — Establishes the working context for a rule execution cycle. It initializes the internal state needed to evaluate one or more pick rules within a single logical transaction.
  • EXECUTE_FETCH_RULE — Retrieves the applicable rule definition(s) for the current context. This step selects the rule to be applied based on the pick strategy configuration maintained in the WMS rule setup.
  • EXECUTE_FETCH_AVAILABLE_INV — Queries the available inventory that satisfies the fetched rule's criteria, providing the candidate stock, locators, or lots eligible for allocation and picking.
  • EXECUTE_CLOSE_RULE — Terminates the rule execution context, releasing cursor and temporary state resources once rule evaluation is finished.

Tables Accessed

The ETRM metadata for WMS_RULE_PICK_PKG2 does not enumerate specific underlying tables referenced via APPS synonyms. As a consequence of its documented dependency on WMS_RULE_PVT, the package operates over the WMS rule configuration and inventory tables managed by that public layer. The rule definitions are maintained in the WMS rules setup tables, while EXECUTE_FETCH_AVAILABLE_INV draws against WMS inventory and locator data to determine what stock is eligible under the evaluated rule. All reads and writes flow through the owning schema's objects; no direct table names are exposed in the documented metadata.

Usage Notes

WMS_RULE_PICK_PKG2 is a supporting implementation package and is not intended for direct invocation by customers, forms, or concurrent programs. The documented dependency graph shows it is referenced by WMS_RULE_PVT and itself references WMS_RULE_PVT, indicating a tightly coupled internal relationship in which the public API layer (WMS_RULE_PVT) drives rule selection and delegates the low-level execution of open, fetch, inventory retrieval, and close operations to this package. Because the user's search term "wms_rule_pvt" points to the companion package, administrators troubleshooting picking rule behavior should treat WMS_RULE_PVT as the entry point and use this package's documented procedure sequence — open, fetch rule, fetch available inventory, close — as the reference model for the runtime evaluation lifecycle.