Search Results ieu_uwq_svr_mps_mmaps




Overview
Explore in AI Chat

Overview

The IEU_UWQ_SVR_MPS_MMAPS table is a core data object within the Universal Work Queue (UWQ) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a mapping or junction table that defines the relationships between different server types and the media types they support. Specifically, it maps Media Provider Servers (MPS) to the communication media channels they are configured to handle, such as email, chat, or voice. This table is essential for the UWQ framework's ability to correctly route and assign work items from various inbound and outbound communication channels to the appropriate agent queues based on server capabilities and media type.

Key Information Stored

The table's structure is designed to enforce unique mappings between server types and media types. Its primary columns include the surrogate primary key, SVR_MPS_MMAP_ID, and the two critical foreign key columns that establish the relationship. The MEDIA_TYPE_ID column references a specific media channel defined in the IEU_UWQ_MEDIA_TYPES_B table. The SVR_TYPE_ID column, as indicated by the user's search context and the unique key constraint, identifies the type of server. Together, these columns form the unique key IEU_UWQ_SVR_MPS_MMAPS_UK1, ensuring that a given server type is not mapped to the same media type more than once.

Common Use Cases and Queries

This table is primarily accessed for configuration validation and operational reporting within the UWQ administration. A common use case involves querying all media types supported by a specific server type to verify setup or troubleshoot routing issues. For example, an administrator might run a query to list all media channels a particular chat server is configured to process. Sample SQL to retrieve this mapping would typically join with the IEU_UWQ_MEDIA_TYPES_B table to get the media type name.

SELECT mm.svr_type_id, mt.media_type_name
FROM ieu.ieu_uwq_svr_mps_mmaps mm,
     ieu.ieu_uwq_media_types_b mt
WHERE mm.media_type_id = mt.media_type_id
AND mm.svr_type_id = :p_server_type_id;

Another critical reporting use case is identifying unused or unmapped media types across the server infrastructure to ensure complete coverage.

Related Objects

The table has documented relationships with other key UWQ objects through its foreign key constraints. The primary relationship is with the media type master table.

  • IEU_UWQ_MEDIA_TYPES_B: This is the main table defining valid media types in the system. The IEU_UWQ_SVR_MPS_MMAPS table references it via the foreign key on the column MEDIA_TYPE_ID. This ensures that only predefined media types can be assigned to a server.

While not explicitly listed in the provided metadata, the SVR_TYPE_ID column would logically reference a server type definition table, which is a common pattern in the IEU schema. The table itself is referenced by the UWQ server runtime components to resolve media-to-server assignments during work item processing.