Results for “media_type_map”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IEU_UWQ_SVR_MPS_MMAPS table resides in the IEU schema and belongs to the Universal Work Queue (UWQ) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The table name expands to "UWQ Server (Media Provider) Media Maps," indicating its function as the mapping layer between media provider types and server types within the UWQ infrastructure. Media providers in UWQ encompass telephony, e-mail, chat, and other contact-channel integrations, and this table determines which media server handles each media type for routing and interaction processing.
The table is registered as VALID in the ETRM object inventory. Its documented physical schema carries twelve columns, a surrogate primary key, and two unique constraints. From a Data Vault modeling perspective, the ETRM heuristic classification is satellite-leaning: the table's business identity (MEDIA_TYPE_ID and SVR_TYPE_ID) is captured in a unique index, and most other attributes are descriptive or transactional in nature, suggesting it would map naturally to a satellite on a media-type/server-type link rather than an independent hub.
Key Information Stored
The documented columns of primary interest are:
- SVR_MPS_MMAP_ID — the system-generated surrogate primary key, enforced by
IEU_UWQ_SVR_MPS_MMAPS_PK. - MEDIA_TYPE_ID — the media type being mapped; a foreign key to
IEU_UWQ_MEDIA_TYPES_B. - SVR_TYPE_ID — the server technology or provider type assigned to handle the media type.
- MEDIA_TYPE_MAP — the mapping value or configuration payload that defines how the media type resolves to the server type.
- SECURITY_GROUP_ID — the multi-org/security grouping that scopes visibility of the row; foreign key to
FND_SECURITY_GROUPS. - CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit WHO columns maintained automatically by EBS DML logic.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the ORM layer for concurrent update control.
- ZD_EDITION_NAME — the editioning column supporting online patching (Edition-Based Redefinition), included in both unique indexes.
The business-key candidates are IEU_UWQ_SVR_MPS_MMAPS_UK1 (MEDIA_TYPE_ID, SVR_TYPE_ID), which the user searched for under the alias "ieu_uwq_svr_mps_mmaps_uk1," and the alternate unique index U1 (MEDIA_TYPE_ID, SVR_TYPE_ID, ZD_EDITION_NAME). The foreign key to IEU_UWQ_MEDIA_TYPES_B establishes the core dependency chain.
Common Use Cases and Queries
Typical usage involves resolving which server type is configured for a given media type, and validating that no duplicate mappings exist. A representative query joins the mapping table to the media types base table:
SELECT m.SVR_MPS_MMAP_ID, mt.MEDIA_TYPE_NAME,
m.SVR_TYPE_ID, m.MEDIA_TYPE_MAP
FROM IEU.IEU_UWQ_SVR_MPS_MMAPS m,
IEU.IEU_UWQ_MEDIA_TYPES_B mt
WHERE m.MEDIA_TYPE_ID = mt.MEDIA_TYPE_ID
AND m.SECURITY_GROUP_ID = :p_security_group;
Reporting scenarios include auditing media-provider configuration before go-live, diagnosing routing failures when an interaction arrives on an unmapped channel, and verifying that edition-aware lookups reference the correct ZD_EDITION_NAME. A duplicate-detection query against the UK1 columns is often run during setup validation.
Related Objects
The most significant related objects are the foreign-key targets and the indexes that enforce integrity:
- IEU_UWQ_MEDIA_TYPES_B — parent table linked via MEDIA_TYPE_ID; the primary join partner.
- FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security scoping.
- IEU_UWQ_SVR_MPS_MMAPS_PK — primary key index on SVR_MPS_MMAP_ID.
- IEU_UWQ_SVR_MPS_MMAPS_UK1 / U1 — unique business-key indexes on MEDIA_TYPE_ID and SVR_TYPE_ID.
- IEU_UWQ_SVR_MPS_MMAPS_U2 — alternate unique index on SVR_MPS_MMAP_ID with ZD_EDITION_NAME.
Readers should treat editions-aware access patterns as mandatory in 12.2.2 environments, since both unique indexes include ZD_EDITION_NAME.
-
UWQ Server (Media Provider) Media Maps
-
UWQ Server (Media Provider) Media Maps
-
eTRM - IEU Tables and Views 12.1.1
UI Component-Data Types mapping
-
eTRM - IEU Tables and Views 12.2.2
UI Component-Data Types mapping