Search Results bsc_kpi_shell_cmds_tl




Overview
Explore in AI Chat

Overview

The BSC_KPI_SHELL_CMDS_TL table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) module, present in both releases 12.1.1 and 12.2.2. As a translation table (denoted by the '_TL' suffix), its primary function is to store language-specific, user-facing text for Key Performance Indicator (KPI) shell commands. These commands represent executable actions or operations that can be associated with a KPI, providing a mechanism for user interaction directly from the scorecard interface. The table plays a critical role in enabling the multilingual capabilities of the BSC module by separating translatable command descriptions from the core command logic.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of the INDICATOR and SHELL_CMD_ID columns. The INDICATOR column is a foreign key that links the command to a specific KPI defined in the BSC_KPIS_B table. The SHELL_CMD_ID uniquely identifies the command itself within the context of that KPI. While the provided metadata does not list all columns, standard '_TL' table conventions dictate the presence of a LANGUAGE column (and often a SOURCE_LANG column) to identify the translation language, alongside columns for the translated text, such as SHELL_CMD_NAME or DESCRIPTION. The table also typically includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is primarily accessed for user interface rendering and administrative setup. A common operational query retrieves the translated command label for a specific KPI and language to populate a dashboard or scorecard view. For example:

  • SELECT shell_cmd_name FROM bsc_kpi_shell_cmds_tl WHERE indicator = 1001 AND shell_cmd_id = 10 AND language = USERENV('LANG');

Administrative use cases involve querying or maintaining translations during implementation or localization. Support personnel may query this table to verify that all required command translations exist for a newly configured KPI or to diagnose missing UI text. Reporting use cases are typically limited to translation audits or configuration documentation.

Related Objects

The BSC_KPI_SHELL_CMDS_TL table sits at the center of a small hierarchy of command-related tables within the BSC schema, as documented by its foreign key relationships.

  • References (Parent): BSC_KPIS_B. The INDICATOR column is a foreign key to this base KPI definition table, ensuring every command is linked to a valid KPI.
  • Referenced By (Child): BSC_KPI_SHELL_CMDS_USER. This table references BSC_KPI_SHELL_CMDS_TL using both the INDICATOR and SHELL_CMD_ID columns. This relationship likely stores user-specific assignments, preferences, or execution data for the shell commands defined in the translation table.