Search Results wms_replenishment_pvt




Overview
Explore in AI Chat

Overview

APPS.WMS_REPL_CUSTOM_APIS_PUB is a public PL/SQL package in the Oracle Warehouse Management System (WMS) module, delivered in the APPS schema and validated in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It functions as the supported customization hook layer for the replenishment engine. The core replenishment logic resides in the private package WMS_REPLENISHMENT_PVT, which is not intended for direct customer extension. WMS_REPL_CUSTOM_APIS_PUB exposes controlled entry points that allow implementers to inject site-specific allocation or demand-consolidation behavior without modifying Oracle-owned code, preserving upgradeability.

The package is classified as a PUB API. Circular dependency exists between the two packages: WMS_REPL_CUSTOM_APIS_PUB references WMS_REPLENISHMENT_PVT, and WMS_REPLENISHMENT_PVT in turn references WMS_REPL_CUSTOM_APIS_PUB. This design confirms that the replenishment engine calls out to the custom API at defined processing points, and the custom API can call back into replenishment services. The package also depends on SYS.STANDARD.

Key Procedures and Functions

  • POST_REPL_ALLOCATION_CUST — A customization hook invoked after the replenishment engine performs allocation. It permits customer-specific post-processing of allocation results, such as adjusting allocated quantities, applying site-specific transfer or subinventory rules, or writing to custom audit or staging structures. Implementations override or extend the default behavior to align replenishment allocations with local operating policies.
  • GET_CONSOL_REPL_DEMAND_CUST — A customization function that supplies consolidated replenishment demand to the engine. It returns customer-defined or site-specific demand quantities, enabling organizations to consolidate demand using criteria beyond standard WMS logic, such as custom order grouping, wave-based aggregation, or external demand feeds.

Both routines represent the two documented extension points of the replenishment cycle: demand calculation and post-allocation processing. Parameter lists are defined by the delivered specification in the APPS schema and should be verified against the package header for the specific patch level.

Tables Accessed

The documented metadata lists PLITBLM as the only table referenced through APPS synonyms. PLITBLM is a WMS material-handling integration interface table used to communicate replenishment tasks and allocation results to the Material Handling Equipment (MHE) or task execution layer. Within this package, PLITBLM supports the exchange of replenishment allocation data captured or modified by the custom routines, ensuring downstream automation systems receive adjusted task instructions.

Usage Notes

This package is not invoked directly by end users. It is called by WMS_REPLENISHMENT_PVT during replenishment planning and execution, and customers extend it through the documented customization framework rather than by altering Oracle code. Typical invocation paths include replenishment concurrent programs, the Warehouse Management mobile and desktop forms that trigger replenishment, and any custom code that must participate in demand consolidation or allocation posting.

Because WMS_REPLENISHMENT_PVT calls this package and this package references it, implementers must avoid changes that break the documented signatures or introduce recursion. Custom logic belongs in the body of the two exposed routines, where it stays isolated from core replenishment processing. The package is present and VALID in both 12.1.1 and 12.2.2, and its dependencies should be reviewed during patching.