Results for “media_type_uuid”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IEU_UWQ_MEDIA_TYPES_B table is a base configuration table within the IEU – Universal Work Queue module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2 releases. It defines the media types (such as telephony, e-mail, chat, and web channels) that the Universal Work Queue presents to agents, and it acts as the master reference from which channel routing, blending rules, login rules, and UI plug-ins are derived. The Universal Work Queue is the agent-facing framework that aggregates work items across multiple interaction channels; media types are therefore the top-level classification dimension that drives how work is queued, blended, and dispatched to specific agent responsibilities.

The heuristic Data Vault classification mined from the foreign key structure is hub. This is a modeling suggestion: the surrogate key MEDIA_TYPE_ID is the stable, business-neutral identifier around which multiple dependent structures (a translated/language satellite IEU_UWQ_MEDIA_TYPES_TL, activity and action tables, plug-in mappings, and selection routers) are assembled, consistent with a hub-and-satellite pattern.

Key Information Stored

The table is documented with 19 columns in 12.2.2. The most significant include:

• MEDIA_TYPE_ID — surrogate primary key (constraint IEU_UWQ_MEDIA_TYPES_B_PK), the numeric identifier referenced by all dependent tables.
• MEDIA_TYPE_UUID — a globally unique business identifier used in the unique index IEU_UWQ_MEDIA_TYPES_B_U1 (with ZD_EDITION_NAME).
• APPLICATION_ID — foreign key to FND_APPLICATION, indicating the owning application/product for the media type.
• SVR_LOGIN_RULE_ID — foreign key to IEU_UWQ_LOGIN_RULES_B, binding the media type to a server login rule that controls agent eligibility.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, governing multi-org/security-group access.
• TEL_REQD_FLAG — flags whether a telephone interaction is required for this media type.
• BLENDED_FLAG, BLENDED_DIR, SIMPLE_BLENDING_ORDER — control media blending behavior and the sequencing/direction of blended work distribution.
• SH_CATEGORY_TYPE — category type used in Service/support (Service Request) categorization.
• IMAGE_FILE_NAME — image/icon file associated with the media type in the agent UI.
• CLASSIFICATION_QUERY_PROC — stored procedure used to classify or route work items of this media type.
• OBJECT_VERSION_NUMBER — optimistic locking column for concurrent updates.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The unique indexes IEU_UWQ_MEDIA_TYPES_B_U1 (MEDIA_TYPE_UUID, ZD_EDITION_NAME) and IEU_UWQ_MEDIA_TYPES_B_U2 (MEDIA_TYPE_ID, ZD_EDITION_NAME) identify business-key candidates. ZD_EDITION_NAME reflects the editioning infrastructure used in 12.2.x.

Common Use Cases and Queries

Typical scenarios include listing active media types for configuration review, verifying agent login eligibility, and auditing blending configuration.

• Enumerate all media types with their owning application:

  SELECT m.media_type_id, m.media_type_uuid, a.application_name
  FROM ieu.ieu_uwq_media_types_b m
  JOIN fnd_application a ON a.application_id = m.application_id
  ORDER BY m.media_type_id;

• Locate media types tied to a specific login rule:

  SELECT * FROM ieu.ieu_uwq_media_types_b WHERE svr_login_rule_id = :rule_id;

• Retrieve display name (translated) for a media type by joining the TL table on MEDIA_TYPE_ID.
• Report on blended configuration: filter by BLENDED_FLAG and order by SIMPLE_BLENDING_ORDER.
• Find media types requiring telephony (TEL_REQD_FLAG) to reconcile against telephony channel setup.

Reporting use cases include media type usage audits, agent skill/login-rule coverage matrices, and channel blending analysis in contact-centre deployments.

Related Objects

The following objects are the most significant dependents and parents declared in the FK structure:

• IEU_UWQ_MEDIA_TYPES_TL — translated/language-dependent attributes, joined on MEDIA_TYPE_ID.
• IEU_UWQ_MEDIA_ACTIONS — actions available per media type, joined on MEDIA_TYPE_ID.
• IEU_UWQ_CLI_MED_PLUGINS — client media plug-in mappings for the media type.
• IEU_UWQ_SEL_RT_NODES and IEU_UWQ_SEL_ENUMERATORS — selection routing nodes and enumerators keyed by MEDIA_TYPE_ID.
• IEU_UWQ_SVR_MPS_MMAPS — server multi-plugin/no-map relationships.
• IEU_SH_ACTIVITIES — Service/activity records referencing the media type.
• CS_SR_UWQ_NODES_B — Service Request UWQ node configuration referencing MEDIA_TYPE_ID.
• Parent references: FND_APPLICATION (via APPLICATION_ID), IEU_UWQ_LOGIN_RULES_B (via SVR_LOGIN_RULE_ID), and FND_SECURITY_GROUPS (via SECURITY_GROUP_ID).