Search Results bsc_tab_csf_tl




Overview
Explore in AI Chat

Overview

The BSC_TAB_CSF_TL table is a translation table within the now-obsolete Balanced Scorecard (BSC) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its core function is to store multilingual translations for Critical Success Factor (CSF) names and descriptions associated with specific tabs or perspectives within the Balanced Scorecard framework. This table is a critical component of the application's global deployment capabilities, enabling the display of CSF information in a user's preferred language. It operates as a child table to the base data table, BSC_TAB_CSF_B, and is a standard implementation of Oracle's Multi-Language Support (MLS) architecture, where '_TL' denotes a translation table.

Key Information Stored

The table's structure is designed to link translated text to a specific base record and language. The primary key is a composite of CSF_ID, TAB_ID, and LANGUAGE, ensuring a unique translation entry for each CSF within a specific tab and language combination. While the specific column list is not detailed in the provided metadata, standard translation table patterns in EBS indicate it likely contains columns such as CSF_ID (foreign key to the base table), TAB_ID (foreign key to the tab/perspective), LANGUAGE (the language code, e.g., 'US' for American English), SOURCE_LANG (the original language of the data), NAME (the translated name of the CSF), and DESCRIPTION (the translated descriptive text). The presence of SOURCE_LANG is typical for tracking the original language from which translations were made.

Common Use Cases and Queries

The primary use case is the dynamic retrieval of CSF labels for the user interface based on the session language. Application code will join this table to its base table, filtering on the LANGUAGE column matching the user's session language. A common reporting query might extract all translations for a given CSF to verify localization completeness. For example:

  • SELECT csf_tl.name, csf_tl.description, csf_tl.language FROM bsc_tab_csf_tl csf_tl WHERE csf_tl.tab_id = :p_tab_id AND csf_tl.csf_id = :p_csf_id ORDER BY language;

Administrative use cases include seeding new language translations or updating existing translated text via standard EBS localization tools or direct data manipulation, always ensuring referential integrity with the base table is maintained.

Related Objects

The metadata explicitly defines this table's relationship with its base data table. BSC_TAB_CSF_TL has a foreign key relationship to BSC_TAB_CSF_B on the composite columns (CSF_ID, TAB_ID). This means BSC_TAB_CSF_B holds the base, non-translatable attributes of the Critical Success Factor, while BSC_TAB_CSF_TL holds the translatable attributes. As part of the obsolete Balanced Scorecard module, it would have been referenced by various application forms, reports, and potentially other BSC data tables and views that present CSF information. Any programmatic API for maintaining CSF data would also need to handle operations on this translation table.