Results for “wms_xdock_utils_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS_XDOCK_UTILS_PVT is a private PL/SQL utility package in the Oracle Warehouse Management (WMS) module, declared with AUTHID CURRENT_USER. It provides the core crossdocking logic used by Oracle E-Business Suite to evaluate, create, and maintain the relationship between inbound supply and outbound demand within a warehouse. Crossdocking allows received material to flow directly to outbound orders without being put away into storage, reducing handling costs and dock-to-stock cycle time. The package supports both opportunistic crossdocking, in which eligible demand is matched to supply already in receiving, and planned crossdocking, in which supply and demand are matched against scheduled dock appointments and crossdock criteria. The header constants define the source type indicators (supply versus demand), criterion types (opportunistic versus planned), appointment scheduling methods (start, mean, or end of the dock appointment window), crossdocking optimization goals (minimize wait, maximize crossdock volume, or user-defined), and the enumeration of eligible demand and supply sources, including scheduled and backordered sales orders, internal orders, WIP component demand, purchase orders in receiving, internal requisitions in receiving, and in-transit shipments. These constants give calling programs a stable, documented vocabulary for configuring crossdock behavior.

Key Procedures and Functions

The package exposes seven documented program units. IS_ELIGIBLE_SUPPLY_SOURCE evaluates whether a given inbound supply record qualifies for crossdocking under the active rules. IS_ELIGIBLE_DEMAND_SOURCE performs the complementary check for outbound demand. Together these functions drive the matching engine by filtering candidates before a crossdock link is proposed. CREATE_CROSSDOCK_RESERVATION establishes a reservation that links a specific supply to a specific demand. UPDATE_CROSSDOCK_RESERVATION modifies an existing reservation when quantities, dates, or assignments change. TRANSFER_CROSSDOCK_RESERVATION moves a reservation from one supply or demand reference to another, supporting replanning scenarios. DELETE_CROSSDOCK_RESERVATION removes a reservation that is no longer valid or required. RELIEVE_CROSSDOCK_RESERVATION releases the reserved quantity once the crossdock movement has been physically executed, keeping reservation balances aligned with actual inventory movement.

Tables Accessed

Documented table access confirms the package's position between order management and warehouse execution. OE_ORDER_LINES_ALL supplies sales order demand details used to judge eligibility and to build reservations. WSH_DELIVERY_DETAILS provides shipping and delivery line information, aligning crossdock reservations with outbound deliveries. WMS_XDOCK_SOURCE_ASSIGNMENTS stores the rule and source configuration that determines which supply and demand sources participate, and is read to resolve eligibility. PLITBLM, a standard Oracle Applications temporary/PL-SQL table structure, supports intermediate result handling during processing.

Usage Notes

As a PVT-classified package, WMS_XDOCK_UTILS_PVT is not part of the public API surface. It is referenced by four other packages within the WMS and shipping stack and is invoked indirectly through WMS crossdocking flows rather than directly by end users. It is typically driven by warehouse execution transactions, receiving and put-away processes, and concurrent programs that evaluate crossdock opportunities, with results surfaced through WMS and shipping forms. Custom code should not call these private procedures directly; extensions should instead use supported public APIs. Because the package executes with AUTHID CURRENT_USER, effective privileges derive from the invoking user. The header revision (120.1, June 2005) is common to both EBS 12.1.1 and 12.2.2, indicating stable behavior across these releases.