Search Results g_backordered




Overview
Explore in AI Chat

Overview

WSH_PICK_LIST is the Oracle Shipping Execution PL/SQL package responsible for the pick release process. It generates the selection list of eligible delivery details, drives the reservation of on-hand inventory through the Move Order APIs, and initiates the printing of pick slips. The package header (WSHPGSLS.pls, version 120.8) states its purpose concisely: generate the selection list and call Move Order APIs to create reservations and print Pick Slips. It is classified as an OTHER API in ETRM and sits between the Shipping Transaction/ship-confirm layer and the Inventory transaction layer.

The package supports cross-docking decisions through declared constants: inventory-only (I), crossdock-only (C), prioritize-crossdock (X), and prioritize-inventory (N). Global state includes G_BATCH_ID (initialized to NULL per fix 1729516), G_BACKORDERED, G_AUTO_PICK_CONFIRM, G_PICK_REL_PARALLEL, and the unassigned delivery ID collection. It reads shipping parameters into a typed Org_Params_Rec record (WMS_ORG, EXPRESS_PICK_FLAG, AUTO_PICK_CONFIRM, autodetail/autocreate flags, pick sequence and grouping rules, autopack level, routing rule flags) to drive behavior per organization.

WSH_PICK_LIST is referenced by 20 other packages, making it a central dependency in custom shipping extensions.

Key Procedures and Functions

Eight documented procedures/functions are exposed:

  • RELEASE_BATCH — The primary batch pick release entry point; drives selection, reservation, and pick slip generation for a batch of delivery details. Note the uninitialized G_BATCH_ID, which callers should supply explicitly.
  • RELEASE_BATCH_SUB — A subordinate worker routine invoked by RELEASE_BATCH when parallel processing is requested (governed by G_PICK_REL_PARALLEL and G_NUM_WORKERS).
  • RELEASE_BATCH_SRS — The concurrent-program entry point, submitted as an SRS request rather than invoked interactively.
  • ONLINE_RELEASE — Releases a single delivery/delivery detail interactively, used by the Shipping Transactions form.
  • LAUNCH_PICK_RELEASE — Orchestrates the end-to-end launch, coordinating selection list creation and handoff to Move Order APIs.
  • CALCULATE_RESERVATIONS — Determines reservation quantities required, driving Move Order creation against MTL_RESERVATIONS / MTL_TXN_REQUEST_* tables.
  • CALCWORKINGDAY — Calendar utility computing working days from WSH_CALENDAR_ASSIGNMENTS for scheduling/date rollover logic.

Parameter lists are not reproduced here; signatures should be verified against the deployed package header.

Tables Accessed

Usage Notes

Invocation occurs through four standard channels: the Shipping Transactions form (ONLINE_RELEASE), the Pick Release concurrent program (RELEASE_BATCH_SRS, wired via FND_CONCURRENT_REQUESTS), parallel batch workers (RELEASE_BATCH / RELEASE_BATCH_SUB), and custom code that calls RELEASE_BATCH directly.

Common custom-code use case: calling RELEASE_BATCH after setting G_BATCH_ID explicitly, since 1729516 left it NULL by default. Because 20 packages depend on WSH_PICK_LIST, customizations should avoid direct table updates and instead reuse documented entry points. Organizations must be in an Inventory-managed (WMS) context for the Org_Params_Rec values (WMS_ORG, autodetail, autocreate) to be honored. Use RELEASE_BATCH_SRS from concurrent managers and reserve ONLINE_RELEASE for single-order interactive release; CALCWORKINGDAY is useful standalone for any shipping date calculation.