Results for “wms_els_individual_tasks_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS_ELS_INDIVIDUAL_TASKS_TL is a translation table within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores translatable setup information — most notably the descriptive text — associated with individual warehouse execution tasks defined by the Engineered Labor Standards (ELS) framework. In Oracle EBS, the "_TL" suffix denotes a table that holds language-specific (multilingual) attributes, allowing the same logical setup record to carry a separate description for each installed language. The base, non-translatable attributes reside in the corresponding base table (WMS_ELS_INDIVIDUAL_TASKS_B), while this table supplies the language-dependent DESCRIPTION column keyed by ELS_DATA_ID and LANGUAGE.

The ETRM metadata classifies this object heuristically as standalone under a Data Vault modeling lens. In practice this means the table carries no mined foreign-key dependencies in the documented structure and functions as an independent reference/translation entity rather than a true hub, link, or satellite. A Data Vault modeler would most naturally treat it as a contextual or descriptive reference table, subordinate in meaning to the base ELS task entity it decorates.

Key Information Stored

The table contains nine documented columns. The most significant are:

• ELS_DATA_ID — The identifier that links a translation row to its parent ELS individual-task setup record. It is part of the composite primary key.
• LANGUAGE — The EBS language code (for example, US or DE) identifying which installed language the DESCRIPTION applies to. It is the second component of the composite primary key.
• DESCRIPTION — The translatable, language-specific description of the individual task; this is the primary payload of the table.
• SOURCE_LANG — Indicates the source language from which the translation was derived, supporting the EBS translation workflow.
• LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE — Standard EBS audit (WHO) columns capturing the user, login, and timestamps for creation and last modification.

The surrogate primary key is WMS_ELS_INDIVIDUAL_TASKS_TL_PK, defined over (ELS_DATA_ID, LANGUAGE). A unique index, WMS_ELS_INDIVIDUAL_TASKS_TL_U1, also spans (ELS_DATA_ID, LANGUAGE), serving as the documented business-key candidate. Note that the primary key here is effectively a composite business key — a pattern common to EBS translation tables — rather than a single generated surrogate column.

Common Use Cases and Queries

This table is principally consumed for multilingual reporting and setup validation. A representative query retrieves the task description for a specific language:

• SELECT t.els_data_id, t.language, t.description FROM wms.wms_els_individual_tasks_tl t WHERE t.language = 'US' AND t.els_data_id = :data_id;
• Joining back to the base setup to produce a bilingual listing by joining on ELS_DATA_ID with a LANGUAGE predicate applied to the translation table.
• Reporting for labor-standards configuration audits, confirming that every active individual task carries a description in each required language.
• Data migration or language-installation validation, checking for missing translations by comparing distinct ELS_DATA_ID values against expected LANGUAGE codes.

Because the table is translation-oriented, queries should always filter on LANGUAGE to avoid returning multiple language rows for the same task.

Related Objects

The documented relationship classification is standalone, so no foreign keys are mined. Logical relationships are nonetheless implied by the shared ELS_DATA_ID column and the surrounding ELS setup model. Principal related objects include:

• WMS_ELS_INDIVIDUAL_TASKS_B — the base table holding the non-translatable attributes of each individual task; joined via ELS_DATA_ID.
• WMS_ELS_INDIVIDUAL_TASKS_VL — the standard EBS view that joins the base and translation tables to present a fully translated row.
• WMS_ELS_INDIVIDUAL_TASKS_TL_PK / _U1 — the primary key constraint and unique index enforcing uniqueness of (ELS_DATA_ID, LANGUAGE).
• Other ELS configuration tables in the WMS schema sharing the ELS_DATA_ID convention, used to assemble complete labor-standards definitions.

Together these objects form the multilingual configuration layer that warehouse managers rely on when defining and reporting engineered labor standards.