Search Results wms_strategy_pvt




Overview
Explore in AI Chat

Overview

WMS_STRATEGY_PVT is a private PL/SQL package residing in the APPS schema of Oracle E-Business Suite, classified under the PVT (private) API tier. In the Warehouse Management System (WMS) module, a "strategy" defines the ordered set of rules and object members that the warehouse execution engine evaluates when determining how to handle a transaction — for example, how to direct putaway, allocate inventory, or sequence picking. WMS_STRATEGY_PVT encapsulates the internal logic used to search for, evaluate, and apply these strategies. Because the PVT classification denotes an internal implementation layer, the package is not intended as a public integration surface; it exists to support the higher-level WMS engine packages that drive warehouse execution. Its dependency on FND_API confirms it participates in the standard Oracle Application Object Library error-handling and API framework.

Key Procedures and Functions

Three documented program units make up the package's public entry points within the source module:

  • SEARCH — Locates the strategy or strategy members applicable to a given warehouse execution context. It resolves which strategy definitions are candidates based on the object, organization, and rule parameters supplied by the calling engine.
  • APPLY — Applies a resolved strategy to a transaction. Once a strategy has been identified, APPLY evaluates its ordered rules and member objects and produces the outcome the caller uses to direct the warehouse operation.
  • INITSTRATEGYRULES — Initializes the rule set for a strategy, loading the underlying rule and member definitions into the working structures consumed by SEARCH and APPLY. This initialization step ensures the strategy's rules are available before evaluation begins.

The precise parameter signatures are not reproduced here; the documented metadata identifies these units by name and purpose only.

Tables Accessed

WMS_STRATEGY_PVT reads and writes a defined set of WMS and Oracle Inventory tables through APPS synonyms:

Usage Notes

WMS_STRATEGY_PVT is invoked indirectly through the WMS execution engine rather than called directly from forms or concurrent programs. The dependency report confirms that it is referenced by two other packages — WMS_ENGINE_PVT and WMS_COSTGROUPENGINE_PVT — which drive warehouse execution and cost group processing respectively. It also references itself, indicating internal recursive or helper calls. Customizations should target the corresponding public/engine-level APIs rather than this PVT package, since its interface may change without notice across EBS 12.1.1 and 12.2.2. Developers debugging strategy resolution or rule application should trace calls originating from WMS_ENGINE_PVT into WMS_STRATEGY_PVT's SEARCH, APPLY, and INITSTRATEGYRULES units.