Search Results ieu_wp_ui_components_tl




Overview
Explore in AI Chat

Overview

IEU_WP_UI_COMPONENTS_TL is the translation (TL) table for UWQ UI Components within the IEU — Universal Work Queue — module of Oracle E-Business Suite. It stores the language-specific, displayable text for each UI component defined in the Universal Work Queue framework, which is the infrastructure that powers agent-facing work queues such as those used by TeleService, iSupport, and other interaction-center applications. In Oracle EBS 12.1.1 and 12.2.2, this table follows the standard multi-language design pattern: language-independent attributes (identification, ownership, and operational settings) reside in the base table IEU_WP_UI_COMPONENTS_B, while translatable attributes — labels and descriptions — are held here, keyed by both component identifier and language.

Based on the foreign-key structure documented in the ETRM metadata, the heuristic Data Vault classification for this object is satellite-leaning. In Data Vault modeling terms, a satellite captures descriptive, time-variant attributes attached to a hub or link; the strong dependency of this table on IEU_WP_UI_COMPONENTS_B via UI_COMP_ID, combined with its role of holding descriptive text, is consistent with that pattern. This classification is a modeling suggestion only and should not be treated as a formal designation.

Key Information Stored

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

  • UI_COMP_ID — Surrogate identifier of the UI component; foreign key to IEU_WP_UI_COMPONENTS_B. Forms part of the composite primary key.
  • LANGUAGE — The language code for the translated row. Forms the second component of the composite primary key.
  • UI_COMP_LABEL — The translated, user-visible label displayed for the UI component in the work queue interface.
  • UI_COMP_DESC — The translated description text associated with the UI component.
  • SOURCE_LANG — Indicates the source language of the row, used by the translation (MLS) infrastructure.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit "WHO" columns recording row creation and modification history.
  • SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, supporting multi-organization security access control.
  • ZD_EDITION_NAME — Editioning support column present in the 12.2.2 documented physical schema, used by the EBR (Edition-Based Redefinition) online patching architecture.

The composite primary key is IEU_WP_UI_COMPONENTS_TL_PK (UI_COMP_ID, LANGUAGE). A unique business-key candidate is documented as IEU_WP_UI_COMPONENTS_TL_U1 (UI_COMP_ID, LANGUAGE, ZD_EDITION_NAME), which adds the edition column to enforce uniqueness across editioning scope. The 12.2.2 physical schema documents 13 columns under the IEU schema owner.

Common Use Cases and Queries

Typical use cases include looking up the display label of a work queue UI component for a given language, validating that translations exist for all required languages, and auditing translation coverage before enabling a locale.

To retrieve translated component text with the base component definition:

  • SELECT b.ui_comp_id, tl.language, tl.ui_comp_label, tl.ui_comp_desc FROM ieu.ieu_wp_ui_components_b b, ieu.ieu_wp_ui_components_tl tl WHERE b.ui_comp_id = tl.ui_comp_id AND tl.language = USERENV('LANG');

To find components missing a translation for a specific language:

  • SELECT b.ui_comp_id FROM ieu.ieu_wp_ui_components_b b WHERE NOT EXISTS (SELECT 1 FROM ieu.ieu_wp_ui_components_tl tl WHERE tl.ui_comp_id = b.ui_comp_id AND tl.language = 'US');

Reporting use cases include translation completeness reports, label-change audits (using LAST_UPDATE_DATE), and analysis of which components are exposed to which security groups via SECURITY_GROUP_ID.

Related Objects

  • IEU_WP_UI_COMPONENTS_B — The base table holding language-independent component attributes; joined on UI_COMP_ID. This is the primary FK relationship.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for security group access control.
  • IEU_WP_UI_COMPONENTS_TL_PK — The composite primary key constraint (UI_COMP_ID, LANGUAGE) enforcing row uniqueness.
  • IEU_WP_UI_COMPONENTS_TL_U1 — Unique index providing the business-key candidate (UI_COMP_ID, LANGUAGE, ZD_EDITION_NAME).
  • FND_LANGUAGES / FND_LANGUAGE — Supplies the valid LANGUAGE codes for the MLS translation rows.
  • IEU_WP_COMPONENT_ATTRIBUTES and related UWQ configuration tables — Configure work queue component behavior and typically resolve to the same component identifiers used here.