Search Results wms_control_board




Overview
Explore in AI Chat

Overview

WMS_CONTROL_BOARD is an APPS-owned PL/SQL package body within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. It supports the Warehouse Control Board, the operational workspace used by warehouse supervisors and dispatchers to monitor, filter, and manipulate pending warehouse tasks in real time. The package encapsulates the server-side logic that drives task status and task type distribution queries, validation of task statuses, concurrency-safe row locking, and task-level manipulation operations.

The package is classified as OTHER in the ETRM API registry, meaning it is an internal implementation package rather than a published, supported open interface. It exposes five documented program units used primarily by the WMS Control Board user interface and by internal task-processing logic. It is not referenced by any other database object, confirming its role as a terminal consumer of the WMS and Inventory data model rather than a shared utility.

Key Procedures and Functions

  • GET_STATUS_DIST — Returns the distribution of dispatched warehouse tasks grouped by task status. This drives the status summary counters presented on the Control Board, allowing supervisors to see how many tasks are pending, dispatched, in progress, or completed.
  • GET_TYPE_DIST — Returns the distribution of tasks grouped by task type. It supports the type-based filtering and categorization display on the Control Board.
  • IS_STATUS_VALID — Validates whether a supplied task status value is legitimate, typically by checking against the MFG_LOOKUPS lookup type for WMS task statuses. It guards status update operations against invalid input.
  • LOCK_ROW — Acquires a row-level lock on a task record to prevent concurrent modification. This is essential in a multi-user warehouse environment where two dispatchers could otherwise act on the same task simultaneously.
  • TASK_MANIPULATOR — The principal operational routine. It performs the requested manipulation on a dispatched task, such as assigning, reassigning, releasing, or updating task attributes, applying the validated status and lock semantics established by the other programs.

Tables Accessed

  • WMS_DISPATCHED_TASKS — The primary table holding active dispatched warehouse tasks. The distribution queries and task manipulation logic operate against this table.
  • WMS_DISPATCHED_TASKS_S — The sequence source used to generate task identifiers when new dispatched task rows are created.
  • MTL_MATERIAL_TRANSACTIONS_TEMP — Accessed to stage or reference pending inventory material transactions associated with tasks processed through the Control Board.
  • MTL_CYCLE_COUNT_ENTRIES — Read for cycle count entries relevant to tasks that originate from or feed into cycle counting activities.
  • DBMS_LOCK, DBMS_SQL, DUAL, PLITBLM — Utilized for concurrency control, dynamic SQL execution, and generic PL/SQL table handling.

Usage Notes

The package is invoked primarily from the Warehouse Control Board user interface, where its distribution functions populate summary regions and its manipulation routine processes dispatcher actions. It may also be called from custom extensions that need to read task status or type distributions, or to perform controlled task reassignment. Dependencies on FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE indicate compliance with the standard EBS error-handling and profile-option framework.

Because WMS_CONTROL_BOARD is an internal package and not part of a documented public API, direct calls from custom code should be treated as unsupported and version-sensitive. Behavior should be validated against both 12.1.1 and 12.2.2, as the underlying WMS data model and lookups remain consistent but internal logic may vary between releases.