Search Results ieu_ctl_plugins_tl_u1

Overview

IEU.IEU_CTL_PLUGINS_TL is a translation (TL) table in the Oracle E-Business Suite IEU schema, which supports the Interaction Center and Customer Care components of EBS. The table stores language-specific, translated text for the plug-in definitions maintained in the base table IEU_CTL_PLUGINS_B. Each row represents the name and description of a plug-in rendered in a specific language, enabling multilingual presentation of plug-in metadata to end users. The object is classified with a VALID status in ETRM 12.1.1 and 12.2.2, resides in the APPS_TS_SEED tablespace, and is flagged by Oracle as Internal Use Only, meaning it must be accessed through standard Oracle Applications programs rather than direct SQL.

From a Data Vault modeling perspective, this object is heuristically classified as satellite-leaning. This reflects its role as a descriptive attribute store (translated name, description) keyed by a business/natural key of PLUGIN_ID and LANGUAGE, with no independent identity of its own.

Key Information Stored

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

• PLUGIN_ID – Part of the composite primary key (IEU_CTL_PLUGINS_TL_PK) and a foreign key to IEU_CTL_PLUGINS_B.PLUGIN_ID. It identifies the parent plug-in.
• LANGUAGE – The other component of the primary key; the language of the translation.
• NAME – The translated name of the plug-in (VARCHAR2, 1990), the primary displayable business attribute.
• DESCRIPTION – The translated description of the plug-in.
• SOURCE_LANG – The source language from which the translation originated, used in multilingial seed data.
• OBJECT_VERSION_NUMBER – Standard column used by HTML/forms utilities for optimistic locking.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, used in hosted (multi-tenant) environments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.

The unique index IEU_CTL_PLUGINS_TL_U1 covers (PLUGIN_ID, LANGUAGE, ZD_EDITION_NAME), where ZD_EDITION_NAME supports edition-based redefinition introduced in 12.2.x. This unique index serves as the business-key candidate distinguishing it from the PLUGIN_ID/LANGUAGE surrogate composite PK.

Common Use Cases and Queries

Typical uses include generating multilingual reports on plug-in definitions, resolving translated labels for UI customization, and joining base and translation records to compare language variants.

SELECT p.PLUGIN_ID, t.LANGUAGE, t.NAME, t.DESCRIPTION
FROM   IEU_CTL_PLUGINS_B p,
       IEU_CTL_PLUGINS_TL t
WHERE  p.PLUGIN_ID = t.PLUGIN_ID
AND    t.LANGUAGE  = USERENV('LANG');

Administrators may also query for missing translations by comparing base plug-in counts against TL counts per language, or trace audit history via LAST_UPDATE_DATE. Because the object is Internal Use Only, such queries should normally be executed through certified EBS APIs rather than ad hoc.

Related Objects

• IEU_CTL_PLUGINS_B – Base table; joined on PLUGIN_ID (=PLUGIN_ID).
• IEU_CTL_PLUGINS_TL_U1 – Unique index enforcing (PLUGIN_ID, LANGUAGE, ZD_EDITION_NAME).
• IEU_CTL_PLUGINS_TL_PK – Primary key on (PLUGIN_ID, LANGUAGE).
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID for hosted environments.
• APPS.IEU_CTL_PLUGINS_TL – The APPS synonym through which the table is normally accessed.