Search Results unload_bulk_task

Overview

WMS_UNLOAD_UTILS_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that supports the unloading stage of Oracle Warehouse Management (WMS) task execution within Oracle E-Business Suite 12.1.1 and 12.2.2. Its business function is to convert dispatched warehouse tasks into the corresponding inventory transaction data, releasing material from the staging or dock location and finalizing the unload step for a task assigned to a user or resource. The package operates in the gap between task dispatch (WMS_DISPATCHED_TASKS) and inventory posting via the transaction interface (MTL_MATERIAL_TRANSACTIONS_TEMP), consolidating the reservation, serial, lot, and LPN updates required to record an unload event.

The $Header stamp (WMSUNLDS.pls 120.0.12000000.1, dated 2007/01/16) confirms the body originates from the core 11i/12.x WMS code line and remains unchanged through the 12.1.1 and 12.2.2 releases. As a PVT package it is not intended as a supported public API; it is an internal helper called by WMS task-management logic, and its interface may change without notice.

Key Procedures and Functions

• UNLOAD_TASK — The primary procedure that performs the unload of a single warehouse task. It returns a numeric return value and an output message, and accepts a temporary identifier used to locate the transaction staging row being processed. It orchestrates the reservation release, serial/lot handling, and interface-table population needed to unload one task at a time.
• UNLOAD_BULK_TASK — The bulk counterpart that processes multiple task records in a single call. It returns the next temporary identifier and a return status along with the input temporary identifier. This variant is used for high-volume unloading, such as a dispatched wave or a group of tasks released together on a mobile device, and advances the caller through the set of staged transactions.

The two procedures share the same unload semantics: UNLOAD_TASK handles a single logical unit, while UNLOAD_BULK_TASK iterates across many. The package exposes no documented functions.

Tables Accessed

• WMS_DISPATCHED_TASKS — The dispatched task record being unloaded; supplies task context.
• MTL_MATERIAL_TRANSACTIONS_TEMP — The transaction staging interface populated for eventual inventory posting.
• MTL_RESERVATIONS — Reservation records updated or released as material is unloaded.
• MTL_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP — Serial validation and staging for serial-controlled items.
• MTL_TRANSACTION_LOTS_TEMP — Lot/sublot staging for lot-controlled items.
• MTL_SYSTEM_ITEMS — Item attribute validation (locator, lot, serial control).
• WMS_LICENSE_PLATE_NUMBERS and WMS_LPN_CONTENTS — LPN (license plate) identity and content records for LPN-managed unloading.
• MTL_TXN_REQUEST_LINES — Move-order lines associated with the task, for replenishment or move-order driven unloading.

These tables are referenced through APPS synonyms and collectively cover the full unload data model: task, staging, reservation, serial, lot, and LPN.

Usage Notes

WMS_UNLOAD_UTILS_PVT is invoked indirectly through the WMS task execution flow — mobile RF unload/drop screens, the WMS task manager, and concurrent processing that batch-unloads dispatched work. It is referenced by one other package in the ETRM catalog, which indicates it sits one layer below the public task-management entry points. Direct calls from custom code are discouraged because the package is classified PVT and its signature (including the unload_task temporary-identifier parameter and the OUT NOCOPY parameters) is subject to change between patches and releases. Implementers requiring unload behavior should use the supported WMS task APIs or the standard mobile pages and allow this package to be called internally. When debugging unload failures in 12.1.1 or 12.2.2, the return value and message outputs from these procedures are the primary diagnostic indicators, together with the staging rows left in MTL_MATERIAL_TRANSACTIONS_TEMP.