Search Results wms_dispatched_tasks_history




Overview
Explore in AI Chat

Overview

WMS_DISPATCHED_TASKS_HISTORY is the Oracle Warehouse Management (WMS) history table that archives completed material handling tasks dispatched within the warehouse. It is the historical counterpart to WMS_DISPATCHED_TASKS, which holds currently active or open work for warehouse execution. When a dispatched task reaches completion, the corresponding record is moved or copied into WMS_DISPATCHED_TASKS_HISTORY, providing an immutable audit trail of task execution across the facility.

Because the table captures the full lifecycle of a task — dispatch, load, drop-off, and transaction posting — it functions as a system of record for warehouse labor performance, equipment utilization, and material movement reporting. It resides in the WMS schema and is valid in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined metadata suggests classifying this table as a link entity, since its foreign key structure ties together organizations, people, equipment, inventory, and inventory transactions into a single relationship record. Analysts building a warehouse-layer model may treat TASK_ID as the driving business key.

Key Information Stored

The documented physical schema contains 68 columns. The most operationally significant are:

Common Use Cases and Queries

Typical applications include warehouse operator productivity reporting, equipment utilization analysis, task completion auditing, and reconciliation between task execution and posted inventory transactions.

  • Task cycle-time analysis: compute elapsed time from DISPATCHED_TIME to DROP_OFF_TIME grouped by USER_TASK_TYPE and PERSON_ID.
  • Productivity reporting: count completed tasks per operator per shift, joining PERSON_ID to PER_ALL_PEOPLE_F for names.
  • Transaction reconciliation: join TRANSACTION_ID to MTL_MATERIAL_TRANSACTIONS to confirm every completed task produced a posted inventory transaction.
  • Sample SQL: SELECT t.task_id, t.organization_id, t.person_id, t.user_task_type, t.transaction_quantity FROM wms.wms_dispatched_tasks_history t WHERE t.organization_id = :org_id AND t.drop_off_time BETWEEN :start_date AND :end_date;

Related Objects

  • WMS_DISPATCHED_TASKS — the active-task parent from which this history is derived.
  • MTL_MATERIAL_TRANSACTIONS — joined via TRANSACTION_ID for transaction posting details.
  • MTL_PARAMETERS — joined via ORGANIZATION_ID for warehouse definitions.
  • PER_ALL_PEOPLE_F — joined via PERSON_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE for operator identity.
  • BOM_RESOURCES — joined via PERSON_RESOURCE_ID and MACHINE_RESOURCE_ID for resource costing.
  • MTL_SERIAL_NUMBERS — joined via EQUIPMENT_INSTANCE and EQUIPMENT_ID.
  • WMS_OP_PLANS_B — joined via OPERATION_PLAN_ID.
  • MTL_TXN_SOURCE_TYPES — joined via TRANSACTION_SOURCE_TYPE_ID.