Search Results fnd_profile_options_tl

Overview

The FND_PROFILE_OPTIONS_TL table is a core Application Object Library table within Oracle E-Business Suite (EBS) that stores translated text for user-defined profile options. It is a child table to FND_PROFILE_OPTIONS, enabling the multi-language support (NLS) capabilities of the application. Its primary role is to provide the translated names and descriptions for profile options that appear within the EBS user interface, such as in the "Define Profile Option" form or the "System Profile Values" window, based on the user's session language. This table is essential for the internationalization and localization of the EBS environment, ensuring that administrators and users see profile option metadata in their preferred language.

Key Information Stored

The table holds the translated textual attributes for a profile option. Its structure is centered around a unique combination of the profile option's internal name and the language code. Key columns include PROFILE_OPTION_NAME, which is the foreign key to FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME, and LANGUAGE, which stores the language code (e.g., 'US' for American English). The primary content columns are USER_PROFILE_OPTION_NAME, which holds the translated name for display to users, and DESCRIPTION, which contains the translated explanatory text for the profile option. The table is designed with two unique keys to enforce data integrity: one on the internal name and language, and another on the user-facing name and language.

Common Use Cases and Queries

A primary use case is auditing or reporting on the availability of profile option translations for specific languages during implementation or upgrade projects. Developers and system administrators also query this table to verify that custom profile options have been correctly registered for translation. A common query retrieves all translations for a specific profile option to review consistency across languages.

SELECT pot.language,
       pot.user_profile_option_name,
       pot.description
FROM   fnd_profile_options_tl pot,
       fnd_profile_options po
WHERE  po.profile_option_name = pot.profile_option_name
AND    po.user_profile_option_name = '&PROFILE_DISPLAY_NAME'
ORDER BY pot.language;

Another typical pattern is to join this table with FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES to generate a user-friendly report of set profile values, displaying the option name in the session language.

Related Objects

• Primary Parent Table (Foreign Key): FND_PROFILE_OPTIONS. The FND_PROFILE_OPTIONS_TL table has a foreign key relationship where FND_PROFILE_OPTIONS_TL.PROFILE_OPTION_NAME references FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME. This links each translation row to its master profile option definition.
• Key Dependent Views/APIs: While not listed in the provided metadata, this table is the source for translated data in various profile-related views and is accessed by the standard FND_PROFILE API (FND_PROFILE package). Direct manipulation of data in this table should be performed using the standard Oracle Application Object Library APIs, such as FND_PROFILE_OPTION_PKG, to maintain integrity.