Search Results wms_els_individual_tasks_b




Overview
Explore in AI Chat

Overview

The WMS_ELS_INDIVIDUAL_TASKS_B table resides in the WMS schema and is part of the Oracle Warehouse Management (WMS) product family, specifically the Engineered Labor Standards (ELS) subsystem. Its documented purpose is to store all setup information for individual tasks — the discrete units of labor work that are planned, assigned, executed, and measured within a warehouse. In Oracle EBS 12.1.1 and 12.2.2, this table functions as the base (or "B") definition table that holds the master, language-independent attributes of each individual task record, which downstream runtime processes reference when tracking labor performance against engineered standards.

The ETRM metadata classifies this object heuristically as standalone within a Data Vault modeling suggestion. This means it is not positioned as a pure hub, link, or satellite, but rather behaves as an independent definitional entity keyed by its own identifier, with a single outbound reference to the operation plan structures. In practice, it serves as a hub-like anchor for task setup data, with transaction-scoped and resource-scoped detail tables linking back to it.

Key Information Stored

Each row is uniquely identified by the primary key constraint WMS_ELS_INDIVIDUAL_TASKS_PK, defined on the ELS_DATA_ID column. A separate unique index, WMS_ELS_INDIVIDUAL_TASKS_B_U1, also covers ELS_DATA_ID, making it the singular documented business-key candidate. The table contains 52 documented columns, of which the most operationally significant are:

Common Use Cases and Queries

Typical usage centers on labor standards configuration, performance variance reporting, and task matching. A common query retrieves all setup tasks for an organization and plan:

  • SELECT ELS_DATA_ID, SEQUENCE_NUMBER, OPERATION_ID, TASK_TYPE_ID, FROM_QUANTITY, TO_QUANTITY, EXPECTED_TXN_TIME FROM WMS_ELS_INDIVIDUAL_TASKS_B WHERE ORGANIZATION_ID = :org_id AND OPERATION_PLAN_ID = :plan_id ORDER BY SEQUENCE_NUMBER;
  • Variance analysis comparing standard versus actual engineered times:
    SELECT ELS_DATA_ID, (ACTUAL_TXN_TIME - EXPECTED_TXN_TIME) variance FROM WMS_ELS_INDIVIDUAL_TASKS_B WHERE TRAVEL_TIME_THRESHOLD IS NOT NULL AND HISTORY_FLAG = 'N';
  • Filtering non-archived, active task definitions using HISTORY_FLAG and ARCHIVE_DATE.
  • Resource and transaction-source matching via joins to WMS_ELS_EXP_RESOURCE and WMS_ELS_TRX_SRC on ELS_DATA_ID.

Related Objects

  • WMS_OP_PLANS_B — referenced via OPERATION_PLAN_ID; defines the parent operation plan.
  • WMS_ELS_EXP_RESOURCE — references this table through ELS_DATA_ID; holds expected resource assignments.
  • WMS_ELS_EXP_RESOURCE_GTEMP — global temporary staging for expected resource data linked by ELS_DATA_ID.
  • WMS_ELS_TRX_SRC — transaction source mapping referencing ELS_DATA_ID.
  • WMS_ELS_INDIVIDUAL_TASKS_TL — the translation table typically paired with the base table for language-dependent attributes (implied by the "_B" suffix convention).