Results for “wms_tasks_temp”

20 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS.WMS_TASKS_TEMP is a staging and interface table in the Oracle E-Business Suite Warehouse Management (WMS) module. It holds transient or pre-processed task records that feed the Warehouse Management execution engine — typically material handling, dispatching, and task confirmation operations. Rows represent warehouse tasks (moves, picks, putaways, transfers) that are queued or in-flight, and they carry both the item/inventory context and the resource context (person, equipment, machine) required to execute the work.

From a Data Vault modeling perspective, the FK analysis classifies this table as standalone, meaning it has no documented outbound dependencies beyond lightweight lookups to CS_SYSTEMS_ALL_B_TEMP and MTL_TXN_SOURCE_TYPES. In practice it behaves as a link/satellite hybrid: it ties together an inventory transaction context, a source document, and an assigned resource, and it stores descriptive attributes on that association. The _TEMP suffix indicates it is not the authoritative transactional repository — it is a work/staging surface consumed by WMS concurrent programs and mobile/automated material handling integrations.

Key Information Stored

The documented 12.2.2 physical schema exposes 87 columns. The most significant are:

Common Use Cases and Queries

Typical uses include monitoring in-flight warehouse tasks, diagnosing dispatch failures, reconciling task quantities against confirmed inventory transactions, and reporting operator/equipment throughput.

Example: locate open tasks awaiting dispatch for an organization.

SELECT t.task_id, t.item, t.transaction_quantity,
       t.status_code, t.priority, t.dispatched_time
FROM   wms.wms_tasks_temp t
WHERE  t.organization_id = :org_id
AND    t.status_code IS NULL
ORDER BY t.priority, t.creation_date;

Example: trace tasks back to their originating document type.

SELECT t.task_id, ts.transaction_source_type, t.transaction_source_name,
       t.item, t.transaction_quantity
FROM   wms.wms_tasks_temp t,
       mtl_txn_source_types ts
WHERE  t.transaction_source_type_id = ts.transaction_source_type_id;

A join to CS_SYSTEMS_ALL_B_TEMP on ROW_ID is used to resolve system/source metadata. Reporting on task cycle times can compare DISPATCHED_TIME, LOADED_TIME, and DROP_OFF_TIME.

Related Objects

The following are the most significant objects referenced by or interacting with this table:

  • CS_SYSTEMS_ALL_B_TEMP — joined via WMS_TASKS_TEMP.ROW_ID.
  • MTL_TXN_SOURCE_TYPES — joined via TRANSACTION_SOURCE_TYPE_ID.
  • MTL_SYSTEM_ITEMS_B — provides item definition for INVENTORY_ITEM_ID.
  • MTL_ITEM_LOCATIONS / MTL_SECONDARY_INVENTORIES — resolve locator and subinventory context.
  • MTL_MATERIAL_TRANSACTIONS — the confirmed transaction that a task ultimately produces.
  • WMS_DISPATCHED_TASKS / WMS_TASKS — the operational task surfaces that consume staged rows.
  • WMS_LPN_CONTENTS — links license plate content via LPN_ID and related columns.
  • PER_ALL_PEOPLE_F — resolves PERSON_ID to the assigned operator.
  • WMS task APIs / mobile material handling programs — the consumers that read and confirm rows from this staging table.