Search Results bsc_sys_dim_levels_tl




Overview
Explore in AI Chat

Overview

The BSC_SYS_DIM_LEVELS_TL table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as a translation table, storing multilingual descriptions and names for dimension levels defined in the system. Dimension levels are hierarchical elements within a business dimension (such as Geography, Organization, or Product) used to structure and analyze performance data in the Balanced Scorecard framework. This table's primary role is to support global deployments by enabling the display of dimension level information in a user's preferred language, a critical feature for multinational organizations. It is a companion table to its base table, BSC_SYS_DIM_LEVELS_B, which holds the language-independent structural data.

Key Information Stored

The table's structure is designed to manage translated text for each dimension level across multiple languages. Its primary key, composed of DIM_LEVEL_ID and LANGUAGE, ensures a unique translation entry per level per language. The DIM_LEVEL_ID column is a foreign key linking directly to the corresponding record in the BSC_SYS_DIM_LEVELS_B base table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean). The most significant data columns typically include NAME and DESCRIPTION, which hold the translated text for the dimension level's display name and a longer explanatory note, respectively. Additional standard columns like CREATION_DATE and LAST_UPDATE_DATE are also present for auditing purposes.

Common Use Cases and Queries

The primary use case is retrieving user-friendly dimension level names for reports, user interfaces, and analytics within a multilingual context. A common query involves joining this table with its base table to fetch all translations for a specific dimension or to get the description in the current session's language for display. For example, to list all dimension level names in American English, a developer might use:

  • SELECT b.NAME, tl.NAME, tl.DESCRIPTION
  • FROM BSC_SYS_DIM_LEVELS_B b, BSC_SYS_DIM_LEVELS_TL tl
  • WHERE b.DIM_LEVEL_ID = tl.DIM_LEVEL_ID
  • AND tl.LANGUAGE = 'US';

Another critical scenario is during the implementation of new languages, where data is populated into this table via the standard Oracle translation tools or APIs to support additional locales.

Related Objects

This table has a direct and essential relationship with its base table, as defined in the provided metadata. The relationship is a foreign key constraint where BSC_SYS_DIM_LEVELS_TL.DIM_LEVEL_ID references BSC_SYS_DIM_LEVELS_B. This enforces referential integrity, ensuring that every translation record corresponds to a valid, existing dimension level. The base table BSC_SYS_DIM_LEVELS_B stores the fundamental, non-translatable attributes of a dimension level, such as its hierarchy position and internal code. Consequently, any application logic or report displaying dimension level information will typically perform an INNER JOIN between these two tables, using DIM_LEVEL_ID as the join column and filtering on the LANGUAGE column.