Search Results user_param1

Overview

The IEU_UWQ_ACQ_EMAIL_V view is a component of the Oracle E-Business Suite Universal Work Queue (IEU) module, which provides a centralized, agent-facing work environment for multi-channel interaction handling. This view is specifically designed to support the UWQ selector SpreadTable, a UI construct that renders tabular data in a spread-sheet-like grid within the Universal Work Queue agent dashboard. In the context of Oracle EBS 12.1.1 and 12.2.2, the view surfaces email message headers — including sender, recipient, subject, priority, score, and mailbox folder information — as a unified result set that the UWQ framework can consume for selector processing and agent presentation.

Rather than functioning as a persistent reporting view, IEU_UWQ_ACQ_EMAIL_V acts as a runtime integration view that invokes the acquisition function IEU_ACQ_EMAIL_FUNC_PVT.GET_EMAIL_HEADERS to retrieve email headers dynamically from the underlying email connector. This makes it a critical bridge between the IEU UWQ selector metadata and the Email Center message store.

Underlying Base Objects

The view's FROM clause references several documented IEU base objects. The driving table is IEU_UWQ_SEL_MRT_DATA (aliased A), which holds selector metadata resource rows. It joins to IEU_UWQ_MEDIA_TYPES_B (B) and its translation table IEU_UWQ_MEDIA_TYPES_TL (C) to resolve the media type UUID and localized media type name. The email-specific data is produced by a pipelined table function: IEU_ACQ_EMAIL_FUNC_PVT.GET_EMAIL_HEADERS(A.RESOURCE_ID,'ALL',0,0), cast as IEU_UWQ_MSG_HEADER_TABLE (aliased D).

The WHERE clause restricts the result set to a single media type UUID (D2325ED0421D11D484CD00C04F53F265), matches the base media type ID across B and C, filters C.LANGUAGE to USERENV('LANG') for locale-appropriate names, restricts A.MEDIA_TYPE_ID to 10001 (email), and excludes invalid selectors via NVL(A.NOT_VALID,'N') = 'N'. No additional referenced base objects are documented in the ETRM metadata.

Key Columns

• RESOURCE_ID — Identifier of the UWQ selector resource that owns the email header row.
• IEU_MEDIA_TYPE_UUID / QUEUE_TYPE — Media type UUID and its localized media type name (email channel).
• IEU_PARAM_PK_COL / IEU_PARAM_PK_VALUE — Primary key column name ('SMTP_MSG_ID') and value (D.SMTP_MSG_ID) used by UWQ to identify the underlying message.
• RESOURCE_TYPE — Fixed value 'RS_INDIVIDUAL', indicating an individual resource assignment.
• QUEUE_NAME / QUEUE_COUNT — Derived from D.CLASSIFICATION with a literal count of 1.
• MSG_ID, SENDER_NAME, RECEIVED_DATE, FROM_FIELD, TO_FIELD, PRIORITY, REPLY_TO, SUBJECT, SCORE — Core email header attributes retrieved from the pipelined function output.
• FOLDER_PATH — Full mailbox folder path of the message.
• FOLDER_NAME — The trailing segment of FOLDER_PATH, extracted with SUBSTR(D.FOLDER_PATH, INSTR(D.FOLDER_PATH, '/', -1)+1). This column corresponds to email folder filtering and is the field referenced in UWQ selector folder-based queries.
• USER_PARAM1 / USER_PARAM2 — Generic placeholder parameters carried from the message header structure.
• IEU_OBJECT_FUNCTION / IEU_OBJECT_PARAMETERS — Present as empty string literals, reserved for UWQ object navigation.

Common Use Cases and Queries

Typical use cases include configuring UWQ email selectors that filter or group messages by mailbox folder, validating that email acquisition is returning folder metadata, and troubleshooting selector SpreadTable rendering. A representative query:

• SELECT RESOURCE_ID, SUBJECT, SENDER_NAME, RECEIVED_DATE, FOLDER_NAME FROM IEU_UWQ_ACQ_EMAIL_V WHERE FOLDER_NAME = 'Inbox';
• SELECT QUEUE_NAME, COUNT(*) FROM IEU_UWQ_ACQ_EMAIL_V GROUP BY QUEUE_NAME;
• SELECT RESOURCE_ID, FOLDER_PATH, FOLDER_NAME, PRIORITY FROM IEU_UWQ_ACQ_EMAIL_V ORDER BY RECEIVED_DATE DESC;

Because the view depends on the pipelined acquisition function, queries may be resource-intensive and should be bounded by RESOURCE_ID or folder predicates. Access is typically restricted to IEU/UWQ functional administrators rather than general reporting users.