Results for “ieu_uwq_mywork_v”

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

Overview

The view IEU_UWQ_MYWORK_V belongs to the IEU (Universal Work Queue) product family within Oracle E-Business Suite, and is documented in ETRM for both the 12.1.1 and 12.2.2 release streams. Its stated purpose is to serve as the data source for the UWQ selector SpreadTable, meaning it supplies the row structure that the Universal Work Queue user interface consumes when rendering "My Work" style workload grids to agents and end users.

In the UWQ architecture, a selector is a configured definition that determines which work items a user or resource group should see, how those items are grouped, prioritised, and ordered, and which columns are displayed. The SpreadTable mechanism renders these items in a tabular layout. The view provides the column contract — a fixed set of named columns with expected data types — that the SpreadTable runtime expects, independent of which concrete work source populates it.

Underlying Base Objects

ETRM explicitly records that this view is not implemented in the reference database, and that no base objects are documented as referenced by it. This is consistent with the supplied view text, which contains no table joins at all:

• The SELECT list projects literal constants onto every column.
• The FROM clause is DUAL, Oracle's single-row dummy table.
• All character columns are assigned the literal string 'INVALID'.
• Numeric columns (IEU_DISPLAY_ORDER, RESOURCE_ID, WORK_COUNT) are set to 0.
• DUE_DATE is set to SYSDATE.

This structure indicates the view functions as a placeholder or template definition. It defines column names, positions, and data types for the UWQ selector framework, but deliberately carries no operational data. In an implemented environment, the "INVALID" literals would typically be replaced by a real selector query that UNIONs or joins the appropriate work-source views, using IEU_PARAM_PK_COL and IEU_PARAM_PK_VALUE to resolve the underlying primary key.

Key Columns

• IEU_OBJECT_FUNCTION — Identifies the function or handler responsible for opening or acting on the work item.
• IEU_OBJECT_PARAMETERS — Parameters passed to the object function when the item is launched.
• IEU_MEDIA_TYPE_UUID — Identifies the media type or rendering context for the item.
• IEU_PARAM_PK_COL / IEU_PARAM_PK_VALUE — The primary key column name and value used to resolve the base record behind each queue row.
• IEU_APPS_BASE_VIEW — The base application view supplying the row, relevant when selectors are built over other views.
• IEU_DISPLAY_ORDER — Numeric ordering value controlling presentation sequence in the SpreadTable.
• RESOURCE_ID / RESOURCE_TYPE — The resource (agent, group, or queue) and its category to which the work is assigned.
• WORK_CLASS / WORK_TYPE — Classifies the work item; WORK_TYPE is the specific category used by selector filters and is the term most commonly searched by implementers configuring UWQ selectors.
• DUE_DATE — The date by which the item should be completed, used for ageing and prioritisation.
• PRIORITY — Priority indicator for sorting and escalation.
• DESCRIPTION — Free-text summary of the work item.
• WORK_COUNT — Count of work items represented by the row, supporting aggregated displays.

Common Use Cases and Queries

The view is queried by the UWQ SpreadTable selector at runtime, and by developers and analysts who need to understand the expected column contract when building or extending selectors. A representative query is:

• SELECT work_type, work_class, priority, due_date, work_count FROM ieu_uwq_mywork_v WHERE resource_id = :resource_id ORDER BY ieu_display_order, due_date;
• SELECT object_function, object_parameters, param_pk_col, param_pk_value FROM ieu_uwq_mywork_v; — used to confirm launch metadata.
• SELECT COUNT(*) FROM ieu_uwq_mywork_v; — returns a single row in the delivered state, confirming the placeholder nature.

Because the delivered definition returns only one synthetic row, the view is not useful for production reporting as shipped. Its practical value lies in documenting the UWQ selector column interface, enabling custom selectors and SpreadTable configurations to be validated against a known, stable contract.