Search Results fnd_responsibility_tl

Overview

The FND_RESPONSIBILITY_TL table is a core Application Object Library table within the Oracle E-Business Suite (EBS) architecture, specifically versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual representations of responsibility names and descriptions. A responsibility defines a level of authority and a specific menu of functions within the application, and this table enables the presentation of those responsibility definitions in a user's preferred language. It is a child table to the base table FND_RESPONSIBILITY, which holds the core, language-independent definition. The existence of this table is fundamental to the internationalization (i18n) capabilities of Oracle EBS, allowing a single installation to support a globally diverse user base.

Key Information Stored

The table's structure is designed to map translated text to specific responsibility records and languages. Its critical columns, as defined by its primary and unique keys, are APPLICATION_ID, RESPONSIBILITY_ID, and LANGUAGE. The APPLICATION_ID and RESPONSIBILITY_ID together form a foreign key link back to the parent FND_RESPONSIBILITY table, uniquely identifying the core responsibility. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'D' for German) for the translation. The most significant data columns are RESPONSIBILITY_NAME and DESCRIPTION, which store the translated name and descriptive text for the responsibility in the specified language. This design ensures that for each responsibility in FND_RESPONSIBILITY, multiple translated records can exist in FND_RESPONSIBILITY_TL.

Common Use Cases and Queries

This table is primarily queried by the EBS application runtime to display responsibility names in the user's session language during navigation and responsibility selection. Common technical and administrative use cases include generating reports of responsibilities for all supported languages, auditing translation completeness, and troubleshooting user access issues related to language settings. A typical query to retrieve all translations for a specific responsibility would join to the base table:

• SELECT frt.responsibility_name, frt.description, frt.language
• FROM fnd_responsibility fr, fnd_responsibility_tl frt
• WHERE fr.application_id = frt.application_id
• AND fr.responsibility_id = frt.responsibility_id
• AND fr.responsibility_key = 'SYSTEM_ADMINISTRATOR';

Another common pattern is to retrieve the responsibility name in the current database session language using the USERENV('LANG') context or by joining to the FND_LANGUAGES table.

Related Objects

FND_RESPONSIBILITY_TL has a direct and singular parent-child relationship with the FND_RESPONSIBILITY table, as documented by its foreign key. The join is performed on the composite key of APPLICATION_ID and RESPONSIBILITY_ID. This table is also referenced by various Application Object Library APIs and views that handle responsibility data, such as those used by the System Administrator responsibility forms (e.g., the Define Responsibility form). While not listed in the provided metadata, it is common for language-specific views or public synonyms to be built upon this table to simplify application access. All data manipulation should typically be performed via the provided Oracle APIs (e.g., FND_RESPONSIBILITY_PKG) to maintain data integrity with the parent table and other system dependencies.