Search Results wms_els_exp_resource

Overview

The WMS_ELS_EXP_RESOURCE table is a Warehouse Management (WMS) staging and analytical table within the Oracle E-Business Suite, owned by the WMS schema. It stores the output produced by the concurrent program Expected Resource Requirement Analysis, capturing projected workload and estimated resource demands across warehouse operations. When that program is launched, the table is populated with rows representing expected work, along with derived estimates for the time and resources each unit of work will require. As a result, the object functions less as a transactional store and more as a snapshot of anticipated demand used for labor and equipment planning.

From a Data Vault modeling perspective, the metadata characterises this table heuristically as standalone, meaning it is not classified as a hub, link, or satellite in the mined structure. This suggests it is best treated as an independent analytical or staging entity rather than a core integration point in a Data Vault build, though its foreign key relationships to operational planning and task tables would typically warrant satellite treatment in a governed warehouse model.

Key Information Stored

The table is defined with 30 documented columns. The most operationally significant are summarised below.

ELS_EXP_RESOURCE_ID — the surrogate primary key, enforced by WMS_ELS_EXP_RESOURCE_PK and also present in the unique index WMS_ELS_EXP_RESOURCE_U1, making it the sole documented business-key candidate.
OPERATION_PLAN_ID — foreign key to WMS_OP_PLANS_B, tying each expected-resource row to an operation plan.
ELS_DATA_ID — foreign key to WMS_ELS_INDIVIDUAL_TASKS_B, linking the expected work back to individual task data.
ORGANIZATION_ID — the warehouse or inventory organisation in scope.
ACTIVITY_ID / ACTIVITY_DETAIL_ID / OPERATION_ID — identify the specific warehouse activity, its detail, and the operation being planned.
DOCUMENT_TYPE — classifies the source document driving the expected work.
SOURCE_SUBINVENTORY, SOURCE_LOCATOR_ID, SOURCE_ZONE_ID — the originating subinventory, locator, and zone.
DESTINATION_SUBINVENTORY, DESTINATION_LOCATOR_ID, DESTINATION_ZONE_ID — the corresponding destination attributes.
INVENTORY_ITEM_ID / ITEM_CATEGORY_ID — the item and its category.
QUANTITY / TRANSACTION_UOM — expected quantity and its unit of measure.
ESTIMATED_TIME_REQUIRED / ESTIMATED_RESOURCE_REQUIRED — the core analytical outputs: projected time and resource demand.
WORK_SCHEDULED_DATE — the date the expected work is scheduled.
GROUP_ID, UNATTRIBUTED_FLAG, SOURCE_HEADER_ID, SOURCE_LINE_ID — grouping and source-line context, including flags for unattributed work.
Standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) provide change tracking.

Common Use Cases and Queries

Typical usage centres on resource forecasting, workload balancing, and capacity analysis. Analysts aggregate the estimated time and resource columns by organisation, zone, or date to plan labour shifts. The following pattern summarises estimated demand by work date:

SELECT WORK_SCHEDULED_DATE, ORGANIZATION_ID, SUM(ESTIMATED_TIME_REQUIRED) TOTAL_TIME, SUM(ESTIMATED_RESOURCE_REQUIRED) TOTAL_RESOURCE FROM WMS.WMS_ELS_EXP_RESOURCE GROUP BY WORK_SCHEDULED_DATE, ORGANIZATION_ID;
Join to WMS_OP_PLANS_B via OPERATION_PLAN_ID to enrich expected work with plan attributes.
Join to WMS_ELS_INDIVIDUAL_TASKS_B via ELS_DATA_ID to reconcile estimates against actual task structures.
Filter on UNATTRIBUTED_FLAG to isolate work lacking assignment, a common exception-reporting scenario.

Related Objects

WMS_OP_PLANS_B — referenced through OPERATION_PLAN_ID; supplies the operation plan header.
WMS_ELS_INDIVIDUAL_TASKS_B — referenced through ELS_DATA_ID; provides task-level detail.
WMS_ELS_EXP_RESOURCE_PK / WMS_ELS_EXP_RESOURCE_U1 — the primary key constraint and unique index on ELS_EXP_RESOURCE_ID.
Expected Resource Requirement Analysis concurrent program — the WMS process responsible for populating this table.
Inventory master tables referenced by inference (INVENTORY_ITEM_ID, ORGANIZATION_ID, locator and subinventory identifiers) support joins to item and warehouse master data.

