Search Results wms_els_trx_src_u1

Overview

WMS.WMS_ELS_TRX_SRC is a transactional table in the Oracle E-Business Suite Warehouse Management System (WMS) schema. It stores labor-tracked transaction details for warehouses enabled with Oracle Labor Management (ELS). Each row captures a single labor transaction performed by a user and the associated performance metrics — travel time, transaction time, idle time, and the resulting scores and ratings — calculated from the activity the user completed. The table therefore serves as the operational fact store for labor productivity analysis in a warehouse.

From a modeling perspective, the mined dependency structure suggests treating this object as a standalone entity rather than a strict Data Vault construct. Although it references WMS_OP_PLANS_B and WMS_ELS_INDIVIDUAL_TASKS_B via foreign keys, no parent-child hub or satellite lineage is enforced, so it is classified heuristically as standalone. In practice it behaves as a transaction-level fact table joined to dimensional lookups (activities, operations, employees, equipment, and inventory locations).

Key Information Stored

The table contains 43 documented columns. The most operationally significant are:

• ELS_TRX_SRC_ID — surrogate primary key, enforced by unique index WMS_ELS_TRX_SRC_U1 and the primary key constraint WMS_ELS_TRX_SRC_PK. This is the only documented unique business-key candidate.
• TRANSACTION_DATE — timestamp of the labor transaction.
• ACTIVITY_ID, ACTIVITY_DETAIL_ID, OPERATION_ID — lookup-driven identifiers for the activity, its detail, and the operation performed (from lookup types WMS_ELS_ACTIVITIES, WMS_ELS_ACTIVITY_DETAILS, WMS_ELS_OPERATIONS).
• USER_ID, ORGANIZATION_ID — the employee who performed the task and the warehouse organization.
• INVENTORY_ITEM_ID, QUANTITY, TRANSACTION_UOM, ITEM_CATEGORY_ID — the item handled, quantity moved, unit of measure, and item category.
• TRAVEL_TIME, TRANSACTION_TIME, IDLE_TIME — component timings used for scoring and rating.
• TRAVEL_SCORE, TXN_SCORE, IDLE_SCORE, EMPLOYEE_RATING_TRAVEL, EMPLOYEE_RATING_TXN, EMPLOYEE_RATING_IDLE — derived performance measures.
• UNATTRIBUTED_FLAG, ELS_DATA_ID — flags and links for unattributed labor records; both are indexed (N1 and N3 respectively).

Secondary indexes N2 (ACTIVITY_ID, ACTIVITY_DETAIL_ID, OPERATION_ID, ORGANIZATION_ID, LABOR_TXN_SOURCE_ID) and N4 (ORGANIZATION_ID, USER_ID) support the most common filtering paths.

Common Use Cases and Queries

Typical usage includes measuring productivity by employee, shift, or activity; identifying unattributed labor; and validating travel versus transaction time ratios. A basic filtered query:

SELECT ELS_TRX_SRC_ID, TRANSACTION_DATE, USER_ID,
       ACTIVITY_ID, TRAVEL_TIME, TRANSACTION_TIME, IDLE_TIME,
       EMPLOYEE_RATING_TRAVEL, EMPLOYEE_RATING_TXN, EMPLOYEE_RATING_IDLE
FROM   WMS.WMS_ELS_TRX_SRC
WHERE  ORGANIZATION_ID = :org_id
AND    USER_ID = :user_id
AND    TRANSACTION_DATE BETWEEN :start_date AND :end_date;

Reporting queries frequently aggregate TRAVEL_TIME, TRANSACTION_TIME, and IDLE_TIME per activity or per user to benchmark labor standards, and filter on UNATTRIBUTED_FLAG to isolate records that were not linked to a planned task.

Related Objects

• WMS.WMS_OP_PLANS_B — joined via OPERATION_PLAN_ID; supplies the planned operation context.
• WMS.WMS_ELS_INDIVIDUAL_TASKS_B — joined via ELS_DATA_ID; provides individual task attribution.
• WMS_ELS_ACTIVITIES, WMS_ELS_ACTIVITY_DETAILS, WMS_ELS_OPERATIONS — lookup sources for ACTIVITY_ID, ACTIVITY_DETAIL_ID, and OPERATION_ID.
• WMS_OP_PLAN_OPERATIONS / WMS_OP_PLANS_TL — related plan-level views and translations.
• INV_ORGANIZATIONS / HR_EMPLOYEES — conventional joins for organization and user descriptions.