Search Results coverage_name

Overview

IEU_UWQ_SERV_REQ_V is a reporting and integration view belonging to the IEU (Universal Work Queue) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to support the UWQ selector SpreadTable, the tabular presentation layer of the Universal Work Queue that agent-facing users interact with when picking, opening, and routing work items. In practical terms, the view exposes service request (service incident) records in a shape that the UWQ selector expects, so that a queue of service requests can be rendered as a spread table and pushed into the correct application context when an agent selects a row.

The ETRM record lists the object as "Not implemented in this database," which indicates the view exists in the EBS data dictionary definitions but was not deployed in the particular environment sampled. The view definition itself is fully documented and remains the authoritative reference for its structure.

Underlying Base Objects

The view is defined over two sources joined in a single SELECT statement:

• CS_SR_UWQ_V A — the Service (CS) module's UWQ-oriented service request view, which supplies the incident-level attributes such as number, severity, status, summary, owner, resource, and coverage information.
• JTF_OBJECTS_VL O — the CRM Foundation (JTF) objects view, filtered to O.OBJECT_CODE = 'SR', supplying the object function, object parameters, and object metadata used to launch the correct entity from the queue.

The join is not a keyed correlation between the two sources; it is effectively a cross join constrained by the constant object code filter, so that every service request row is decorated with the single 'SR' object definition. No additional base tables are documented beyond these two views.

Key Columns

The view exposes a mix of UWQ navigation columns and service-request attributes:

• IEU_OBJECT_FUNCTION — sourced from JTF_OBJECTS_VL; identifies the function used to open the object from the queue.
• IEU_OBJECT_PARAMETERS — parameters passed when launching the object.
• IEU_MEDIA_TYPE_UUID — returned as an empty string literal in the definition.
• IEU_PARAM_PK_COL — a literal 'INCIDENT_ID', declaring the primary key column name used by the queue.
• IEU_PARAM_PK_VALUE — the character representation of INCIDENT_ID, matching the declared primary key column.
• INCIDENT_NUMBER, SUMMARY, SEVERITY, SERVERITY, STATUS — core descriptive and classification attributes of the service request; note that SERVERITY is a separate column from SEVERITY, reflecting the legacy/distributed field on the source view.
• PERSON_ORG, OWNER, RESOURCE_ID, RESOURCE_TYPE — ownership and assignment attributes used for filtering and routing within a queue.
• SR_TYPE, ESCALATED, COVERAGE_NAME, COVERAGE_LEVEL — service request typing and entitlement context.
• INCIDENT_SEVERITY_ID, INCIDENT_STATUS_ID, INCIDENT_TYPE_ID — the numeric identifiers corresponding to the descriptive severity, status, and type columns.

Common Use Cases and Queries

The view is typically consumed by UWQ selector configuration and by diagnostics that verify what an agent will see in a service-request queue. Because it is a read-only projection, it is safe for ad hoc inquiry and for integration extracts.

• Listing open, escalated service requests for a queue selector: SELECT INCIDENT_NUMBER, STATUS, SEVERITY, OWNER FROM IEU_UWQ_SERV_REQ_V WHERE ESCALATED = 'Y';
• Confirming the primary key and launch metadata handed to the queue: SELECT INCIDENT_NUMBER, IEU_OBJECT_FUNCTION, IEU_PARAM_PK_COL, IEU_PARAM_PK_VALUE FROM IEU_UWQ_SERV_REQ_V;
• Extracting workload by resource: SELECT RESOURCE_ID, RESOURCE_TYPE, COUNT(*) FROM IEU_UWQ_SERV_REQ_V GROUP BY RESOURCE_ID, RESOURCE_TYPE;
• Reviewing entitlement context: SELECT INCIDENT_NUMBER, COVERAGE_NAME, COVERAGE_LEVEL, SR_TYPE FROM IEU_UWQ_SERV_REQ_V;

Where the subject relates to UWQ selector (URF) configuration, this view is the data source that determines which columns and rows populate the spread table presented to the agent.