Search Results ieu_uwqm_work_sources_tl




Overview
Explore in AI Chat

Overview

The IEU.IEU_UWQM_WORK_SOURCES_TL table is the translation table for UWQ (Universal Work Queue) work sources within the Oracle E-Business Suite IEU (Universal Work Queue) module. It stores language-specific display text—names and descriptions—for work source definitions maintained in the base table IEU_UWQM_WORK_SOURCES_B. Work sources identify the origin of tasks and activities routed through the Universal Work Queue, allowing agents and supervisors to view, filter, and act on assignments originating from CRM, Service, TeleSales, and other integrated modules. Because the table carries the _TL suffix, it follows the standard EBS multilingual pattern: a single translated row per work source per installed language. The table resides in the IEU schema and is marked VALID in the documented ETRM 12.2.2 physical schema, containing 13 columns.

Based on the heuristic Data Vault classification mined from the foreign key structure—which shows only a single outbound reference to FND_SECURITY_GROUPS and no dependent child tables—this object is best modeled as a standalone reference table rather than a hub, link, or satellite. It functions as a language-dependent descriptive attribute store keyed by the work source identifier and language code.

Key Information Stored

The table's identity and descriptive content are concentrated in a small set of columns:

  • WS_ID — The work source identifier. This is the foreign key to the base work source definition and forms part of the composite primary key.
  • LANGUAGE — The installed Oracle language code (for example, US for American English). Together with WS_ID, it completes the primary key.
  • WS_NAME — The translated, user-facing name of the work source. This is the primary value surfaced on UWQ agent dashboards and selection lists.
  • WS_DESCRIPTION — The translated longer description of the work source, used in setup and administrative views.
  • SOURCE_LANG — The language from which the row was originally derived, supporting the standard EBS translation-maintenance logic.
  • SECURITY_GROUP_ID — The foreign key to FND_SECURITY_GROUPS, enforcing function and data security partitioning of the translated records.
  • ZD_EDITION_NAME — The edition identifier used in EBS online patching (adop) to isolate rows by edition, ensuring translated content is consistent across the run edition and patch edition.
  • OBJECT_VERSION_NUMBER — The optimistic locking column that prevents lost updates when concurrent sessions modify the same translation row.
  • CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard EBS audit columns identifying who created and last modified each translated row, when, and through which login session.

The surrogate primary key is defined by the IEU_UWQM_WORK_SOURCES_TL_PK index on (WS_ID, LANGUAGE). The business-key candidate is the unique index IEU_UWQM_WORK_SOURCES_TL_U1 on (WS_ID, LANGUAGE, ZD_EDITION_NAME), which extends the key with the edition column to support online patching.

Common Use Cases and Queries

Reporting and support scenarios typically join the translation table to the base table to resolve a work source identifier into a user-readable label for a specific language. A typical query pattern resolves a single language while honoring the edition:

  • Retrieve translated work source names for the current session language by joining on WS_ID and filtering LANGUAGE = USERENV('LANG').
  • Detect missing translations by comparing rows in the base table against available LANGUAGE values, commonly used during multilingual implementations.
  • Audit recent translation changes using LAST_UPDATED_BY and LAST_UPDATE_DATE within a date range.
  • Extract setup data for migrations, filtering on SECURITY_GROUP_ID to scope output to a specific security group.

Representative SQL:

SELECT tl.ws_id, tl.ws_name, tl.ws_description
FROM   ieu.ieu_uwqm_work_sources_tl tl
WHERE  tl.language = USERENV('LANG')
AND    tl.zd_edition_name = 'SET1';

Related Objects

  • IEU_UWQM_WORK_SOURCES_B — The base (non-translated) work source definitions joined on WS_ID; the translation row supplies the language-specific WS_NAME and WS_DESCRIPTION.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; determines the security group under which each translated row is accessible.
  • FND_LANGUAGES — The source of valid installed language codes matched to the LANGUAGE column.
  • IEU_UWQM_WORK_SOURCES_TL_PK — The composite primary key index on (WS_ID, LANGUAGE) enforcing uniqueness of each translation row.
  • IEU_UWQM_WORK_SOURCES_TL_U1 — The unique index on (WS_ID, LANGUAGE, ZD_EDITION_NAME) supporting edition-aware lookups.
  • FND_APPLICATION / IEU product definitions — Context objects defining the Universal Work Queue application ownership of this table.