Results for “wf_message_attributes_tl”

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

Overview

WF_MESSAGE_ATTRIBUTES_TL is the translation (language) table for the Oracle Workflow message attribute repository in Oracle E-Business Suite. It is owned by the APPLSYS schema and belongs to the FND - Application Object Library product family. Its documented purpose is to store translations for WF_MESSAGE_ATTRIBUTES, meaning that while the base table holds the functional definition of each message attribute, this table stores the language-dependent, display-facing text such as display names and descriptions. The table exists in both 12.1.1 and 12.2.2, with the 12.2.2 physical schema documented as having eleven columns.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is described as satellite-leaning. As a modeling suggestion, this means WF_MESSAGE_ATTRIBUTES_TL behaves primarily as a descriptive satellite attached to the WF_MESSAGE_ATTRIBUTES hub and its attribute-level business key, carrying context and translation attributes rather than defining new core entities. The translation table depends on the parent attribute definition; it does not exist independently of it.

Key Information Stored

The columns of this table store the identifying keys of the message attribute together with its translated content. The most significant columns documented are:

• MESSAGE_TYPE — the workflow message type that owns the message; part of the parent relationship to WF_MESSAGE_ATTRIBUTES.
• MESSAGE_NAME — the internal name of the message within the message type.
• NAME — the internal name of the specific attribute being translated.
• LANGUAGE — the language code identifying which translation row is being read.
• DISPLAY_NAME — the translated, user-visible display label for the attribute; a documented business-key candidate.
• DESCRIPTION — the translated descriptive text for the attribute.
• SOURCE_LANG — indicates the source language of the translation, used by the translation framework.
• PROTECT_LEVEL — the protection level controlling whether the attribute text may be modified.
• CUSTOM_LEVEL — indicates the customization level applied to the row.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS and governs row-level visibility.
• ZD_EDITION_NAME — the editioning column used in 12.2.2 for online patching and edition-based redefinition.

The surrogate-style primary key is WF_MESSAGE_ATTRIBUTES_TL_PK, defined on MESSAGE_TYPE, MESSAGE_NAME, NAME, and LANGUAGE (with ZD_EDITION_NAME appended in the documented 12.2.2 index). The unique index WF_MESSAGE_ATTRIBUTES_TL_U2 on DISPLAY_NAME, MESSAGE_TYPE, MESSAGE_NAME, and LANGUAGE identifies a business-key candidate ensuring display-name uniqueness within a language. The foreign key ties MESSAGE_TYPE, MESSAGE_NAME, and NAME back to WF_MESSAGE_ATTRIBUTES.

Common Use Cases and Queries

The primary use case is retrieving localized message attribute labels for workflow notification display. Queries typically join the translation table to its base table to render attribute text in a specific language.

A representative pattern selects translated labels for a message type in a given language:

• SELECT t.MESSAGE_TYPE, t.MESSAGE_NAME, t.NAME, t.DISPLAY_NAME, t.DESCRIPTION
• FROM WF_MESSAGE_ATTRIBUTES_TL t
• WHERE t.LANGUAGE = 'US' AND t.MESSAGE_TYPE = :p_type;

Reporting use cases include auditing missing translations (attributes present in the base table but absent for a language), verifying display-name uniqueness using WF_MESSAGE_ATTRIBUTES_TL_U2, and administering customization through PROTECT_LEVEL and CUSTOM_LEVEL. In 12.2.2, queries should account for ZD_EDITION_NAME when relevant to patching editions.

Related Objects

The most significant related objects, drawn from the documented foreign keys, are:

• WF_MESSAGE_ATTRIBUTES — the parent base table; join on MESSAGE_TYPE, MESSAGE_NAME, and NAME.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for row-level security.
• WF_MESSAGES_TL — the parallel translation table for messages, used together when rendering full message metadata.
• WF_MESSAGE_TYPES_TL — translation table for message types, completing the message hierarchy.

These objects collectively form the language-aware workflow message metadata layer, with WF_MESSAGE_ATTRIBUTES_TL supplying the translated attribute-level content.