Search Results ieu_cli_prov_plugin_med_map_u2

Overview

The IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS table is a seed data configuration table within the Interaction Center (IEU) module of Oracle E-Business Suite. Its documented purpose is to map the supported media types for Universal Work Queue (UWQ) Client Media Provider Plugins. In practical terms, it defines which communication channels — such as inbound phone calls, outbound calls, e-mail, or web chat — a given client media provider plug-in is permitted to handle. Because the plug-in framework in the Interaction Center relies on this mapping to route and present media-specific interactions to agents, this table sits at the intersection of channel configuration and plug-in execution.

The table resides in the APPS_TS_SEED tablespace, confirming its nature as reference and setup data rather than transactional data. Its foreign key relationship to IEU_UWQ_MEDIA_TYPES_B and its reference to IEU_CLI_PROV_PLUGINS establish it as an associative or mapping structure between two entities. From a Data Vault modeling perspective, the heuristic classification of this table is standalone, which suggests it functions as a link-style mapping table rather than a pure hub or satellite; the metadata classifies it as standalone, so this should be treated as a modeling suggestion rather than a definitive architectural assignment.

Key Information Stored

The table contains eleven columns, of which the most significant for functional and integration purposes are the following:

• PLUGIN_MED_MAP_ID — The surrogate primary key, defined by the IEU_CLI_PROV_PLUGIN_MED_MAP_PK constraint. This is a system-generated unique identifier for each mapping row.
• PLUGIN_ID — A foreign key to IEU_CLI_PROV_PLUGINS, identifying the specific media provider plug-in to which the media type mapping applies.
• MEDIA_TYPE_ID — A foreign key to IEU_UWQ_MEDIA_TYPES_B, identifying the media type (for example, voice call or e-mail) that the plug-in supports.
• CONDITIONAL_FUNC — A VARCHAR2(255) column holding the name of a PL/SQL function that can be dynamically invoked to determine whether the plug-in/media type mapping conditions are satisfied at runtime.
• OBJECT_VERSION_NUMBER — The standard Oracle Applications concurrency control column, used to detect lost updates in multi-user environments.
• The WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard audit trail information.
• ZD_EDITION_NAME — A VARCHAR2(30) editioning column associated with Oracle's Edition-Based Redefinition (EBR) support, which is particularly relevant in EBS 12.2.x environments.

The unique index IEU_CLI_PROV_PLUGIN_MED_MAP_U2 spans PLUGIN_MED_MAP_ID and ZD_EDITION_NAME. This composite unique index is the business-key candidate for the table, ensuring uniqueness of mapping records within each edition context.

Common Use Cases and Queries

Administrators and developers typically query this table when troubleshooting Interaction Center plug-in behavior, particularly when an agent workstation fails to display or process a specific media channel. A common diagnostic query joins the mapping table with its parent plug-in and media type definitions:

SELECT p.PLUGIN_ID, p.PLUGIN_NAME, m.MEDIA_TYPE_ID, mt.MEDIA_TYPE_NAME, c.CONDITIONAL_FUNC FROM IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS c JOIN IEU.IEU_CLI_PROV_PLUGINS p ON c.PLUGIN_ID = p.PLUGIN_ID JOIN IEU.IEU_UWQ_MEDIA_TYPES_B mt ON c.MEDIA_TYPE_ID = mt.MEDIA_TYPE_ID;

Reporting use cases include auditing which plug-ins support which media types, identifying mappings that have conditional functions attached (which may affect determinism and performance), and validating that seed data has been correctly applied during patching or upgrades. Because the table is in APPS_TS_SEED, its contents are typically maintained through Oracle-delivered seed data rather than end-user maintenance, so customization should be carefully managed to avoid conflicts during upgrade or patch application.

Related Objects

The following objects are most significant in relation to this table:

• IEU.IEU_UWQ_MEDIA_TYPES_B — The media type definition table referenced through MEDIA_TYPE_ID.
• IEU.IEU_CLI_PROV_PLUGINS — The plug-in definition table referenced through PLUGIN_ID.
• IEU.IEU_CLI_PROV_PLUGIN_MED_MAPS# — The editioning view over this base table, which is the object referenced by database code in EBS 12.2.x.
• IEU_CLI_PROV_PLUGIN_MED_MAP_PK — The primary key constraint enforcing PLUGIN_MED_MAP_ID uniqueness.
• IEU_CLI_PROV_PLUGIN_MED_MAP_U2 — The unique index on PLUGIN_MED_MAP_ID and ZD_EDITION_NAME.

The table does not reference any other database objects beyond its two foreign key parents. It is most commonly accessed indirectly through the Interaction Center and Universal Work Queue application modules rather than through direct external references.