Search Results ieu_uwq_media_types_b

Overview

The IEU_UWQ_MEDIA_TYPES_B table is a core base table within the Oracle E-Business Suite (EBS) Universal Work Queue (UWQ) module. It functions as the master repository for defining and managing different communication media types that can be processed and routed through the UWQ framework. As a base table, it stores the primary, non-translatable attributes for each media type. Its existence is critical for the configuration of the UWQ's intelligent routing, agent desktop presentation, and work item processing logic across versions 12.1.1 and 12.2.2. The table's integrity is enforced by a primary key and it serves as a central reference point for numerous other UWQ configuration and transactional entities.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure and foreign key relationships indicate the table holds essential configuration columns. The primary key column, MEDIA_TYPE_ID, uniquely identifies each media type record (e.g., Email, Phone Call, Fax, Web Chat). Another critical column is APPLICATION_ID, which links the media type to its owning Oracle EBS application via the FND_APPLICATION table, ensuring proper module integration. The column SVR_LOGIN_RULE_ID is used to associate a media type with specific server login rules defined in the IEU_UWQ_LOGIN_RULES_B table, controlling agent availability and assignment logic. Other likely columns include codes, internal names, status flags, and sequencing information for the media type.

Common Use Cases and Queries

This table is primarily accessed for configuration, reporting, and troubleshooting within UWQ implementations. Common scenarios include generating a list of all active media types configured in the system, identifying which media types are associated with a specific application, or diagnosing routing issues by verifying media type definitions. A typical administrative query would join the base table with its corresponding translation table (IEU_UWQ_MEDIA_TYPES_TL) to retrieve user-friendly names.

• Sample Query: List all media types with their application:
  SELECT b.MEDIA_TYPE_ID, t.NAME, a.APPLICATION_NAME
FROM IEU.IEU_UWQ_MEDIA_TYPES_B b,
    IEU.IEU_UWQ_MEDIA_TYPES_TL t,
    APPLSYS.FND_APPLICATION_VL a
WHERE b.MEDIA_TYPE_ID = t.MEDIA_TYPE_ID
AND b.APPLICATION_ID = a.APPLICATION_ID
AND t.LANGUAGE = USERENV('LANG');

Related Objects

The IEU_UWQ_MEDIA_TYPES_B table has extensive relationships within the UWQ schema, as documented by its foreign keys. It is a parent table to several key configuration and data tables:

• IEU_UWQ_MEDIA_TYPES_TL: Translation table for multilingual media type names (joined on MEDIA_TYPE_ID).
• IEU_SH_ACTIVITIES: Stores activity history, referencing the media type involved.
• IEU_UWQ_CLI_MED_PLUGINS & IEU_UWQ_SVR_MPS_MMAPS: Reference media types for client-side and server-side media processing plugins and mappings.
• IEU_UWQ_MEDIA_ACTIONS & IEU_UWQ_SEL_RT_NODES: Configuration tables for actions and selection rules tied to specific media types.
• IEU_UWQ_LOGIN_RULES_B & FND_APPLICATION: Parent tables referenced via SVR_LOGIN_RULE_ID and APPLICATION_ID, respectively.