Search Results ieu_ctl_plugins_b_u1

Overview

IEU.IEU_CTL_PLUGINS_B is a seed-data table within the Interaction Center (IEU) schema of Oracle E-Business Suite. It serves as the master repository for plugin definitions used by the Interaction Center framework, storing the metadata that controls how external or internal plugins are registered, loaded, and presented in the agent user interface. Each row describes a single plugin, including its implementing Java class, associated visual and audio assets, launch behavior, and ownership by an Oracle application.

The table resides in the APPS_TS_SEED tablespace, confirming its role as a seeded configuration object rather than transactional data. It is populated during product installation and patching under the FND Design Data designation IEU.IEU_CTL_PLUGINS_B, and Oracle explicitly restricts supported access to standard Oracle Applications programs.

Based on the foreign key structure, the ETRM metadata assigns a heuristic Data Vault classification of hub-leaning for this object. This classification is a modeling suggestion: IEU_CTL_PLUGINS_B behaves as a durable, relatively stable keyed entity whose primary key is referenced by dependent descriptive tables, which is characteristic of a hub pattern rather than a transactional link or satellite.

Key Information Stored

The table is defined with sixteen documented columns. The most operationally significant are:

• PLUGIN_ID — NUMBER(15), mandatory. The surrogate primary key for the table, enforced by unique index IEU_CTL_PLUGINS_B_PK. A second unique index, IEU_CTL_PLUGINS_B_U1, is documented over PLUGIN_ID and ZD_EDITION_NAME, making that pair a business-key candidate for edition-aware environments.
• CLASS_NAME — VARCHAR2(1990). Fully qualified Java class name of the plugin to load; this is the executable identity of the plugin.
• IMAGE_FILE_NAME and AUDIO_FILE_NAME — VARCHAR2(1990). Asset filenames used to render the plugin in the user interface.
• IS_REQUIRED_FLAG — VARCHAR2. Indicates whether loading the plugin is mandatory for the Interaction Center session.
• DO_LAUNCH_FUNC — VARCHAR2(255). Names the function that determines whether the plugin should be launched at runtime.
• INIT_ERROR_MSG_NAME — VARCHAR2(30). Optional foreign key to FND_NEW_MESSAGES supplying an error message when plugin initialization fails.
• APPLICATION_ID — NUMBER. Identifies the owning Oracle application and is used together with INIT_ERROR_MSG_NAME to resolve messages.
• SECURITY_GROUP_ID — NUMBER. Supports hosted or multi-tenant deployments.
• OBJECT_VERSION_NUMBER along with the WHO columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard concurrency control and audit lineage.

Common Use Cases and Queries

Typical usage centers on diagnosing Interaction Center plugin behavior, auditing which plugins are mandatory, and confirming asset or message references for a given plugin. A representative query lists all plugins with their owning application and launch behavior:

• SELECT p.PLUGIN_ID, p.CLASS_NAME, p.IS_REQUIRED_FLAG, p.DO_LAUNCH_FUNC, a.APPLICATION_SHORT_NAME FROM IEU.IEU_CTL_PLUGINS_B p, FND_APPLICATION a WHERE p.APPLICATION_ID = a.APPLICATION_ID;
• To find translatable names for a plugin in a multilingual deployment, join to the dependent translation table: SELECT b.PLUGIN_ID, t.PLUGIN_NAME FROM IEU.IEU_CTL_PLUGINS_B b, IEU.IEU_CTL_PLUGINS_TL t WHERE b.PLUGIN_ID = t.PLUGIN_ID AND t.LANGUAGE = USERENV('LANG');
• To validate error-message wiring, join INIT_ERROR_MSG_NAME and APPLICATION_ID to FND_NEW_MESSAGES.

Reporting use cases include auditing mandatory plugins, identifying plugins with missing image or audio assets, and tracing which application owns a given plugin for patching or upgrade impact analysis.

Related Objects

• IEU.IEU_CTL_PLUGINS_TL — the translation (satellite) table referencing IEU_CTL_PLUGINS_B.PLUGIN_ID; holds language-specific plugin names.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for hosted-environment security grouping.
• FND_NEW_MESSAGES — referenced by INIT_ERROR_MSG_NAME and APPLICATION_ID for initialization error messaging.
• FND_APPLICATION — resolves APPLICATION_ID to the owning application for reporting and join queries.

Note: the search term "wordpress plugin fonts-plugin-cmspro" is unrelated to this Oracle EBS object; this article documents only the EBS seed table IEU_CTL_PLUGINS_B.