Search Results fnd_val_attribute_types_tl_uk1

Overview

The FND_VAL_ATTRIBUTE_TYPES_TL table is a core Application Object Library (FND) table within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions for value attribute types. These attribute types are critical components of the Flexfield architecture, specifically Key Flexfields and Descriptive Flexfields, which allow for the extension of application data structures. The table enables the EBS application to display user-friendly prompts and descriptions for these technical attribute types in the language of the end-user, supporting global deployments.

Key Information Stored

The table stores translated text linked to a unique combination of technical identifiers from its parent table. Its structure is defined by a composite primary key and includes language-specific content. The most significant columns include the technical key columns that link to the base table and the translated text column.

• APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE, VALUE_ATTRIBUTE_TYPE: These columns form part of the primary key and foreign key to the FND_VALUE_ATTRIBUTE_TYPES table. They uniquely identify the specific attribute type requiring translation.
• LANGUAGE: The primary key column identifying the language of the translated row (e.g., 'US' for American English).
• PROMPT: The translated, user-facing label or description for the value attribute type, stored in the specified language. This column is part of a unique key constraint (FND_VAL_ATTRIBUTE_TYPES_TL_UK1).

Common Use Cases and Queries

This table is primarily accessed by the application's internal translation architecture and for reporting on Flexfield setup. A common use case is to retrieve the translated prompts for all value attribute types within a specific flexfield structure for a given language. Developers or functional consultants may query this table to verify or audit multilingual setups. A typical query joins the base and translation tables to get a comprehensible list.

Sample Query:
SELECT b.APPLICATION_ID, b.ID_FLEX_CODE, b.VALUE_ATTRIBUTE_TYPE, t.PROMPT, t.LANGUAGE
FROM APPLSYS.FND_VALUE_ATTRIBUTE_TYPES b,
APPLSYS.FND_VAL_ATTRIBUTE_TYPES_TL t
WHERE b.APPLICATION_ID = t.APPLICATION_ID
AND b.ID_FLEX_CODE = t.ID_FLEX_CODE
AND b.SEGMENT_ATTRIBUTE_TYPE = t.SEGMENT_ATTRIBUTE_TYPE
AND b.VALUE_ATTRIBUTE_TYPE = t.VALUE_ATTRIBUTE_TYPE
AND t.LANGUAGE = USERENV('LANG')
ORDER BY b.ID_FLEX_CODE, b.VALUE_ATTRIBUTE_TYPE;

Related Objects

The table has a direct, foundational relationship with its base table, as defined by the provided foreign key metadata. This relationship is essential for maintaining data integrity between technical definitions and their translations.

• FND_VALUE_ATTRIBUTE_TYPES (Base Table): This is the primary related object. The foreign key in FND_VAL_ATTRIBUTE_TYPES_TL references the primary key of FND_VALUE_ATTRIBUTE_TYPES on the columns APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE, and VALUE_ATTRIBUTE_TYPE. Every translated row must correspond to a single row in this base table.