Search Results recipient_role_display_name

Overview

APPS.WF_NOTIFICATION_ATTR_RESP_V is a public Oracle EBS view owned by the APPS schema and shipped as part of the Oracle Workflow design data (FND.WF_NOTIFICATION_ATTR_RESP_V). Its documented status is VALID. The view presents information about workflow notifications that carry responses — that is, notifications requiring an action rather than FYI-style notifications — and that have already been closed. It surfaces the notification attributes together with their human-readable display forms, making it suitable for custom reporting and data extraction where the goal is to analyze completed approval or action cycles and the values users supplied or received.

Because it is delivered as a public view, Oracle documents it as potentially useful for custom reporting or other data requirements. The attribute_display_value column in particular is the searched term of interest: it exposes the notification attribute value after token substitution, so that placeholders in the source message are replaced with resolved values ready for display.

Underlying Base Objects

Per the ETRM metadata, APPS.WF_NOTIFICATION_ATTR_RESP_V is defined over the following documented base objects:

• WF_NOTIFICATIONS (synonym) — the core notification table holding notification definitions and status.
• WF_NOTIFICATION_ATTRIBUTES (synonym) — the attribute rows attached to a notification, holding the raw attribute value.
• WF_MESSAGE_ATTRIBUTES_VL (view) — the message attribute definition view supplying the user-friendly display name.
• WF_DIRECTORY (package) — the directory API used to resolve role display names.
• WF_NOTIFICATION (package) — the Workflow notification API involved in deriving display values.

The view joins notification attributes to the message attribute definitions to resolve ATTRIBUTE_DISPLAY_NAME, and it uses the directory and notification packages to derive RECIPIENT_ROLE_DISPLAY_NAME and the token-substituted ATTRIBUTE_DISPLAY_VALUE.

Key Columns

• GROUP_ID (NUMBER) — grouping of notifications, allowing related notifications to be correlated.
• RECIPIENT_ROLE (VARCHAR2 320) — the role of persons who received the notification.
• RECIPIENT_ROLE_DISPLAY_NAME (VARCHAR2 4000) — the display name resolved for that recipient role.
• ATTRIBUTE_NAME (VARCHAR2 30) — the internal name of the notification attribute.
• ATTRIBUTE_DISPLAY_NAME (VARCHAR2 80) — the user-friendly display name of the attribute.
• ATTRIBUTE_VALUE (VARCHAR2 4000) — the stored attribute value, such as the message text.
• ATTRIBUTE_DISPLAY_VALUE (VARCHAR2 4000) — the attribute value with tokens substituted with values, ready for display. This is the key column for reporting, since it reflects resolved rather than placeholder content.
• MESSAGE_TYPE — the item type of the message.
• MESSAGE_NAME (VARCHAR2 30) — the internal name of the message.

Common Use Cases and Queries

The view is referenced by documented dependent objects, including POS_WCAPPROVE_PVT and PO_APPROVAL_LIST_WF1S, indicating its role in purchasing approval and workflow notification processing. Typical reporting scenarios include extracting the resolved content of closed action notifications, auditing what a recipient saw, and correlating notification groups.

A basic query selecting the display value is:

SELECT GROUP_ID
     , RECIPIENT_ROLE
     , RECIPIENT_ROLE_DISPLAY_NAME
     , ATTRIBUTE_NAME
     , ATTRIBUTE_DISPLAY_NAME
     , ATTRIBUTE_VALUE
     , ATTRIBUTE_DISPLAY_VALUE
     , MESSAGE_TYPE
     , MESSAGE_NAME
  FROM APPS.WF_NOTIFICATION_ATTR_RESP_V;

A filtered query returning only the resolved display values for a given message type is:

SELECT MESSAGE_NAME
     , ATTRIBUTE_DISPLAY_NAME
     , ATTRIBUTE_DISPLAY_VALUE
  FROM APPS.WF_NOTIFICATION_ATTR_RESP_V
 WHERE MESSAGE_TYPE = :p_item_type
   AND ATTRIBUTE_DISPLAY_VALUE IS NOT NULL;

Because the view is restricted to closed notifications with responses, FYI notifications are excluded, and it is most appropriate where historical, action-oriented notification content must be reported.