Search Results bsc_kpi_defaults_tl




Overview
Explore in AI Chat

Overview

The BSC_KPI_DEFAULTS_TL table is a translation table within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module. Its primary role is to store translated textual data for the information box associated with Key Performance Indicator (KPI) defaults, enabling the application to support multiple languages. This table is part of the now-obsolete Balanced Scorecard product, which was a strategic performance management tool. As a translation (TL) table, it operates in conjunction with its base table, BSC_KPI_DEFAULTS_B, to provide language-specific descriptions and labels, a standard architectural pattern in Oracle Applications for internationalization.

Key Information Stored

The table stores multilingual data for KPI default settings. Its structure is defined by a composite primary key that uniquely identifies each translated record. The critical columns are:

  • INDICATOR: A foreign key column linking to the BSC_KPI_DEFAULTS_B table, identifying the specific KPI.
  • TAB_ID: Part of the primary key, this column, along with INDICATOR, identifies the specific information box or tab within the KPI's default settings that requires translation.
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translated text, completing the primary key.
  • Translated Text Columns: While the exact column names are not specified in the provided metadata, translation tables in Oracle EBS typically include columns such as DESCRIPTION, NAME, or SOURCE_LANG to hold the language-specific text and track the source language of the translation.

Common Use Cases and Queries

This table is primarily accessed by the application's user interface logic to display KPI information box labels and descriptions in the user's session language. A common reporting or data validation use case involves verifying that all critical KPIs have translations for implemented languages. A typical query would join the base and translation tables to retrieve a complete multilingual dataset.

Sample SQL Pattern:
SELECT b.INDICATOR,
      t.LANGUAGE,
      t.DESCRIPTION
FROM BSC_KPI_DEFAULTS_B b,
      BSC_KPI_DEFAULTS_TL t
WHERE b.INDICATOR = t.INDICATOR
AND b.TAB_ID = t.TAB_ID
AND t.LANGUAGE = USERENV('LANG');

Related Objects

The BSC_KPI_DEFAULTS_TL table has a direct and essential relationship with its base table, as documented in the provided metadata.

  • BSC_KPI_DEFAULTS_B: This is the primary related object. The foreign key relationship from BSC_KPI_DEFAULTS_TL to BSC_KPI_DEFAULTS_B is defined on the composite columns (INDICATOR, TAB_ID). Every record in the translation table must correspond to a record in this base table, which holds the non-translatable, language-independent data for KPI defaults.

Given the module's obsolete status, custom integrations or data extracts referencing this table are likely for historical data analysis or migration purposes rather than active application development.