Search Results wf_message_attributes_tl




Overview
Explore in AI Chat

Overview

The WF_MESSAGE_ATTRIBUTES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Application Object Library (FND) module. It is owned by the APPLSYS schema and is integral to the Oracle Workflow technology stack. As indicated by its name and the '_TL' suffix, its primary function is to store translated, language-specific versions of the data held in its base table, WF_MESSAGE_ATTRIBUTES. This table enables the multilingual display of workflow message attribute names and display names, allowing Oracle EBS workflows to present user-facing text in the language of the session user, a critical requirement for global deployments of versions 12.1.1 and 12.2.2.

Key Information Stored

The table stores translated text for workflow message attributes, keyed by a unique combination of identifiers and language. The primary columns, as defined by its primary keys, are MESSAGE_TYPE, MESSAGE_NAME, NAME, and LANGUAGE. The NAME column corresponds to the internal attribute name from the base table. A second unique key also includes the DISPLAY_NAME column, which holds the user-facing, translated label for the attribute. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean) for each translation row. Other typical columns in a '_TL' table, such as SOURCE_LANG, DESCRIPTION, and LAST_UPDATE_DATE, are also present to manage translation sourcing and maintenance, though not explicitly listed in the provided metadata.

Common Use Cases and Queries

This table is primarily accessed indirectly by the Oracle Workflow engine during runtime to fetch locale-specific text. Direct queries are common for administrative reporting, translation audits, and troubleshooting. A typical use case is verifying or extracting translations for a specific workflow message across all installed languages. A sample query pattern is:

  • SELECT language, display_name, description FROM apps.wf_message_attributes_tl WHERE message_type = '<TYPE>' AND message_name = '<NAME>' AND name = '<ATTR_NAME>';

Another common scenario involves identifying missing translations by joining the base table with the translation table and filtering for a specific language where the translated DISPLAY_NAME is null. Administrators may also query this table to understand the full set of translatable attributes associated with a particular workflow message.

Related Objects

The WF_MESSAGE_ATTRIBUTES_TL table has a direct, foundational relationship with its parent table, WF_MESSAGE_ATTRIBUTES, as enforced by a foreign key constraint. The base table defines the core attribute definitions, while the TL table holds their translations. It is intrinsically linked to the broader Oracle Workflow message and notification infrastructure. Related objects include WF_MESSAGES_TL (for message body translations) and WF_NOTIFICATIONS. The table is typically accessed via the standard Oracle Applications "apps" synonym (APPS.WF_MESSAGE_ATTRIBUTES_TL). Any custom or standard reports displaying workflow attribute names in the user's language will ultimately rely on data from this table.