Search Results wf_message_attributes_uk2

Overview

The WF_MESSAGE_ATTRIBUTES table is a core repository within the Oracle E-Business Suite (EBS) Workflow engine, residing in the APPLSYS schema under the Application Object Library (FND) product. It defines the metadata for attributes associated with workflow notification messages. These attributes are the discrete data elements that can be embedded within a message, allowing for dynamic, personalized content in notifications sent to users. The table's integrity is maintained through a foreign key relationship with the WF_MESSAGES table, ensuring every attribute is linked to a valid parent message definition. Its role is critical for the configuration and runtime operation of the Oracle Workflow notification system in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table structure is designed to uniquely identify and order attributes for a specific message type and name. The primary key (WF_MESSAGE_ATTRIBUTES_PK) is composed of the MESSAGE_TYPE, MESSAGE_NAME, and NAME columns, guaranteeing each attribute name is unique per message. A separate unique key (WF_MESSAGE_ATTRIBUTES_UK2) on MESSAGE_TYPE, MESSAGE_NAME, and SEQUENCE ensures a defined order for attribute display or processing. Key columns include MESSAGE_TYPE and MESSAGE_NAME, which foreign key to WF_MESSAGES, identifying the parent notification. The NAME column stores the internal identifier for the attribute, while SEQUENCE dictates its order. Additional columns, implied by standard practice and the existence of a translated table (WF_MESSAGE_ATTRIBUTES_TL), typically store data type, default values, and other property metadata for each attribute.

Common Use Cases and Queries

This table is primarily accessed during workflow design and troubleshooting. Developers and administrators query it to understand the data structure of a notification or to audit message definitions. A common use case is identifying all attributes for a specific workflow notification to verify available tokens for message body or subject lines. For example, to list attributes for the 'POAPPRV' notification, one might execute:

• SELECT NAME, SEQUENCE FROM APPLSYS.WF_MESSAGE_ATTRIBUTES WHERE MESSAGE_TYPE = 'POAPPRV' ORDER BY SEQUENCE;

Another critical scenario is during upgrade or migration, where customizations to standard message attributes must be inventoried. Queries often join with WF_MESSAGE_ATTRIBUTES_TL to retrieve translated display names for attributes in a user's session language.

Related Objects

The WF_MESSAGE_ATTRIBUTES table is central to a cluster of Workflow metadata tables. Its primary relationship is with WF_MESSAGES, which defines the base notification. Each row in WF_MESSAGE_ATTRIBUTES has a corresponding translated row in WF_MESSAGE_ATTRIBUTES_TL, which holds the user-facing display name for the attribute in various languages. At runtime, the values for these attribute definitions are stored and processed within the workflow engine's runtime tables, such as WF_ITEM_ATTRIBUTE_VALUES. Direct modification of this table is strongly discouraged; instead, the Oracle Workflow Builder tool or appropriate PL/SQL APIs should be used to define and maintain message attributes.