Search Results ieu_wp_sections_tl




Overview
Explore in AI Chat

Overview

IEU_WP_SECTIONS_TL is the translation table for UWQ Work Panel Sections within the Oracle E-Business Suite Universal Work Queue (IEU) module. It stores the language-dependent descriptive content for each work panel section defined in the base table, IEU_WP_SECTIONS_B. Together, these two tables form the standard Oracle Applications MLS (Multi-Lingual Support) pattern, in which the "_B" table holds language-independent attributes and the "_TL" table holds translatable text keyed by SECTION_ID and LANGUAGE.

The table resides in the IEU schema and is marked VALID in the documented 12.1.1 and 12.2.2 environments. Its primary key, IEU_WP_SECTIONS_TL_PK, is composed of SECTION_ID and LANGUAGE. A secondary unique index, IEU_WP_SECTIONS_TL_U1, adds ZD_EDITION_NAME to that pair, reflecting the editioning and online patching architecture introduced in EBS 12.2. The documented physical schema comprises 13 columns.

Applying a heuristic Data Vault classification, this object is satellite-leaning. It is a dependent, descriptive child of the IEU_WP_SECTIONS_B hub rather than an independent entity, and its rows carry the language-variant labels and descriptions attached to each section. This classification should be regarded as a modeling suggestion, not an authoritative Data Vault design.

Key Information Stored

The most significant columns in IEU_WP_SECTIONS_TL are:

  • SECTION_ID — surrogate identifier of the parent work panel section; part of the primary key and the foreign key to IEU_WP_SECTIONS_B.
  • LANGUAGE — the language code for the translation row; the second component of the primary key.
  • SECTION_LABEL — the translatable display name of the work panel section shown to end users.
  • SECTION_DESCRIPTION — the translatable descriptive text for the section.
  • SOURCE_LANG — indicates the language in which the base record was originally authored.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications framework.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, governing row-level access.
  • ZD_EDITION_NAME — editioning column supporting the EBS 12.2 online patching model.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard "WHO" audit columns.

The surrogate primary key is the (SECTION_ID, LANGUAGE) pair. The unique index IEU_WP_SECTIONS_TL_U1 (SECTION_ID, LANGUAGE, ZD_EDITION_NAME) functions as the business-key candidate within the edition-aware model.

Common Use Cases and Queries

The table is principally queried to retrieve user-facing section labels and descriptions in the session language. A typical lookup joins the translation to the base table:

  • SELECT b.section_id, t.section_label, t.section_description FROM ieu.ieu_wp_sections_b b, ieu.ieu_wp_sections_tl t WHERE b.section_id = t.section_id AND t.language = USERENV('LANG');

Reporting teams use it to inventory all translated work panel sections, detect missing translations by comparing against FND_LANGUAGES, and audit who last modified label text. The WHO columns support change-tracking and audit extracts, while ZD_EDITION_NAME is relevant to post-patch verification in 12.2 environments.

Related Objects

  • IEU_WP_SECTIONS_B — the base table; joined on SECTION_ID (IEU_WP_SECTIONS_TL.SECTION_ID → IEU_WP_SECTIONS_B).
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for access control.
  • IEU_WP_SECTIONS_VL — the MLS view typically exposing both base and translated columns.
  • FND_LANGUAGES — provides the LANGUAGE values and installed-language verification.
  • IEU_WP_SECTIONS_TL_PK / IEU_WP_SECTIONS_TL_U1 — supporting indexes on SECTION_ID and LANGUAGE.