Search Results wf_item_attributes_tl_uk2

Overview

The WF_ITEM_ATTRIBUTES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Workflow engine. Residing in the APPLSYS schema under the Application Object Library (FND) product, its primary function is to store translated, language-specific versions of the display names for workflow item type attributes. This table enables the multilingual support of the Oracle Workflow module, allowing the same business process definitions to present user-facing attribute labels in the language of the user's session. It is a critical component for global deployments of EBS 12.1.1 and 12.2.2, ensuring that workflow notifications, web pages, and monitoring interfaces are correctly localized.

Key Information Stored

The table stores the translated text for workflow attribute display names, keyed by the original attribute identifier and the language code. The primary columns, as defined by the WF_ITEM_ATTRIBUTES_TL_PK primary key, are ITEM_TYPE, NAME, and LANGUAGE. The ITEM_TYPE and NAME columns together form a foreign key reference to the base WF_ITEM_ATTRIBUTES table, identifying the specific attribute being translated. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'D' for German). The most significant data column is DISPLAY_NAME, which contains the actual translated text for the attribute's label. A unique key (WF_ITEM_ATTRIBUTES_TL_UK2) on ITEM_TYPE, DISPLAY_NAME, and LANGUAGE enforces data integrity for these translations.

Common Use Cases and Queries

A primary use case is generating user interfaces or reports that display workflow information in the end-user's language. Administrators may query this table to audit or manage translations for custom or modified workflow processes. A common SQL pattern retrieves the translated display name for a specific attribute in the current session language, often by joining with the FND_LANGUAGES table. For example:

• SELECT wftl.display_name FROM wf_item_attributes_tl wftl, fnd_languages l WHERE wftl.item_type = '<ITEM_TYPE>' AND wftl.name = '<ATTR_NAME>' AND wftl.language = l.language_code AND l.installed_flag IN ('I', 'B');

Another typical query lists all translations for a given workflow item type to verify completeness across installed languages.

Related Objects

WF_ITEM_ATTRIBUTES_TL has a direct and essential relationship with the base definition table, WF_ITEM_ATTRIBUTES. As documented in the foreign key metadata, WF_ITEM_ATTRIBUTES_TL references WF_ITEM_ATTRIBUTES on the composite key of ITEM_TYPE and NAME. This ensures every translation record corresponds to a valid, defined workflow attribute. The table is also intrinsically linked to the language setup of the EBS instance, often referenced alongside the FND_LANGUAGES table to filter for actively installed languages. Views or APIs that present localized workflow metadata, such as those used by the Workflow Builder or the Workflow Definitions Loader, will inherently depend on the data within this translation table.