Search Results ieu_uwq_sel_mrt_data_pk

Overview

IEU_UWQ_SEL_MRT_DATA is a table in the IEU (Universal Work Queue) product module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented purpose is to hold data used for the selector view within Universal Work Queue. In practice, the table stores the derived membership and aggregate metrics that drive the UWQ selector, allowing the work queue to present filtered, resource-aware lists of work items across media types without recalculating membership on every user interaction. The table therefore functions as a materialized staging layer between the underlying transactional work sources and the selector UI presented to agents.

The supplied metadata describes the object as a standalone data vault classification (heuristic, mined from FK structure). Under that modeling suggestion, the table behaves closest to a satellite: it is keyed by a single surrogate identifier (SEL_MRT_ID) and carries descriptive and metric attributes tied to that key, rather than acting as a hub of distinct business entities or a link resolving many-to-many relationships. This classification is a heuristic derived from the foreign-key structure and should be treated as a modeling recommendation rather than a binding constraint.

Key Information Stored

The documented physical schema for 12.2.2 contains 11 columns owned by IEU. The most significant are:

• SEL_MRT_ID — the surrogate primary key, enforced by the unique index IEU_UWQ_SEL_MRT_DATA_U1 and the constraint IEU_UWQ_SEL_MRT_DATA_PK. This is both the primary key and the only documented business-key candidate.
• RESOURCE_ID — identifies the resource (typically an agent or resource group) to which the selector row applies.
• SVR_TYPE_ID — identifies the server or source type from which the queued work originates.
• MEDIA_TYPE_ID — foreign key to IEU_UWQ_MEDIA_TYPES_B, indicating the media channel (for example, an interaction or work item type) associated with the row.
• QUEUE_NAME — the name of the queue as presented in the selector.
• QUEUE_COUNT — the aggregate count of items currently in that queue for the given resource and media combination. This is the principal metric consumed by the selector view.
• PROVIDER_REF — a reference value pointing to the provider that supplies the queue data.
• NOT_VALID — a flag indicating whether the row is no longer valid or should be excluded from selection.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/multi-security-group isolation.
• LAST_UPDATE_DATE — timestamp of the most recent modification, used for refresh and staleness detection.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications Framework layer.

Note that only SEL_MRT_ID is documented as a unique index column; the remaining attributes are descriptive or foreign-key references without a documented unique constraint.

Common Use Cases and Queries

The primary use case is rendering the Universal Work Queue selector, which lists available queues and their item counts per resource and media type. A typical reporting query filters out invalid rows and joins to the media type definition:

• Selecting active queue counts for a resource: SELECT QUEUE_NAME, QUEUE_COUNT FROM IEU.IEU_UWQ_SEL_MRT_DATA WHERE RESOURCE_ID = :resource_id AND NVL(NOT_VALID,'N') = 'N' ORDER BY QUEUE_NAME;
• Joining to media types to resolve channel descriptions: SELECT d.QUEUE_NAME, m.MEDIA_TYPE_NAME, d.QUEUE_COUNT FROM IEU.IEU_UWQ_SEL_MRT_DATA d, IEU.IEU_UWQ_MEDIA_TYPES_B m WHERE d.MEDIA_TYPE_ID = m.MEDIA_TYPE_ID AND d.SECURITY_GROUP_ID = :org_id;
• Detecting stale selector data: SELECT SEL_MRT_ID, LAST_UPDATE_DATE FROM IEU.IEU_UWQ_SEL_MRT_DATA WHERE LAST_UPDATE_DATE < SYSDATE - 1;

These patterns are commonly used in operational dashboards monitoring queue backlog, in troubleshooting reports confirming why a queue appears or disappears from an agent's selector, and in purge scripts that remove invalid rows.

Related Objects

• IEU_UWQ_MEDIA_TYPES_B — referenced via MEDIA_TYPE_ID; supplies the media type definition for each selector row.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; enforces security-group isolation.
• IEU_UWQ_SEL_MRT_DATA_PK — the primary key constraint on SEL_MRT_ID.
• IEU_UWQ_SEL_MRT_DATA_U1 — the unique index on SEL_MRT_ID.
• UWQ selector views and concurrent programs that populate and refresh this table, which read queue counts from provider sources and write the summarized rows consumed by the selector UI.