Search Results bsc_tab_view_labels_tl

Overview

BSC_TAB_VIEW_LABELS_VL is a language-dependent (VL) view in the Oracle E-Business Suite Balanced Scorecard (BSC) module. The BSC module is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2, meaning it is retained for backward compatibility but is no longer actively developed or supported for new implementations. This view presents translated label metadata used to render tab and tab-view labels within Balanced Scorecard dashboards and scorecard pages. Each row combines the base (language-independent) label attributes from BSC_TAB_VIEW_LABELS_B with the translated name, note, and display properties from BSC_TAB_VIEW_LABELS_TL, filtered to the session language through USERENV('LANG').

The view is relevant to reporting and integration because it resolves three distinct label types into a single human-readable NAME value, joining to other BSC and FND views as required. This makes it a convenient single-source query for extracting localized scorecard label definitions without manually decoding the LABEL_TYPE discriminator.

Underlying Base Objects

The view is defined over two documented base tables:

• BSC_TAB_VIEW_LABELS_B — the base table holding language-independent label attributes: TAB_ID, TAB_VIEW_ID, LABEL_ID, LABEL_TYPE, LINK_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
• BSC_TAB_VIEW_LABELS_TL — the translation table holding the NAME, NOTE, and display properties (TEXT_FLAG, LEFT_POSITION, TOP_POSITION, WIDTH, HEIGHT, FONT_SIZE, FONT_STYLE, FONT_COLOR, URL) for each language.

The join is performed on the composite key (TAB_ID, TAB_VIEW_ID, LABEL_ID) plus the language predicate TL.LANGUAGE = USERENV('LANG'). The view text additionally embeds scalar subqueries against BSC_TAB_VIEWS_VL and FND_MENUS_VL, resolving label targets for LABEL_TYPE values of 1 and 2 respectively. This is the point of intersection with the user's search term "fnd_menus_vl": FND_MENUS_VL supplies the USER_MENU_NAME for menu-type labels. ETRM metadata for 12.2.2 documents no referenced base objects and no owner, and the object is noted as "Not implemented in this database."

Key Columns

• TAB_ID, TAB_VIEW_ID, LABEL_ID — composite primary key identifying the label and its parent tab/tab view.
• LABEL_TYPE — discriminator controlling how NAME is resolved: 0 = literal translated name, 1 = name of another tab view (BSC_TAB_VIEWS_VL), 2 = user menu name (FND_MENUS_VL).
• LINK_ID — target identifier: the linked TAB_VIEW_ID when LABEL_TYPE = 1, or the MENU_ID when LABEL_TYPE = 2.
• NAME — the resolved, translated display label.
• NOTE, TEXT_FLAG, URL — supplementary display text and navigation target.
• LEFT_POSITION, TOP_POSITION, WIDTH, HEIGHT, FONT_SIZE, FONT_STYLE, FONT_COLOR — presentation attributes for rendering the label.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing localized scorecard labels, locating which labels link to a specific FND menu, and extracting presentation metadata for reporting. Because the view is obsolete and may be absent depending on the instance, existence checks are prudent.

• List all labels for a tab view: SELECT label_id, name, label_type FROM bsc_tab_view_labels_vl WHERE tab_id = :tab_id AND tab_view_id = :tab_view_id;
• Find labels bound to FND menus: SELECT label_id, name, link_id FROM bsc_tab_view_labels_vl WHERE label_type = 2;
• Verify availability: SELECT object_name, status FROM all_objects WHERE object_name = 'BSC_TAB_VIEW_LABELS_VL';