Search Results ieu_ctl_plugins_tl

Overview

IEU_CTL_PLUGINS_TL is the translation (TL) table for UWQ Controller UI Plugins within the IEU – Universal Work Queue product module of Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, the Universal Work Queue provides a centralized framework through which agents in CRM and service applications receive, route, and act upon work items. Controller UI Plugins extend this framework by registering user-interface components that the UWQ controller renders for a given work item type. The _TL suffix denotes that this table stores the language-specific (translated) attributes of those plugins, principally the display name and description shown to end users in their session language.

The table is owned by the IEU schema and is documented as VALID, with 13 physical columns in the 12.2.2 ETRM schema. Its primary key, IEU_CTL_PLUGINS_TL_PK, is composed of PLUGIN_ID and LANGUAGE, establishing that each plugin may carry one row per installed language. From a Data Vault modeling perspective, the mined relationship metadata classifies this object as satellite-leaning: it depends on a parent base table via a foreign key and carries descriptive, change-tracked attributes rather than defining a new business key of its own. The base table IEU_CTL_PLUGINS_B functions as the hub for the plugin identity, while IEU_CTL_PLUGINS_TL behaves as a language-qualified satellite holding the translated descriptive payload.

Key Information Stored

The table stores descriptive, translatable attributes keyed to a plugin and a language. The most significant columns are:

• PLUGIN_ID – Surrogate identifier of the parent plugin; part of the composite primary key and the FK to IEU_CTL_PLUGINS_B.
• LANGUAGE – The NLS language code for the row; the second component of the primary key.
• SOURCE_LANG – The language in which the source (untranslated) record was created; used by the translation-retrieval logic to fall back when no translation exists.
• NAME – The translated display name of the plugin presented in the UWQ controller UI.
• DESCRIPTION – The translated description of the plugin's function.
• ZD_EDITION_NAME – Editioning column supporting EBR (Edition-Based Redefinition) in 12.2.x, allowing online patching and multiple editions of the same row to coexist.
• OBJECT_VERSION_NUMBER – Optimistic locking token used by the Oracle Application Framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns recording row creation and modification provenance.
• SECURITY_GROUP_ID – Optional security-group discriminator, with a foreign key to FND_SECURITY_GROUPS for multi-organization/security partitioning.

Regarding keys, the surrogate primary key is the composite (PLUGIN_ID, LANGUAGE). The unique index IEU_CTL_PLUGINS_TL_U1 (PLUGIN_ID, LANGUAGE, ZD_EDITION_NAME) is the edition-aware business-key candidate that enforces uniqueness across editions.

Common Use Cases and Queries

The primary use case is multilingual rendering: the UWQ controller joins the base plugin definition to its translation to obtain the correct NAME and DESCRIPTION for the agent's language. Reporting and integration scenarios include auditing which plugins have translations in each language, identifying missing translations, and listing active plugins per language.

A typical query retrieves plugin display data for a language, using the SOURCE_LANG fallback pattern:

• SELECT t.plugin_id, t.language, t.name, t.description FROM ieu.ieu_ctl_plugins_tl t WHERE t.language = USERENV('LANG') AND t.plugin_id = :p_plugin_id;
• To find plugins lacking a translation for a given language, outer-join IEU_CTL_PLUGINS_B to IEU_CTL_PLUGINS_TL on PLUGIN_ID and filter WHERE tl.language IS NULL.
• A translation-coverage report groups by PLUGIN_ID and counts distinct LANGUAGE values, joined to the base table for context.

Because the table carries editioning, any query in 12.2.2 should respect the edition context (typically through the EBS-provided synonym or edition-filtered view) to avoid returning rows from inactive editions.

Related Objects

The following objects are the most significant for joins and dependency analysis, based on the documented FK and PK relationships:

• IEU_CTL_PLUGINS_B – The base (non-translatable) plugin table; joined on PLUGIN_ID. It holds the language-independent definition of each controller UI plugin.
• FND_SECURITY_GROUPS – Referenced by SECURITY_GROUP_ID; provides security-group metadata for partitioned access.
• FND_LANGUAGES – The standard reference for LANGUAGE and SOURCE_LANG values, used to constrain or expand language selections.
• IEU_CTL_PLUGINS_VL (or equivalent) – The conventional language-view / synonym pattern over the base plus _TL table, used by application code to fetch NLS data transparently.
• IEU_CTL_PLUGINS_TL and its unique index IEU_CTL_PLUGINS_TL_U1 – the edition-aware uniqueness constraint that governs translation integrity.
• UWQ controller runtime views in the IEU schema – consume plugin metadata, including translations, when rendering work-item UI components.

Together these objects form the plugin-registration and presentation layer of the Universal Work Queue, with IEU_CTL_PLUGINS_TL supplying the language-sensitive attributes required for a localized agent experience.