Search Results bsc_tab_views_vl




Overview
Explore in AI Chat

Overview

BSC_TAB_VIEWS_VL is a translation-enabled (VL, or "view with language") database view that belongs to the BSC – Balanced Scorecard product family in Oracle E-Business Suite. In ETRM 12.1.1 and 12.2.2, the Balanced Scorecard module is documented as obsolete, meaning it is retained for backward compatibility and historical data access but is no longer actively enhanced or supported for new implementations.

Views suffixed with _VL are a standard EBS design pattern. They join a base table (_B) containing language-independent columns with a translation table (_TL) containing language-dependent descriptive columns such as Name and Help. The view applies a USERENV('LANG') predicate so that each session automatically retrieves the description in the user's current language. This makes BSC_TAB_VIEWS_VL the primary presentation-layer object for retrieving dashboard "tab views" (the selectable tabs on a Balanced Scorecard dashboard) in the correct language, whether accessed from a form, an OA Framework page, a concurrent report, or a custom SQL integration.

Underlying Base Objects

The view is defined directly over two documented base tables:

  • BSC_TAB_VIEWS_B — the base table holding language-independent attributes: identifiers, the enabled flag, and standard WHO audit columns.
  • BSC_TAB_VIEWS_TL — the translation table holding the language-specific NAME and HELP text, keyed by language.

The join is performed on the composite key TAB_ID + TAB_VIEW_ID. The documented view text is:

SELECT B.TAB_ID, B.TAB_VIEW_ID, TL.NAME, TL.HELP, B.ENABLED_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM BSC_TAB_VIEWS_B B, BSC_TAB_VIEWS_TL TL WHERE B.TAB_ID = TL.TAB_ID AND B.TAB_VIEW_ID = TL.TAB_VIEW_ID AND TL.LANGUAGE = USERENV('LANG')

No additional base objects are documented in the ETRM metadata, and no implementing database DBA data is present in the reference environment, reinforcing the obsolete status of the module.

Key Columns

  • TAB_ID — Identifier of the parent Balanced Scorecard tab (dashboard section) to which the view belongs.
  • TAB_VIEW_ID — Identifier of the specific view (sub-section or visualization) within the tab.
  • NAME — Translated display name of the tab view, sourced from BSC_TAB_VIEWS_TL.
  • HELP — Translated help or descriptive text for the tab view, also from the translation table.
  • ENABLED_FLAG — Indicates whether the tab view is active (Y) or inactive (N) for display.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS "WHO" audit columns tracking record creation and last modification.

Common Use Cases and Queries

Typical usage includes generating configuration reports of available scorecard tab views, driving custom dashboards or portals that need translated labels, and migrating Balanced Scorecard configurations between environments during archival or upgrade activities.

List all enabled tab views in the session's language:

SELECT tab_id, tab_view_id, name, help FROM bsc_tab_views_vl WHERE enabled_flag = 'Y' ORDER BY tab_id, tab_view_id;

Retrieve views for a specific tab:

SELECT tab_view_id, name FROM bsc_tab_views_vl WHERE tab_id = :p_tab_id ORDER BY name;

Audit recently modified entries:

SELECT tab_id, tab_view_id, name, last_updated_by, last_update_date FROM bsc_tab_views_vl WHERE last_update_date > SYSDATE - 30;