Search Results ieu_ctl_plugins_b




Overview
Explore in AI Chat

Overview

IEU_CTL_PLUGINS_B is the base table in the IEU schema that stores the definition of Universal Work Queue (UWQ) Controller UI Plugins in Oracle E-Business Suite. The Universal Work Queue is the agent-facing framework used by modules such as Telephony, Interaction Center, and Advanced Collections to present work items, launch external applications, and drive agent desktop behavior. Within that framework, a "plugin" is a registered controller component that the UWQ Controller can invoke to render UI, play prompts, or trigger an application launch. This table holds the master (language-independent) definition of each such plugin.

The relationship metadata classifies IEU_CTL_PLUGINS_B as hub-leaning under a heuristic Data Vault model. That classification is a modeling suggestion rather than a physical constraint: the table acts as a durable reference entity identified by a surrogate key, with translations and other descriptive attributes attached elsewhere. It is not a transactional or event table, and its row count is typically small and stable.

Key Information Stored

The table is documented with 16 columns. The most significant are:

The business-key candidate documented is the composite unique key (PLUGIN_ID, ZD_EDITION_NAME); because PLUGIN_ID is already a single-column primary key, this unique index exists primarily to support the edition-based redefinition model introduced in 12.2.x. The table is not a _TL table, so translatable display names reside in the associated translation table rather than here.

Common Use Cases and Queries

Typical uses include auditing which plugin classes are registered, diagnosing agent desktop launch failures, and confirming that required plugins are present after patching or upgrade. A basic inventory query:

  • SELECT plugin_id, class_name, image_file_name, audio_file_name, is_required_flag, application_id FROM ieu.ieu_ctl_plugins_b ORDER BY plugin_id;
  • To join translated names: 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 list required plugins only: add WHERE is_required_flag = 'Y'.
  • To identify plugins by owning application: join APPLICATION_ID to FND_APPLICATION.

Because the row population is small and changes only through setup or patching, the table is most useful as a reference source in diagnostic scripts and post-patch verification reports rather than in high-volume operational reporting.

Related Objects

  • IEU_CTL_PLUGINS_TL — the translation table; joins on PLUGIN_ID (IEU_CTL_PLUGINS_TL.PLUGIN_ID references IEU_CTL_PLUGINS_B.PLUGIN_ID).
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, providing the security grouping context.
  • FND_APPLICATION — referenced through APPLICATION_ID for the owning application.
  • IEU_CTL_PLUGINS_B_PK / IEU_CTL_PLUGINS_B_U1 — the primary key constraint and the edition-aware unique index.
  • UWQ Controller configuration tables and the IEU UWQ public APIs — consumers that read plugin definitions to render the agent desktop and launch plugin functions.