Search Results wms_dispatched_tasks_arch




Overview
Explore in AI Chat

Overview

WMS_DISPATCHED_TASKS_ARCH is the archive companion to WMS_DISPATCHED_TASKS in the Oracle Warehouse Management (WMS) module. It resides in the WMS schema and stores historical information about warehouse tasks that have been completed. In Oracle EBS 12.1.1 and 12.2.2, dispatched tasks represent discrete units of warehouse labor — put-aways, picks, replenishments, moves, and similar material handling activities — that have been assigned to a user or equipment resource and subsequently executed. As the active task table grows, completed records are migrated to this archive table, preserving the full operational history while keeping the transactional table performant.

From a dimensional modeling perspective, the heuristic Data Vault classification derived from the foreign key structure is link. This classification is a modeling suggestion: the table records relationships and events between warehouse resources (people, machines, equipment instances), organizational units, and inventory transactions, rather than serving as a pure hub of unique business entities or a satellite of descriptive attributes for a single parent.

Key Information Stored

The documented schema contains 65 columns. The most significant are:

Common Use Cases and Queries

The archive table supports historical labor reporting, warehouse productivity dashboards, and audit reconciliation of completed tasks. Typical queries join to MTL_PARAMETERS for the organization name and to PER_ALL_PEOPLE_F for the operator. For example, to compute average task cycle time by operator:

SELECT person_id,
       COUNT(*) tasks,
       AVG(drop_off_time - dispatched_time) avg_cycle
FROM   wms.wms_dispatched_tasks_arch
WHERE  organization_id = :org
  AND  dispatched_time >= :from_date
GROUP BY person_id;

Reconciliation queries compare archived tasks against inventory transaction history (TRANSACTION_ID) to confirm that every completed movement is reflected in MTL_MATERIAL_TRANSACTIONS. Volume trending by task type or equipment supports capacity planning.

Related Objects

  • WMS_DISPATCHED_TASKS — The active source table from which archived rows originate; shares the same structure.
  • MTL_PARAMETERS — Joined on ORGANIZATION_ID; supplies organization context.
  • PER_ALL_PEOPLE_F — Joined on PERSON_ID plus the effective date range for operator names.
  • BOM_RESOURCES — Referenced by PERSON_RESOURCE_ID and MACHINE_RESOURCE_ID.
  • MTL_SERIAL_NUMBERS — Referenced by EQUIPMENT_INSTANCE / EQUIPMENT_ID.
  • WMS_OP_PLANS_B — Referenced by OPERATION_PLAN_ID.
  • MTL_TXN_SOURCE_TYPES — Referenced by TRANSACTION_SOURCE_TYPE_ID.