Search Results wms_els_trx_src




Overview
Explore in AI Chat

Overview

WMS_ELS_TRX_SRC is a transactional table in the Warehouse Management System (WMS) schema of Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. It stores the detailed records of labor-tracked transactions performed within a labor management enabled warehouse. Each row represents a discrete warehouse activity—picking, putaway, replenishment, or a similar task—captured at the moment the work was executed. Beyond the raw transaction, the table preserves attribution data: the user who performed the work, the equipment used, and the engineered labor standards (ELS) scores and ratings derived from the effort. This makes it the foundational source for labor performance reporting, productivity analytics, and engineered standards compliance in WMS.

The heuristic Data Vault classification mined from the foreign-key structure identifies this object as standalone. Under a Data Vault modeling suggestion, it would most closely resemble a satellite-like fact table—carrying measures (travel time, transaction time, idle time, scores) and descriptive context—rather than a pure hub or link. The absence of child tables referencing it reinforces its role as a leaf-level transactional record.

Key Information Stored

The table contains 43 documented columns. The most significant include:

Common Use Cases and Queries

Typical uses include labor productivity dashboards, employee scorecards, engineered standard variance analysis, and zone-level workload reporting. A representative query joining operations to operators might read:

SELECT t.els_trx_src_id, t.transaction_date, t.user_id, t.activity_id, t.txn_score, t.employee_rating_txn FROM wms.wms_els_trx_src t WHERE t.organization_id = :org_id AND t.transaction_date BETWEEN :start_date AND :end_date AND t.unattributed_flag = 'N' ORDER BY t.transaction_date DESC;

Aggregations over TRAVEL_TIME, TRANSACTION_TIME, and IDLE_TIME by USER_ID or ACTIVITY_ID support bottleneck identification and staffing decisions. The score and rating columns feed performance-ranking reports without requiring recomputation of the engineering standard.

Related Objects

Two documented foreign keys link this table to its operational context:

Related supporting objects include WMS_ELS_INDIVIDUAL_TASKS_B's detail tables, the WMS activity and operation setup tables referenced by ACTIVITY_ID and OPERATION_ID, and standard EBS inventory tables (MTL_SYSTEM_ITEMS_B, MTL_ITEM_CATEGORIES, HR_OPERATING_UNITS) used to enrich reporting. The table does not serve as a parent for other objects, consistent with its standalone classification.