Search Results bsc_tab_view_labels_b_pk

Overview

BSC_TAB_VIEW_LABELS_B is a base table in the BSC (Balanced Scorecard) product module of Oracle E-Business Suite, owned by the BSC schema. It stores tab view label information — the definitions that determine which labels are displayed on scorecard tab views. The "_B" suffix denotes the base (non-translated) table, which is standard Oracle EBS design practice for tables whose display text is subject to multilingual translation via a corresponding "_TL" table.

The table is documented as VALID in ETRM for releases 12.1.1 and 12.2.2, and contains 11 columns. Its primary key, BSC_TAB_VIEW_LABELS_B_PK, is a composite key defined over three columns: TAB_ID, TAB_VIEW_ID, and LABEL_ID. A unique index, BSC_TAB_VIEW_LABELS_B_U1, is defined over the same three columns, confirming that this combination is the business-key candidate. The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning the object does not exhibit strong hub, link, or satellite characteristics relative to other documented BSC tables. When modeling for analytical or data-warehouse purposes, this table may be treated as an independent reference or configuration entity rather than as a dependent of a shared hub.

Key Information Stored

The table captures the assignment of labels to tab views within a Balanced Scorecard tab. The most significant columns are:

• TAB_ID — Identifier of the tab to which the label belongs; part of the primary key and unique index.
• TAB_VIEW_ID — Identifier of the specific tab view within the tab; part of the primary key and unique index.
• LABEL_ID — Identifier of the label associated with the tab view; part of the primary key and unique index.
• LABEL_TYPE — Classifies the label (for example, to distinguish functional label roles within the tab view rendering).
• LINK_ID — Reference to a link target associated with the label, supporting navigational behavior from the tab view.
• FUNCTION_ID — Reference to a function associated with the label, typically used for menu/function security or navigation context.
• CREATED_BY, CREATION_DATE — Standard WHO columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO columns recording the last modifying user, timestamp, and login.

The surrogate primary key is represented by the composite BSC_TAB_VIEW_LABELS_B_PK; because its columns coincide with those of the unique index, the primary key and the business-key candidate are the same set (TAB_ID, TAB_VIEW_ID, LABEL_ID). Optional descriptive attributes are LABEL_TYPE, LINK_ID, and FUNCTION_ID, while the WHO columns provide audit lineage.

Common Use Cases and Queries

Typical usage centers on reporting and validating which labels appear on each tab view, and on resolving label-to-function or label-to-link navigation targets. A common query retrieves all labels for a given tab view:

• Filter by TAB_ID and TAB_VIEW_ID to list the LABEL_ID and LABEL_TYPE values configured for that view.
• Join on LABEL_ID to the corresponding translation table (an "_TL" companion, following the "_B"/"_TL" pattern) to obtain language-specific display text for reporting.
• Join FUNCTION_ID to the application function definition to map labels to their underlying navigation or form invocation.
• Join LINK_ID to the associated link object to trace where a label navigates.
• Audit queries using CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to identify recent configuration changes to tab view labels.

Because the object is standalone per the heuristic classification, queries generally do not need to traverse a wide foreign-key chain; direct lookups by the composite key are efficient and represent the typical access path.

Related Objects

The following objects are significant to working with this table, based on the documented key structure and Oracle EBS conventions:

• BSC_TAB_VIEW_LABELS_B_PK — Primary key constraint over (TAB_ID, TAB_VIEW_ID, LABEL_ID).
• BSC_TAB_VIEW_LABELS_B_U1 — Unique index over (TAB_ID, TAB_VIEW_ID, LABEL_ID), the business-key candidate.
• BSC_TAB_VIEW_LABELS_TL — Companion translation table keyed by the same identifiers, supplying language-specific label text.
• BSC_TAB_VIEWS — Parent definition of tab views; joined via TAB_ID and TAB_VIEW_ID.
• BSC_TABS — Tab definition; joined via TAB_ID.
• FND_FORM_FUNCTIONS — Application function catalog; joined via FUNCTION_ID.
• Link-related BSC objects referenced via LINK_ID for navigational targets.

For direct data access, DBA and development staff may reference BSC.BSC_TAB_VIEW_LABELS_B and its indexes, and supplement their understanding with the standard WHO audit columns present on the table.