Search Results wms_rule_15




Overview
Explore in AI Chat

Overview

APPS.WMS_RULE_15 is a server-side PL/SQL package within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. It is classified under the ETRM as an OTHER API, meaning it is not part of Oracle's published, supported public interface set; it functions as an internal helper package that supports the rule-based logic used by the WMS picking and allocation engine. Its documented dependent, WMS_RULE_PVT, is the private implementation package that underpins the WMS Rules Engine, and WMS_RULE_15 is one of the numbered rule packages that cooperate with that core engine. Rather than defining business policy, the package exposes a generic cursor-management contract — opening, iterating over, and closing result sets — that the rules engine uses to evaluate candidate material and return qualifying rows for downstream allocation logic.

Key Procedures and Functions

  • OPEN_CURS — Opens and initialises a cursor handle used in subsequent row-by-row retrieval. It establishes the context in which the rule query is executed against the referenced WMS and inventory tables.
  • FETCH_ONE_ROW — Retrieves a single row from the previously opened cursor, allowing the calling process to evaluate one candidate record at a time before deciding whether to continue.
  • CLOSE_CURS — Closes the active cursor and releases the associated session resources. Consistent use of this procedure prevents cursor leakage in long-running rule evaluations.
  • FETCH_AVAILABLE_ROWS — Bulk-fetches the set of rows that satisfy the rule's availability criteria. This is the primary retrieval entry point for the rule and is the procedure most relevant to downstream consumers.

All four procedures are procedural steps only; no parameter lists are documented in the ETRM metadata, and none should be assumed.

Tables Accessed

The package references seven tables through APPS synonyms, all read-oriented in the context of rule evaluation:

  • MTL_ITEM_LOCATIONS — Supplies locator information (subinventory, row, rack, bin) for candidate inventory positions.
  • MTL_ONHAND_QUANTITIES_DETAIL — The core on-hand source used to confirm availability before a row is returned to the rules engine.
  • MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS — Provide lot and serial control attributes so the rule can respect lot/serial-based restrictions.
  • MTL_SECONDARY_INVENTORIES — Identifies the subinventory attributes (including picking and material status rules) relevant to the candidate rows.
  • PJM_PROJECT_PARAMETERS — Supports project, task or contract-related filtering where inventory is project-referenced.
  • PLITBLM — A WMS internal PL/SQL table type used to buffer or pass result sets within the rules engine.

Usage Notes

WMS_RULE_15 is invoked almost exclusively through the numbered rule architecture: it is referenced by itself (recursively, via overloaded entry points) and by WMS_RULE_PICK_PKG1, which is the rule pick package that drives the selection of inventory during picking. It is not intended to be called directly from Oracle Forms or from custom concurrent programs, and because it is classified as an OTHER API, Oracle does not guarantee its signature or behaviour across patch levels. Custom code should therefore call the supported WMS public APIs rather than WMS_RULE_15. Given that the package is documented as VALID and includes a package body, it is fully compiled and active in both EBS 12.1.1 and 12.2.2. Developers performing diagnostics on unexpected picking, allocation, or rule-ordering behaviour may review its dependency chain — WMS_RULE_PVT upstream and WMS_RULE_PICK_PKG1 downstream — to trace how candidate inventory rows are assembled and returned.