Search Results ieu_cli_prov_plugin_med_map_u1

Overview

The IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS table is a configuration mapping table within the IEU (Universal Work Queue) product family in Oracle E-Business Suite. Its documented purpose is to map the supported media types to UWQ (Universal Work Queue) Client Media Provider Plugins. In practical terms, it defines which communication channels (media types) each client-side media provider plugin is permitted to handle when the Universal Work Queue routes or presents customer interactions to an agent.

The Universal Work Queue aggregates work items from multiple sources and presents them to agents in a unified interface. Media provider plugins extend this interface to specific channels such as telephony, e-mail, chat, or web callback. This table functions as the join between a plugin definition and the media type catalogue, allowing administrators to declare, per plugin, which media types are supported and under which conditions.

Based on the foreign key structure mined from the metadata, the heuristic Data Vault classification for this object is standalone. Modeling guidance would therefore treat it as an independent mapping or link-style table rather than as a hub or satellite. It carries its own surrogate key and a small number of reference attributes, and it does not act as a parent for subordinate entities.

Key Information Stored

The table contains 11 documented columns. The most significant of these are:

• PLUGIN_MED_MAP_ID — the surrogate primary key, enforced by the IEU_CLI_PROV_PLUGIN_MED_MAP_PK constraint, uniquely identifying each mapping row.
• PLUGIN_ID — identifies the UWQ Client Media Provider Plugin participating in the mapping. Together with MEDIA_TYPE_ID, this forms the business-key candidate declared through the unique index IEU_CLI_PROV_PLUGIN_MED_MAP_U1, ensuring a given plugin is mapped to a given media type only once.
• MEDIA_TYPE_ID — the media type supported by the plugin, referencing IEU_UWQ_MEDIA_TYPES_B.
• CONDITIONAL_FUNC — holds the name of a function or procedure that conditionally evaluates whether the plugin may service the media type at runtime. This supports dynamic availability logic beyond a static yes/no mapping.
• OBJECT_VERSION_NUMBER — implements optimistic locking for concurrent update protection, a standard pattern in EBS 12.1.1 and 12.2.2 tables.
• ZD_EDITION_NAME — the editioning column introduced for Online Patching in EBS 12.2, participating in the secondary unique index IEU_CLI_PROV_PLUGIN_MED_MAP_U2 together with PLUGIN_MED_MAP_ID.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard Oracle Applications who/when auditability.

Note the distinction between the surrogate key (PLUGIN_MED_MAP_ID) and the business-key candidate (PLUGIN_ID plus MEDIA_TYPE_ID), which represents the natural uniqueness rule for the mapping.

Common Use Cases and Queries

Typical scenarios include validating plugin configuration after an upgrade, diagnosing why an agent does not see a particular media type in the Work Queue, and auditing which plugins service which channels across an environment. A common reporting pattern joins the table to the media type base table to resolve descriptions:

• List all mappings for a plugin: SELECT m.PLUGIN_MED_MAP_ID, m.MEDIA_TYPE_ID, m.CONDITIONAL_FUNC FROM IEU_CLI_PROV_PLUGIN_MED_MAPS m WHERE m.PLUGIN_ID = :plugin_id;
• Resolve media type names: join MEDIA_TYPE_ID to IEU_UWQ_MEDIA_TYPES_B to translate the identifier into a user-readable media type label.
• Detect duplicate or missing mappings: group by PLUGIN_ID and MEDIA_TYPE_ID to confirm the unique index invariant is honoured and to spot plugins with no media types configured.
• Edition-aware queries in 12.2: filter on ZD_EDITION_NAME when querying during an online patching cycle, since rows may exist in both the run and patch editions.

Related Objects

The most significant related object is the media type definition table referenced by foreign key:

• IEU_UWQ_MEDIA_TYPES_B — referenced via IEU_CLI_PROV_PLUGIN_MED_MAPS.MEDIA_TYPE_ID → IEU_UWQ_MEDIA_TYPES_B. This is the primary parent lookup supplying the media type being mapped.
• IEU_CLI_PROV_PLUGIN_MED_MAPS indexes IEU_CLI_PROV_PLUGIN_MED_MAP_PK, IEU_CLI_PROV_PLUGIN_MED_MAP_U1, and IEU_CLI_PROV_PLUGIN_MED_MAP_U2, which enumerate the key and uniqueness constraints described above.

The metadata documents a single foreign key relationship and classifies the object as standalone, so the plugin definition table implied by PLUGIN_ID is not formally captured as a documented FK in this excerpt. Administrators and developers should treat PLUGIN_ID as the reference to the plugin registry within the IEU Universal Work Queue plugin configuration, and consult the IEU product schema for the corresponding plugin definition table where available.