Search Results warehouse




Overview
Explore in AI Chat

Overview

The WMS_ELS_RATINGS_SETUP table is a core data object within the Warehouse Management System (WMS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store configuration and setup information for the labor rating system in a warehouse that has Labor Management (ELS - Enterprise Labor Standards) functionality enabled. This table acts as a foundational repository for defining how labor performance is measured and rated, directly supporting the calculation of productivity metrics and efficiency standards for warehouse operations. Its existence is critical for organizations utilizing Oracle's advanced labor management capabilities to optimize workforce productivity and operational costs.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose is to hold ratings setup information. Based on its function and standard EBS design patterns, the table likely contains key identifiers and configuration parameters. The documented primary key column is ELS_RATINGS_SETUP_ID, a unique system-generated identifier for each ratings setup record. Other probable columns include fields to associate the setup with a specific warehouse (ORGANIZATION_ID), define the applicable labor standard or activity, and store the rating parameters, thresholds, or formulas used to evaluate performance. The table may also contain standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is primarily accessed for system configuration, reporting, and integration. Common use cases involve the initial setup and maintenance of labor standards, generating reports on defined productivity benchmarks, and feeding data into labor performance dashboards. A typical query would retrieve all ratings setups for a specific warehouse to review or audit configurations. For example:

  • SELECT * FROM wms.wms_els_ratings_setup WHERE organization_id = :org_id;

Another common pattern is joining this table to labor transaction or performance history tables to analyze actual performance against the defined standards. Administrators may query this table via backend scripts when migrating or copying labor management setups between different warehouse organizations.

Related Objects

The WMS_ELS_RATINGS_SETUP table is central to the Labor Management data model. Its primary key, ELS_RATINGS_SETUP_ID, is almost certainly referenced by foreign keys in other transactional or historical tables. Although specific related tables are not listed in the metadata, it is logically related to objects storing labor standards definitions (e.g., WMS_ELS_STANDARDS), employee assignments, and recorded labor performance data. The table is protected by the primary key constraint WMS_ELS_RATINGS_SETUP_PK. It may also have associated database views or APIs, such as WMS_ELS_RATINGS_SETUP_V or relevant PL/SQL packages in the WMS schema, that provide application-level access to this setup data.