Table: WMS_ELS_EXP_RESOURCE 12.2.2
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_ELS_EXP_RESOURCE, object_name:WMS_ELS_EXP_RESOURCE, status:VALID, product: WMS - Warehouse Management , description: This is the table which wil be populated by all the expected work when the Concurrent program Expected Resource Requirement Analysis will be launched. This table will also hold information regarding what is the estimated time and estimated , implementation_dba_data: WMS.WMS_ELS_EXP_RESOURCE ,
Table: WMS_ELS_EXP_RESOURCE 12.1.1
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_ELS_EXP_RESOURCE, object_name:WMS_ELS_EXP_RESOURCE, status:VALID, product: WMS - Warehouse Management , description: This is the table which wil be populated by all the expected work when the Concurrent program Expected Resource Requirement Analysis will be launched. This table will also hold information regarding what is the estimated time and estimated , implementation_dba_data: WMS.WMS_ELS_EXP_RESOURCE ,
SYNONYM: APPS.WMS_ELS_EXP_RESOURCE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_ELS_EXP_RESOURCE, status:VALID,
VIEW: WMS.WMS_ELS_EXP_RESOURCE# 12.2.2
owner:WMS, object_type:VIEW, object_name:WMS_ELS_EXP_RESOURCE#, status:VALID,
SYNONYM: APPS.WMS_ELS_EXP_RESOURCE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_ELS_EXP_RESOURCE, status:VALID,
PACKAGE: APPS.WMS_LMS_EXPECTED_RES 12.1.1
PACKAGE: APPS.WMS_LMS_EXPECTED_RES 12.2.2
VIEW: WMS.WMS_ELS_EXP_RESOURCE# 12.2.2
APPS.WMS_LMS_EXPECTED_RES SQL Statements 12.1.1
APPS.WMS_LMS_EXPECTED_RES SQL Statements 12.2.2
PACKAGE BODY: APPS.WMS_LMS_EXPECTED_RES 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_LMS_EXPECTED_RES, status:VALID,
PACKAGE BODY: APPS.WMS_LMS_EXPECTED_RES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_LMS_EXPECTED_RES, status:VALID,
PACKAGE BODY: APPS.WMS_LMS_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_LMS_UTILS, status:VALID,
PACKAGE BODY: APPS.WMS_LMS_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_LMS_UTILS, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.WMS_LMS_EXPECTED_RES 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.WMS_LMS_EXPECTED_RES 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
TABLE: WMS.WMS_ELS_EXP_RESOURCE 12.1.1
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_ELS_EXP_RESOURCE, object_name:WMS_ELS_EXP_RESOURCE, status:VALID,
TABLE: WMS.WMS_ELS_EXP_RESOURCE 12.2.2
owner:WMS, object_type:TABLE, fnd_design_data:WMS.WMS_ELS_EXP_RESOURCE, object_name:WMS_ELS_EXP_RESOURCE, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.WMS_LMS_UTILS SQL Statements 12.2.2
APPS.WMS_LMS_UTILS SQL Statements 12.1.1
APPS.WMS_LMS_UTILS dependencies on WMS_ELS_EXP_RESOURCE 12.1.1
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE 12.1.1
APPS.WMS_LMS_UTILS dependencies on WMS_ELS_EXP_RESOURCE 12.2.2
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE 12.2.2
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_INDIVIDUAL_TASKS_B 12.2.2
APPS.WMS_LMS_UTILS dependencies on MFG_LOOKUPS 12.2.2
APPS.WMS_LMS_UTILS dependencies on MFG_LOOKUPS 12.1.1
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_INDIVIDUAL_TASKS_B 12.1.1
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE_S 12.1.1
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE_S 12.2.2
PACKAGE BODY: APPS.WMS_LMS_UTILS 12.1.1
PACKAGE BODY: APPS.WMS_LMS_UTILS 12.2.2
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE_GTEMP 12.2.2
APPS.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE_GTEMP 12.1.1
eTRM - WMS Tables and Views 12.1.1
eTRM - WMS Tables and Views 12.2.2
APPS.WMS_LMS_UTILS dependencies on DUAL 12.2.2
APPS.WMS_LMS_UTILS dependencies on DUAL 12.1.1
eTRM - WMS Tables and Views 12.2.2
eTRM - WMS Tables and Views 12.1.1