Search Results ieu_uwq_svr_mps_plugins




Overview
Explore in AI Chat

Overview

IEU.IEU_UWQ_SVR_MPS_PLUGINS is a configuration table in the IEU (Universal Work Queue) product module of Oracle E-Business Suite, documented as VALID in both the 12.1.1 and 12.2.2 releases. Its description — "UWQ Server (Media Provider) Plugins" — indicates that the table registers server-side media provider plugin implementations that the Universal Work Queue uses to service work items originating from different communication channels. In EBS 12.1.1 and 12.2.2, UWQ provides the routing and assignment infrastructure that surfaces work items to agents in applications such as Telephony, Email Center, and Interaction Center; each media provider plugin is the Java class responsible for that channel's interaction with the UWQ server.

The ETRM metadata assigns a heuristic Data Vault classification of link. This is a modeling suggestion rather than a physical constraint: the table's foreign keys to FND_APPLICATION and IEO_SVR_TYPES_B make it a natural association between an application, a server type, and a plugin implementation, and it would typically be modeled as a link table connecting those business entities. The physical schema is owned by IEU and documents 12 columns.

Key Information Stored

The table's most significant columns, as documented in the ETRM 12.2.2 physical schema, are:

The 12.1.1 structure is functionally identical minus the editioning column, so SQL written against named columns rather than SELECT * ports cleanly between the two releases.

Common Use Cases and Queries

Typical uses center on diagnosing why a media channel fails to surface work items in UWQ, and on auditing which plugin class serves a given server type. A join to the server-type and application tables is the standard pattern:

  • SELECT p.SVR_MPS_PLUGIN_ID, st.SVR_TYPE_NAME, p.SVR_PLUGIN_CLASS, fa.APPLICATION_SHORT_NAME FROM IEU.UWQ_SVR_MPS_PLUGINS p, IEO.IEO_SVR_TYPES_B st, FND_APPLICATION fa WHERE p.SVR_TYPE_ID = st.SVR_TYPE_ID AND p.APPLICATION_ID = fa.APPLICATION_ID;
  • Locating the plugin for one channel: filter on SVR_TYPE_ID or on a specific SVR_PLUGIN_CLASS value to confirm which implementation is registered.
  • Post-upgrade validation queries that compare SVR_PLUGIN_CLASS values against the deployed Java classes to detect orphaned or obsolete registrations.
  • In 12.2.2, edition-aware reporting should filter or join on ZD_EDITION_NAME to avoid reading rows from inactive editions.

Related Objects

  • IEO_SVR_TYPES_B — parent server-type definition; joined via IEU_UWQ_SVR_MPS_PLUGINS.SVR_TYPE_ID → IEO_SVR_TYPES_B.SVR_TYPE_ID.
  • FND_APPLICATION — application registry; joined via APPLICATION_ID.
  • FND_SECURITY_GROUPS — security group definition; joined via SECURITY_GROUP_ID.
  • IEO_SVR_TYPES_TL — translation table for server-type names, useful in reporting joins.
  • FND_APPLICATION_TL — translated application names for readable output.
  • IEU_UWQ_SVR_MPS_PLUGINS_PK / _U1 / _U2 — the primary key and unique indexes that enforce the table's business keys.