Search Results bsc_responsibility_tl




Overview
Explore in AI Chat

Overview

The BSC_RESPONSIBILITY_TL table is a core data object within the Balanced Scorecard (BSC) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions and names for Balanced Scorecard responsibilities. Its primary role is to support the global deployment of the BSC application by enabling the user interface and reports to display responsibility information in the user's preferred language, as defined by their session. This table is a child of the base table BSC_RESPONSIBILITY, which holds the language-independent responsibility definitions.

Key Information Stored

The table's structure is designed to support the EBS Multi-Language Support (MLS) architecture. Its composite primary key uniquely identifies each translated record and consists of three columns: APPLICATION_ID, LANGUAGE, and RESPONSIBILITY_ID. The APPLICATION_ID typically corresponds to the BSC module's application identifier. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'D' for German). The RESPONSIBILITY_ID is the foreign key linking back to the base responsibility definition in BSC_RESPONSIBILITY. The most critical data column in this table is RESPONSIBILITY_NAME, which holds the translated name of the responsibility as it should appear in menus and reports for the specified language. Other descriptive columns may also be present to support full translation of the responsibility entity.

Common Use Cases and Queries

A primary use case is generating user-facing reports or application screens that display responsibility information in the session language. Administrators and developers query this table to audit or manage translated content. A common SQL pattern retrieves the translated responsibility name for a specific ID and language, often joining to the base table for additional context. For example:

  • Retrieving all translations for a specific responsibility: SELECT language, responsibility_name FROM bsc_responsibility_tl WHERE responsibility_id = :resp_id;
  • Joining with the base table for a complete view: SELECT b.responsibility_key, t.language, t.responsibility_name FROM bsc_responsibility b, bsc_responsibility_tl t WHERE b.responsibility_id = t.responsibility_id AND t.language = :nls_lang;

Data in this table is typically maintained via the standard Oracle EBS translation forms or utilities, not via direct DML.

Related Objects

The BSC_RESPONSIBILITY_TL table has a direct and critical relationship with its parent table, as documented in the provided metadata. The foreign key constraint enforces referential integrity.

  • BSC_RESPONSIBILITY: This is the primary base table. The relationship is defined by the foreign key from BSC_RESPONSIBILITY_TL.RESPONSIBILITY_ID to BSC_RESPONSIBILITY. All responsibility IDs in the TL table must exist in the base table. Standard queries join these tables on the RESPONSIBILITY_ID column.

As a translation table, it is also intrinsically linked to the EBS language and NLS (National Language Support) setup tables (such as FND_LANGUAGES), which provide the valid list of language codes referenced in its LANGUAGE column.