Search Results initialize_main_table

Overview

WMS_TASK_MGMT_PUB is a public PL/SQL package in the APPS schema that provides the application programming interface for task management within Oracle Warehouse Management (WMS). It encapsulates the core business logic used to create, modify, split, cancel, delete, and query warehouse execution tasks — the discrete units of work that drive directed picking, put-away, replenishment, and cycle counting activities on the warehouse floor. By exposing this functionality through a published API rather than allowing direct table manipulation, the package enforces the validation, reservation, and transaction-integrity rules that WMS requires. The package is classified as a public (PUB) API, meaning it is intended for invocation by other Oracle EBS modules as well as by customer extensions. Its status is VALID across Oracle EBS 12.1.1 and 12.2.2, and it depends on the FND_API framework for standardized message handling and error reporting.

Key Procedures and Functions

The package exposes six documented procedures, each addressing a distinct task lifecycle operation:

• QUERY_TASK — Retrieves task records based on caller-supplied search criteria, returning the task attributes needed by mobile and desktop interfaces.
• INITIALIZE_MAIN_TABLE — Prepares the package's internal main task table (a PL/SQL collection) for subsequent processing within a session, establishing the working data set.
• MODIFY_TASK — Updates attributes of an existing task, such as quantities, locations, or assignment details, applying the appropriate validation rules.
• SPLIT_TASK — Divides a single task into multiple tasks, a common requirement when picking must be distributed across locations, lots, or handling units.
• CANCEL_TASK — Cancels an active task while releasing associated reservations and restoring inventory availability.
• DELETE_TASKS — Physically removes task records, typically used for cleanup of obsolete or administratively created tasks.

No parameter lists are documented in the ETRM metadata; callers should reference the package specification in the database for exact signatures.

Tables Accessed

The package reads and writes a broad set of inventory and WMS tables through APPS synonyms. Task query and initialization rely on WMS_SAVED_QUERIES for stored search definitions. Reservation and transaction processing touches MTL_RESERVATIONS, MTL_MATERIAL_TRANSACTIONS, its _S and _TEMP variants, and MTL_TXN_REQUEST_HEADERS for move-order tasks. Item and serial validation uses MTL_SYSTEM_ITEMS (and MTL_SYSTEM_ITEMS_B), MTL_SERIAL_NUMBERS, and MTL_SERIAL_NUMBERS_TEMP. Cycle counting operations reference MTL_CYCLE_COUNT_HEADERS and MTL_CYCLE_COUNT_ENTRIES. Lot handling uses MTL_TRANSACTION_LOTS_TEMP, and mobile session context is captured in MTL_MOBILE_LOGIN_HIST. FND_NEW_MESSAGES supports the FND_API messaging framework. Collectively these tables confirm that the package operates at the intersection of task execution and inventory transaction integrity.

Usage Notes

WMS_TASK_MGMT_PUB is not a user-facing concurrent program; it is invoked programmatically. The primary caller is WMS_PICKING_PKG, which references the package to orchestrate picking workflows. The package also references itself, indicating internal recursive or nested calls. Customizations and extensions that need to manipulate warehouse tasks — for example, custom mobile pages, integration interfaces, or automated task-rebalancing routines — should call this API rather than writing directly to WMS task tables, thereby preserving validation and reservation logic. Because it depends on FND_API, callers should be prepared to interpret the standard FND_API return status and message stack. In 12.2.2 the package remains the supported task-management entry point in online patching environments.