Results for “wf_notification_attributes”

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

Overview

WF_NOTIFICATION_ATTRIBUTES is a table in the APPLSYS schema that stores the individual attribute values associated with Oracle Workflow notifications. Each row represents a single name-value pair belonging to a notification created when a workflow message is sent. Because Oracle Workflow messages are constructed from message attributes defined in the Workflow Builder, this table captures the runtime values bound to those attribute names at the moment the notification is generated. The table is owned by APPLSYS and falls under the FND — Application Object Library product grouping, and is present in both Oracle EBS 12.1.1 and 12.2.2 with the documented structure of seven columns.

From a dimensional modeling perspective, the metadata suggests a satellite-leaning classification. The table is keyed by a composite of NOTIFICATION_ID and NAME, with NOTIFICATION_ID being a foreign key to the parent notification. This structure is characteristic of a satellite table hanging off a notification hub, capturing descriptive attribute detail rather than defining a new business entity or resolving a many-to-many relationship. Consumers building analytical models over Workflow data may find it useful to treat WF_NOTIFICATION_ATTRIBUTES as a dependent satellite attached to WF_NOTIFICATIONS.

Key Information Stored

The documented physical schema contains seven columns. The most significant are described below.

• NOTIFICATION_ID — Foreign key to WF_NOTIFICATIONS, identifying the parent notification to which the attribute belongs. Part of the composite primary key.
• NAME — The attribute name as defined in the Workflow message definition. Part of the composite primary key and the primary business-key discriminator within a notification.
• TEXT_VALUE — The character representation of the attribute value, used for string-typed message attributes.
• NUMBER_VALUE — The numeric representation of the attribute value, used for numeric message attributes.
• DATE_VALUE — The date representation of the attribute value, used for date-typed message attributes.
• EVENT_VALUE — The event representation of the attribute value, used where the attribute carries an event reference.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting the security group context under which the notification attribute was created.

The primary key is WF_NOTIFICATIONS_ATTR_PK, defined over (NOTIFICATION_ID, NAME). The unique index list also includes SYS_IL0000035297C00011$$ and SYS_IL0000035297C00014$$, which are system-generated indexes supporting the LOB or large-value storage behind the value columns rather than additional business keys. The true business-key candidate is therefore the composite of NOTIFICATION_ID and NAME.

Common Use Cases and Queries

Typical use cases include auditing the content of sent notifications, reconstructing the payload delivered to recipients, and reporting on workflow variables captured at notification time. Because values are spread across TEXT_VALUE, NUMBER_VALUE, DATE_VALUE, and EVENT_VALUE, queries must account for the relevant typed column. WHERE clauses should always constrain NOTIFICATION_ID to avoid full scans on a large transactional table.

A representative query retrieves all attributes for a specific notification:

• SELECT n.notification_id, n.name, n.text_value, n.number_value FROM wf_notification_attributes n WHERE n.notification_id = :p_notification_id ORDER BY n.name;

Joining to WF_NOTIFICATIONS allows reporting across notifications, for example filtering by recipient or status. Security-conscious reporting may additionally join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID.

Related Objects

The most significant related objects, based on the documented foreign key relationships and the surrounding Workflow schema, are:

• WF_NOTIFICATIONS — Parent table; joined on WF_NOTIFICATION_ATTRIBUTES.NOTIFICATION_ID = WF_NOTIFICATIONS.NOTIFICATION_ID.
• FND_SECURITY_GROUPS — Joined on WF_NOTIFICATION_ATTRIBUTES.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.
• WF_NOTIFICATION_ATTR_VALUES — Related storage for attribute values within the Workflow schema.
• WF_MESSAGES — Defines the message attributes referenced by NAME.
• WF_MESSAGE_ATTRIBUTES — Defines the attribute definitions that NAME values correspond to.
• WF_ITEM_ATTRIBUTES — Holds related workflow item attribute values.
• WF_ROLES and WF_USERS — Recipient and performer context referenced indirectly through notifications.

These objects collectively provide the join paths needed to correlate notification attributes with the messages, items, and recipients that define their workflow context.