Search Results ak_attributes_tl

Overview

The AK_ATTRIBUTES_TL table is a core repository for translated text associated with descriptive flexfield (DFF) attributes within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It belongs to the AK (Common Modules-AK) schema, which underpins the Application Object Library's flexfield and runtime technology. This table is a translation table (TL), meaning it stores multilingual content for a single base table—in this case, AK_ATTRIBUTES. Its primary role is to enable the display of attribute labels, prompts, and other descriptive elements in the user's session language, supporting the global deployment of EBS applications.

Key Information Stored

The table stores language-specific translations for each attribute defined in the system. Its structure is defined by a composite primary key that uniquely identifies a translation row. The key columns are ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID, which together link back to the base AK_ATTRIBUTES record, and the LANGUAGE column, which holds the language code (e.g., 'US' for American English). The most critical data column is typically ATTRIBUTE_LABEL_LONG, which holds the translated text for the attribute's prompt or label as seen by end-users in forms and reports. Other columns may include creation and modification metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and the SOURCE_LANG, which indicates the original language of the record.

Common Use Cases and Queries

This table is primarily accessed by the EBS runtime to render localized application interfaces. Common administrative and reporting use cases include auditing translation coverage and troubleshooting missing prompts. A typical query retrieves the translated label for a specific attribute in a given language:

• SELECT attribute_label_long FROM ak_attributes_tl WHERE attribute_code = 'MY_ATTRIBUTE' AND attribute_application_id = 401 AND language = USERENV('LANG');

Another common pattern is to identify attributes missing a translation for a critical language by joining to the base table and filtering on the LANGUAGE and SOURCE_LANG columns.

Related Objects

AK_ATTRIBUTES_TL has a direct, dependent relationship with its base table, AK_ATTRIBUTES. As documented in the foreign key metadata, every record in AK_ATTRIBUTES_TL must correspond to a parent record in AK_ATTRIBUTES. The join is performed on two columns:

• Foreign Key to AK_ATTRIBUTES: AK_ATTRIBUTES_TL.ATTRIBUTE_CODE references AK_ATTRIBUTES.ATTRIBUTE_CODE
• Foreign Key to AK_ATTRIBUTES: AK_ATTRIBUTES_TL.ATTRIBUTE_APPLICATION_ID references AK_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID

This table is also integral to views that present a combined, language-sensitive perspective of attribute definitions, and it is maintained by standard EBS translation utilities and the Application Developer responsibility screens.