Search Results ieu_cli_prov_plugins_u2




Overview
Explore in AI Chat

Overview

The table IEU.IEU_CLI_PROV_PLUGINS is a seed configuration table within the Interaction/Universal Work Queue (UWQ) schema of Oracle E-Business Suite. It stores the registration records for client-side media provider plugins used by the UWQ runtime. Each row identifies a Java class that implements the oracle.apps.ieu.client.provider.ClientProviderAgent interface, thereby allowing the UWQ framework to discover and load the appropriate plugin for a given interaction channel. The object resides in the APPS_TS_SEED tablespace, consistent with its role as reference data rather than transactional data, and carries an FND Design Data reference of IEU.IEU_CLI_PROV_PLUGINS.

The documented relationship classification is standalone, meaning the table contains no foreign-key references to other database objects and is not referenced by any FK either; it is only referenced by its own editioning view IEU_CLI_PROV_PLUGINS#. In Data Vault terms, this is best modeled as a hub candidate: PLUGIN_ID is a durable, single-column business key that uniquely identifies a plugin across time, with no natural parent. The remaining descriptive attributes can be treated as hub-adjacent descriptive columns rather than a full satellite.

Key Information Stored

The primary key is enforced by IEU_CLI_PROV_PLUGINS_PK on the surrogate numeric key PLUGIN_ID (NUMBER(15)). A second UNIQUE index, IEU_CLI_PROV_PLUGINS_U2, covers the composite of PLUGIN_ID plus ZD_EDITION_NAME, which is the editioning discriminator used by EBS 12.2 online patching. ZD_EDITION_NAME (VARCHAR2(30)) should therefore be treated as part of the business key when querying from a non-editioned context.

The most operationally significant columns are:

  • PLUGIN_ID — surrogate primary key and the join anchor for all downstream configuration.
  • PLUGIN_CLASS_NAME (VARCHAR2(1996)) — the fully qualified Java class implementing ClientProviderAgent; this is the loadable artifact the UWQ runtime instantiates.
  • IS_ACTIVE_FLAG — a value other than Y/y suppresses loading of the plugin into the UWQ runtime, providing a soft enable/disable switch.
  • APPLICATION_ID — the unique application identifier that scopes the plugin to a product family.
  • OBJECT_VERSION_NUMBER — standard optimistic-locking column used by OAF and ADO-based frameworks.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.
  • ZD_EDITION_NAME — the edition tag used during online patching.

Common Use Cases and Queries

The primary operational use case is diagnosing why a particular UWQ media or channel plugin fails to load. Support teams query the active, non-editioned view to confirm the expected class name and activation state. A typical pattern filters on the activation flag and edition:

  • SELECT plugin_id, plugin_class_name, is_active_flag FROM ieu.ieu_cli_prov_plugins_v WHERE NVL(is_active_flag,'N') = 'Y' AND zd_edition_name = 'SET1';
  • Audit reporting on WHO columns to determine when a plugin registration was last changed and by which user.
  • Cross-referencing APPLICATION_ID against application registrations to inventory which products contribute client-side provider plugins.
  • Migration or cloning validation, confirming that seed rows exist in the target environment.

Because the object is flagged standalone, queries should not assume joins to child configuration tables; the editioned view is the recommended access path in a 12.2 multi-edition environment.

Related Objects

The documented dependency data shows no outgoing or incoming foreign-key relationships, so the following related objects are the practical dependencies a developer encounters rather than FK-linked tables:

  • IEU.IEU_CLI_PROV_PLUGINS# — the underlying editioning view that the table is referenced by.
  • IEU.IEU_CLI_PROV_PLUGINS_V — the consistent read view used by application code.
  • IEU_CLI_PROV_PLUGINS_PK / IEU_CLI_PROV_PLUGINS_U2 — the primary and unique indexes over PLUGIN_ID and ZD_EDITION_NAME.
  • The UWQ runtime loader, which consumes PLUGIN_CLASS_NAME and IS_ACTIVE_FLAG at client startup.
  • FND_APPLICATION, joinable on APPLICATION_ID to resolve the owning product.