Search Results bsc_sys_dim_groups_vl




Overview
Explore in AI Chat

Overview

BSC_SYS_DIM_GROUPS_VL is a view in the Oracle E-Business Suite Balanced Scorecard (BSC) product. As indicated by its product designation, the module is obsolete in the EBS 12.1.1 and 12.2.2 release streams, and the object is no longer in active use. The view is documented in the ETRM metadata with the simple description "View of BSC_SYS_DIM_GROUPS_TL." The "_VL" suffix follows Oracle's standard naming convention for views that expose translated (language-specific) descriptive columns, sourced from the corresponding "_TL" (translation) table. The view presents a single translatable attribute, NAME, alongside the primary key of the parent dimension group record, filtered to the language of the current user session. Its role historically was to support reporting and integration against Balanced Scorecard system dimension groups by surfacing the user's preferred language version of each group name without requiring callers to join the translation table explicitly.

Underlying Base Objects

The view text documented in the ETRM metadata states: SELECT DIM_GROUP_ID, NAME FROM BSC_SYS_DIM_GROUPS_TL WHERE LANGUAGE = USERENV('LANG'). Accordingly, the sole underlying base object is the translation table BSC_SYS_DIM_GROUPS_TL. The view does not expose any untranslated columns from a companion "_B" or "_B_ANY" table within its own definition; it simply projects the primary key and the translated name from the translation table and restricts rows to those matching the current session language. The ETRM metadata lists no documented referenced base objects and leaves the owner field blank, consistent with its classification as obsolete and "not implemented in this database." Parties relying on this object should note that existence of the view in a given instance is not guaranteed.

Key Columns

  • DIM_GROUP_ID — The identifier of the system dimension group. This is the primary key linking each translated row to its parent dimension group definition.
  • NAME — The translated display name of the dimension group, resolved for the language specified by the current user environment through the LANGUAGE filter on BSC_SYS_DIM_GROUPS_TL.

The view exposes only these two columns; there are no additional descriptive, audit, or lifecycle columns present in its projection.

Common Use Cases and Queries

Because the object belongs to an obsolete product and is documented as not implemented in this database, direct querying is primarily of interest to historical support, migration analysis, or inventory scripts that catalog EBS database objects. Where the view is present, a typical query retrieves the list of dimension group names visible to the current user's language:

  • Retrieve all visible dimension groups: SELECT DIM_GROUP_ID, NAME FROM BSC_SYS_DIM_GROUPS_VL ORDER BY NAME;
  • Resolve a single dimension group by identifier: SELECT DIM_GROUP_ID, NAME FROM BSC_SYS_DIM_GROUPS_VL WHERE DIM_GROUP_ID = :p_dim_group_id;
  • Search groups by partial name: SELECT DIM_GROUP_ID, NAME FROM BSC_SYS_DIM_GROUPS_VL WHERE UPPER(NAME) LIKE UPPER('%' || :p_search || '%');

In each case, the LANGUAGE = USERENV('LANG') predicate embedded in the view ensures that only rows matching the session's language are returned, so callers need not add language filtering themselves. Any deployment considering reuse of this view should first confirm its presence in the target instance and treat the obsolete BSC module as non-supported for new development.