Search Results load_pick

Overview

WMS_TASK_DISPATCH_GEN is a server-side PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Warehouse Management System (WMS) module and implements the core task dispatch generation logic used by Oracle Warehouse Management. The package translates planned warehouse tasks—picks, put-aways, replenishments, and moves—into executable dispatch records, material transactions, and, where applicable, work order or move order requests. It is classified under ETRM as an "OTHER" API, meaning it is not a formally published open interface but is nonetheless referenced by ten other packages, indicating its role as an internal integration hub within the WMS execution stack.

The package header identifies the source as WMSTASKB.pls version 120.18.12010000.2, dated 2008/08/22. The declaration includes a global constant g_pkg_name and a version constant, along with a global variable g_ordered_psr typed as wms_replenishment_pvt.psrTabTyp, introduced for replenishment processing (Project 6681109). The excerpt also documents the call_workflow and create_mo procedures, the latter flagged with a maintenance caution instructing developers to mirror any signature changes in wms_task_dispatch_put_away.create_mo.

Key Procedures and Functions

The ETRM metadata documents 35 total procedures and functions. The most relevant set includes:

• GET_LPN_LOT_QTY — Returns the quantity available within an LPN for a given lot, supporting license-plate-number-driven picking.
• NEXT_TASK — Retrieves the next eligible dispatch task for a resource or operator.
• NEXT_CLUSTER_PICK_TASK — Selects the next task within a cluster pick, supporting multi-order picking strategies.
• COMPLETE_PICK — Finalizes a pick task and posts the associated material transaction.
• LPN_MATCH — Validates that a scanned LPN matches the expected LPN for the task.
• PROCESS_LOT_SERIAL — Captures and validates lot and serial information during task execution.
• GET_PRIMARY_QUANTITY — Derives the primary-unit-of-measure quantity for a transaction.
• CAN_PICKDROP — Evaluates whether a pick-and-drop operation is permitted for the current context.
• LOAD_PICK — Loads pick task details into the dispatch structures, forming the entry point most commonly searched by users.
• VALIDATE_PICK_TO_LPN — Confirms that a picked quantity can be legally placed into a target LPN.
• MULTIPLE_LPN_PICK and MULTIPLE_PICK — Handle picks spanning multiple LPNs or multiple orders in a single operation.
• INSERT_MMTT_PACK — Inserts packing information into MTL_MATERIAL_TRANSACTIONS_TEMP.
• INSERT_TASK — Creates a new dispatch task record.
• MYDEBUG — Internal diagnostic logging routine.
• CREATE_LPN and CHANGE_LPN — Create and modify license plates during dispatch.
• PICK_DROP — Executes the combined pick-and-drop movement.
• PICK_BY_LABEL — Supports label-driven picking.
• MANUAL_PICK — Supports operator-entered pick confirmations.

Two additional procedures, CALL_WORKFLOW and CREATE_MO, are shown in the source excerpt. CALL_WORKFLOW initiates an Oracle Workflow process for a given reason ID, organization, and optional pick quantity, returning workflow status. CREATE_MO creates a move order request with item, quantity, UOM, LPN, project, task, lot, revision, and inspection attributes.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• BOM_RESOURCES, BOM_RESOURCE_EQUIPMENTS, BOM_STD_OP_RESOURCES — Used to resolve resource and equipment context for task dispatch.
• MTL_CYCLE_COUNT_ENTRIES, MTL_CYCLE_COUNT_HEADERS — Referenced for cycle count integration during task execution.
• MTL_ITEM_LOCATIONS — Provides locator and subinventory validation for pick and put-away destinations.
• MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP — Support lot and serial capture, validation, and temporary staging.
• MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP — Receive the transaction records generated by pick, drop, and pack operations.
• MTL_ONHAND_QUANTITIES_DETAIL — Supplies on-hand availability for task generation and validation.
• MTL_PARAMETERS — Provides organization-level defaults and controls.
• MTL_RESERVATIONS — Links tasks to inventory reservations.
• MTL_SECONDARY_INVENTORIES — Validates subinventory attributes for source and destination.

Usage Notes

WMS_TASK_DISPATCH_GEN is typically invoked indirectly through WMS mobile radio-frequency (RF) screens, the Warehouse Management concurrent programs, and adjacent WMS packages such as wms_task_dispatch_put_away. Because it is referenced by ten other packages, direct custom calls should be treated cautiously. When extending the package, developers must keep the CREATE_MO signature synchronized with its counterpart in wms_task_dispatch_put_away, as noted in the source comments. Debug tracing is controlled through the INV_DEBUG_TRACE profile option. Users searching for "load_pick" are most likely seeking the LOAD_PICK procedure, which loads pick task data for subsequent confirmation through COMPLETE_PICK or MANUAL_PICK.