Results for “fnd_profile_options_tl”

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

Overview

FND_PROFILE_OPTIONS_TL is the translation (language-specific text) table for FND_PROFILE_OPTIONS within the FND - Application Object Library product of Oracle E-Business Suite. It is owned by the APPLSYS schema and holds user-facing descriptions for each profile option, keyed by profile option name and language. Because Oracle EBS is a multilingual application, the base configuration row lives in FND_PROFILE_OPTIONS, while the descriptive text visible to users in the current session language is resolved from this table.

The object is documented as VALID in ETRM for both 12.1.1 and 12.2.2. Its structure is typical of a _TL translation entity: it is a dependent child of the base table, with no independent lifecycle. From a data-modeling perspective, the mined relationship metadata classifies this object as satellite-leaning — a modeling suggestion indicating that it extends the descriptive attributes of a parent hub/entity (FND_PROFILE_OPTIONS) rather than establishing its own identity or acting as a link between entities.

Key Information Stored

The table carries eleven documented columns. The most important are:

• PROFILE_OPTION_NAME — the profile option identifier; part of the primary key and the foreign key back to FND_PROFILE_OPTIONS.
• LANGUAGE — the language code of the translated row; the second component of the primary key.
• USER_PROFILE_OPTION_NAME — the user-facing profile option name, exposed as a unique-index candidate.
• DESCRIPTION — the translated descriptive text shown to users.
• SOURCE_LANG — the language from which the row was derived, used by the translation (TL) mechanism to track the origin language.
• ZD_EDITION_NAME — the editioning column introduced in the 12.2 online patching architecture, present in both unique indexes.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The surrogate primary key is FND_PROFILE_OPTIONS_TL_PK (PROFILE_OPTION_NAME, LANGUAGE). Two business-key candidates are documented as unique indexes: FND_PROFILE_OPTIONS_TL_U1 (PROFILE_OPTION_NAME, LANGUAGE, ZD_EDITION_NAME) and FND_PROFILE_OPTIONS_TL_U2 (USER_PROFILE_OPTION_NAME, LANGUAGE, ZD_EDITION_NAME). The 12.2 editioning suffix on both unique keys reflects the AD/TXK edition-based redefinition feature used for online patching.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios involve resolving the correct language description for a profile option in the current session language, and identifying untranslated or missing rows during localization work.

A common join retrieves the description for a profile option:

• SELECT p.PROFILE_OPTION_NAME, t.USER_PROFILE_OPTION_NAME, t.DESCRIPTION FROM FND_PROFILE_OPTIONS p, FND_PROFILE_OPTIONS_TL t WHERE p.PROFILE_OPTION_NAME = t.PROFILE_OPTION_NAME AND t.LANGUAGE = USERENV('LANG');

Other practical patterns include:

• Listing all installed translations for a given profile option to audit language coverage.
• Detecting orphaned TL rows where PROFILE_OPTION_NAME has no matching parent row.
• Reporting on rows where SOURCE_LANG differs from LANGUAGE to understand the translation source chain.
• Verifying that ZD_EDITION_NAME is populated correctly during 12.2 patching verification.

Because the table is a translation child, inserts and updates are normally performed through the profile option maintenance forms and the FND_PROFILE APIs rather than by direct DML.

Related Objects

• FND_PROFILE_OPTIONS — the parent base table; joined on FND_PROFILE_OPTIONS_TL.PROFILE_OPTION_NAME = FND_PROFILE_OPTIONS.PROFILE_OPTION_NAME.
• FND_PROFILE_OPTION_VALUES — holds the available values and level settings for profile options.
• FND_PROFILE_OPTION_LEVELS — defines the valid levels (Site, Application, Responsibility, User) for a profile option.
• FND_APPLICATION_TL — provides translated application names that frequently accompany profile option reports.
• FND_LANGUAGES — supplies the language rows used to interpret the LANGUAGE and SOURCE_LANG columns.
• FND_PROFILE (PL/SQL package) — the primary API for retrieving and maintaining profile option values at runtime.

These objects together form the profile option configuration and translation model used throughout Application Object Library.