Search Results ieu_uwq_sel_mrt_data_u1

Overview

IEU.IEU_UWQ_SEL_MRT_DATA is a transaction-data table in the Oracle E-Business Suite Interaction Center (IEU) schema. It stores media run-time data for unified work queue (UWQ) selection, capturing the runtime state of queues presented to agents through the Universal Work Queue and multi-channel routing framework. Each row associates a JTF resource (an agent, group, or queue-holding entity) with a server type, a media type, and a named queue, together with a running queue count. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are housed in APPS_TS_TX_IDX.

Per the heuristic Data Vault classification mined from its foreign-key structure, this table is modeled as a standalone structure — it acts neither as a pure hub, link, nor satellite, since it carries descriptive runtime attributes alongside its own surrogate key without participating in an interconnected hub-and-link web. In practice it behaves as a lightweight reference/state table for media queue runtime information rather than a core master or transactional entity.

Oracle marks this object as Internal Use Only. Direct access to application data through this table is unsupported except from standard Oracle Applications programs.

Key Information Stored

The table comprises 11 documented columns. The most significant are:

• SEL_MRT_ID (NUMBER, 15) — the surrogate primary key (IEU_UWQ_SEL_MRT_DATA_PK) that uniquely identifies each media run-time data row. It is also the business-key candidate surfaced through the unique index IEU_UWQ_SEL_MRT_DATA_U1.
• RESOURCE_ID (NUMBER, 15) — the JTF resource ID that the queue represents; the principal join column to resource-related objects.
• SVR_TYPE_ID (NUMBER, 15) — the server to which the queue belongs, used to scope runtime data by server type.
• MEDIA_TYPE_ID (NUMBER, 15) — the media type the queue represents; a foreign key to IEU.IEU_UWQ_MEDIA_TYPES_B.
• QUEUE_NAME (VARCHAR2, 500) — the queue name.
• QUEUE_COUNT (NUMBER, 10) — the current count for the queue, the primary runtime metric.
• LAST_UPDATE_DATE (DATE) — timestamp of the last update to the row.
• PROVIDER_REF (VARCHAR2, 32) — a provider-specific reference value.
• NOT_VALID (VARCHAR2) — flag indicating whether the row is valid.
• SECURITY_GROUP_ID (NUMBER) — used in hosted environments; foreign key to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER (NUMBER) — standard column used by HTML utilities for optimistic locking.

The non-unique index IEU_UWQ_SEL_MRT_DATA_N1 covers RESOURCE_ID, SVR_TYPE_ID, MEDIA_TYPE_ID, QUEUE_NAME, and QUEUE_COUNT, supporting the primary access path by queue context.

Common Use Cases and Queries

Typical uses involve reporting current queue depths by resource, media, and server type, and diagnosing routing or load-balancing behaviour in the Universal Work Queue. A representative query retrieves the live queue count for a given resource:

• SELECT SEL_MRT_ID, RESOURCE_ID, QUEUE_NAME, QUEUE_COUNT, LAST_UPDATE_DATE FROM IEU.IEU_UWQ_SEL_MRT_DATA WHERE RESOURCE_ID = :resource_id AND NOT_VALID = 'N' ORDER BY QUEUE_NAME;
• SELECT MEDIA_TYPE_ID, QUEUE_NAME, SUM(QUEUE_COUNT) FROM IEU.IEU_UWQ_SEL_MRT_DATA GROUP BY MEDIA_TYPE_ID, QUEUE_NAME;

Because the table is flagged Internal Use Only, such queries should be confined to supported reporting views or standard Oracle Applications programs rather than custom integrations.

Related Objects

• IEU.IEU_UWQ_MEDIA_TYPES_B — referenced via MEDIA_TYPE_ID, providing the media type definition for each queue.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID in hosted environments.
• IEU.IEU_UWQ_SEL_MRT_DATA# — the internal dependent object referenced by this table per the dependency list.
• JTF resource objects — RESOURCE_ID joins to the JTF resource model used across the Interaction Center.

These relationships confirm the table's role as a media-runtime state store anchored to resources, media types, and security groups within the IEU schema.