Search Results bsc_sys_labels_b_u1

Overview

BSC.BSC_SYS_LABELS_B is a base table in the Balanced Scorecard (BSC) schema of Oracle E-Business Suite, owned by the BSC application and registered in FND Design Data. It stores the definition and on-screen placement of labels rendered against scorecard tabs and simulation tree indicators. In practical terms, the table supplies the presentation metadata that allows the BSC user interface to position and style short text captions on a diagram or tabbed layout — controlling left and top coordinates, font size, and font style.

The table resides in the APPS_TS_TX_DATA tablespace with PCT FREE 10, and its indexes reside in APPS_TS_TX_IDX. From a dimensional modeling perspective, heuristic analysis of its foreign-key structure classifies this object as hub-leaning: it holds the durable identity of a label (LABEL_ID together with its SOURCE_TYPE and SOURCE_CODE context) rather than transactional measurements. This classification is a modeling suggestion only; the physical implementation is a standard EBS transactional table with a composite primary key and a non-translated base row per label.

Key Information Stored

The table contains seven documented columns. The most significant are the following:

• LABEL_ID (NUMBER) — Label identifier. Part of the primary key BSC_SYS_LABELS_B_PK and of the business-key unique index BSC_SYS_LABELS_B_U1.
• SOURCE_TYPE (NUMBER) — Identifies the category of the source object to which the label belongs; participates in both the primary key and the unique index.
• SOURCE_CODE (NUMBER) — The tab identifier or indicator code that the label annotates; also part of the primary key and unique index.
• LEFT_POSITION (NUMBER) — The horizontal (left) coordinate at which the label is rendered.
• TOP_POSITION (NUMBER) — The vertical (top) coordinate at which the label is rendered.
• FONT_SIZE (NUMBER) — The numeric font size applied to the label.
• FONT_STYLE (NUMBER) — The numeric code for the label's font style (for example, plain, bold, italic, or a combination), governing appearance rather than content.

The surrogate-style primary key is the composite BSC_SYS_LABELS_B_PK over (LABEL_ID, SOURCE_TYPE, SOURCE_CODE). The unique index BSC_SYS_LABELS_B_U1 covers (SOURCE_TYPE, SOURCE_CODE, LABEL_ID) — a reordering of the same columns that functions as the business-key candidate, ensuring a label is unique within its source context. Translated text for these labels is not stored here; it is held in the companion table BSC_SYS_LABELS_TL, which references this table through SOURCE_CODE.

Common Use Cases and Queries

Typical usage centers on retrieving placement and styling attributes for a given tab or indicator, and on auditing which labels have been customized. A representative query retrieves all label definitions for a source:

• SELECT SOURCE_TYPE, SOURCE_CODE, LABEL_ID, LEFT_POSITION, TOP_POSITION, FONT_SIZE, FONT_STYLE FROM BSC.BSC_SYS_LABELS_B WHERE SOURCE_CODE = :p_source_code;

Because the user search term was "font_style," the most directly relevant query is a styling audit that lists labels by their font characteristics, useful when verifying consistent rendering across scorecard tabs or simulation trees:

• SELECT SOURCE_TYPE, SOURCE_CODE, LABEL_ID, FONT_SIZE, FONT_STYLE FROM BSC.BSC_SYS_LABELS_B WHERE FONT_STYLE = :p_font_style ORDER BY SOURCE_TYPE, SOURCE_CODE;
• SELECT FONT_STYLE, FONT_SIZE, COUNT(*) FROM BSC.BSC_SYS_LABELS_B GROUP BY FONT_STYLE, FONT_SIZE;

Reports commonly join the base table to BSC_SYS_LABELS_TL to combine positioning and styling metadata with the translated label text, and administrators query the table when diagnosing overlapping labels, inconsistent font sizes, or missing captions after a configuration change. Because FONT_SIZE and FONT_STYLE are numeric codes, reporting against them benefits from a lookup of the valid code values used by the BSC rendering layer.

Related Objects

The following objects are the most significant dependencies and integration points for BSC_SYS_LABELS_B:

• BSC.BSC_SYS_LABELS_TL — The translated (language) table holding label text. It references BSC_SYS_LABELS_B through the SOURCE_CODE column and joins on SOURCE_CODE plus LABEL_ID.
• BSC.BSC_SYS_LABELS_B_PK — The primary key constraint over (LABEL_ID, SOURCE_TYPE, SOURCE_CODE), enforcing row identity.
• BSC_SYS_LABELS_B_U1 — The unique index over (SOURCE_TYPE, SOURCE_CODE, LABEL_ID) in APPS_TS_TX_IDX, enforcing the business key.
• APPS.BSC_SYS_LABELS_B — The APPS-layer synonym that application code and reports use to address the table without schema qualification.
• BSC_SYS_LABELS_B (APPS referencing object) — The APPS-registered reference through which BSC application forms, OAF pages, and concurrent programs access the label definitions for tab and simulation tree rendering.

The ETRM metadata records no foreign keys from BSC_SYS_LABELS_B to other tables; it is referenced by, rather than dependent upon, the translation table, which makes it the anchor (hub) for label identity within the BSC label subsystem.