Search Results bsc_tab_view_kpi_vl

Overview

BSC_TAB_VIEW_KPI_VL is a multilingual (ML) validation view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is a component of the Balanced Scorecard (BSC) product, which forms part of the Oracle Enterprise Performance Foundation / Daily Business Intelligence stack. The view presents a filtered, language-aware projection of the underlying translation table BSC_TAB_VIEW_KPI_TL, exposing the KPI placement and formatting attributes configured for scorecard tab views.

In Oracle EBS, "_VL" views follow a standard convention: they join or filter an "_TL" translation table against the session language so that each query returns exactly one row per logical entity, already localized. BSC_TAB_VIEW_KPI_VL applies this pattern directly — its defining query restricts BSC_TAB_VIEW_KPI_TL rows to WHERE LANGUAGE = USERENV('LANG'), the environment function that resolves the language of the current database session. This makes the view the preferred access point for reports, concurrent programs, and integration interfaces that must display scorecard KPI text in the user's own language without embedding language-selection logic in application code.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: BSC_TAB_VIEW_KPI_TL, the translation table holding language-specific and language-independent columns for KPI elements rendered within a Balanced Scorecard tab view. The view performs no joins to additional master tables; it is a straight column projection with a language predicate. Consequently, referential data such as the parent tab or tab view definition is not resolved by this view and must be obtained from the corresponding master tables (for example, the BSC tab and tab view entities keyed by TAB_ID and TAB_VIEW_ID).

Key Columns

• TAB_ID — Identifier of the scorecard tab to which the KPI presentation record belongs.
• TAB_VIEW_ID — Identifier of the specific tab view within that tab.
• INDICATOR — The KPI or indicator associated with the tab view placement.
• TEXT_FLAG — Flag controlling whether textual labeling is rendered for the KPI element; the object of the user's search and a key display-behaviour switch.
• LEFT_POSITION, TOP_POSITION — Coordinates positioning the KPI text element within the tab view canvas.
• WIDTH, HEIGHT — Dimensions of the text region.
• FONT_SIZE, FONT_STYLE, FONT_COLOR — Formatting attributes applied to the rendered KPI text.
• COLOR_LEFT_POSITION, COLOR_TOP_POSITION, COLOR_WIDTH, COLOR_HEIGHT, COLOR_SIZE — Geometry and sizing attributes for the associated colour indicator region.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns describing record creation and maintenance.

Common Use Cases and Queries

The view is used to retrieve localized KPI layout metadata for a scorecard tab view, typically to drive rendering or to audit configured presentation settings. A representative query lists all KPI elements for a given tab view:

SELECT tab_id, tab_view_id, indicator, text_flag, left_position, top_position, width, height, font_size, font_style, font_color
FROM apps.bsc_tab_view_kpi_vl
WHERE tab_view_id = :p_tab_view_id
ORDER BY indicator;

Because TEXT_FLAG governs whether a label is drawn, a frequent diagnostic query isolates elements with text enabled or disabled for a tab:

SELECT tab_view_id, indicator, text_flag
FROM apps.bsc_tab_view_kpi_vl
WHERE tab_id = :p_tab_id
AND text_flag = 'Y';

Integration and migration scripts use the view to compare configured formatting across environments, selecting the audit columns alongside the presentation attributes. Since the view already filters by session language, no additional language predicate is required in these queries; the value of USERENV('LANG') at execution time determines which translation row is returned.