Search Results bsc_sys_labels_vl

Overview

BSC_SYS_LABELS_VL is a translatable (VL) view within the Oracle E-Business Suite Balanced Scorecard module. In EBS 12.1.1 and 12.2.2 it belongs to the BSC product family, which the ETRM metadata classifies as Obsolete. The view exposes the system-level label definitions that the Balanced Scorecard user interface uses to render configurable text captions over scorecard diagrams — the visible label text, along with its placement coordinates and font presentation attributes.

Like other _VL views in EBS, this object serves a dual purpose. Oracle Forms and OAF-based pages query it to obtain the current-language value of a label; the "_VL" (view, translated) construct is the standard pattern that joins the base table (_B) with its translation table (_TL) and filters on the session language using USERENV('LANG'). Reporting tools such as Oracle Reports, BI Publisher, and Discoverer can also select from this view, so that labels are returned in the language of the reporting session rather than the base language of the underlying row. Because BSC is obsolete, the view is retained primarily for backward compatibility with existing customizations, historical data models, and any reports that still reference it.

Underlying Base Objects

The view is defined over exactly two documented base objects:

• BSC_SYS_LABELS_B — the base table holding language-independent and presentation attributes: SOURCE_TYPE, SOURCE_CODE, LABEL_ID, LEFT_POSITION, TOP_POSITION, FONT_SIZE, and FONT_STYLE.
• BSC_SYS_LABELS_TL — the translation table holding the language-dependent NAME column keyed by source type, source code, label ID, and language.

The join condition links the two tables on the composite key (SOURCE_TYPE, SOURCE_CODE, LABEL_ID) and restricts the result to the row whose LANGUAGE matches the value returned by USERENV('LANG'). This is the canonical EBS translation pattern, ensuring that only a single language variant of each label is surfaced per session. As documented, the object is not implemented in the reference ETRM database and no additional referenced base objects are recorded beyond the two _B/_TL tables.

Key Columns

• SOURCE_TYPE — classification of the entity the label belongs to; part of the composite primary key.
• SOURCE_CODE — identifier of the specific source object to which the label is attached; part of the key.
• LABEL_ID — unique identifier of the label within its source; part of the key.
• NAME — the translated display text of the label, drawn from BSC_SYS_LABELS_TL.
• LEFT_POSITION and TOP_POSITION — the X and Y coordinates that position the label within the scorecard canvas.
• FONT_SIZE — the point or relative size applied to the rendered label.
• FONT_STYLE — the font treatment (for example, bold, italic, or a named style) applied to the label.

Common Use Cases and Queries

Typical usage involves retrieving the labels and layout attributes for a given scorecard source so that a report or custom page can reproduce the on-screen presentation, or auditing which labels exist for a source across the schema.

All labels for a given source:

SELECT source_type, source_code, label_id, name,
       left_position, top_position, font_size, font_style
FROM   bsc_sys_labels_vl
WHERE  source_type = :p_source_type
AND    source_code = :p_source_code
ORDER  BY left_position, top_position;

A single label lookup by key:

SELECT name, font_size, font_style
FROM   bsc_sys_labels_vl
WHERE  source_type = :p_source_type
AND    source_code = :p_source_code
AND    label_id    = :p_label_id;

An inventory of label counts by source:

SELECT source_type, source_code, COUNT(*) label_count
FROM   bsc_sys_labels_vl
GROUP  BY source_type, source_code
ORDER  BY source_type, source_code;

Because the view filters on USERENV('LANG'), results are always returned in the language of the executing session. In a multilingual implementation, the same query run under different language settings returns the corresponding translation from BSC_SYS_LABELS_TL, making the view suitable for localized reporting without language-specific SQL.