Search Results data_series




Overview
Explore in AI Chat

Overview

APPS.BSC_USER_PARAMETERS_VL is a language-resolved (multilingual) view owned by the APPS schema in Oracle E-Business Suite. It exposes the user-defined parameter list definitions used by Oracle Balanced Scorecard (BSC), a component of the Enterprise Performance Foundation / ETRM reporting stack. The view presents the "VL" (translated) form of parameter list data, meaning it resolves language-specific descriptive values at query time while retaining the non-translated structural columns. Records carry a VALID_FLAG and standard audit columns, and the view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

Within Oracle EBS reporting and integration, BSC_USER_PARAMETERS_VL serves as the supported read interface for parameter list metadata. Report builders, OBIEE or Discoverer data models, and custom concurrent programs use it to retrieve parameter list definitions without having to join translation tables directly. Because it is a view rather than a table, it enforces the language-joining logic centrally, and its structure remains consistent across patch releases.

Underlying Base Objects

The view is defined over two base tables, as documented in the ETRM dependency information:

The "VL" view joins the translated rows from BSC_USER_PARAMETERS_TL to the non-displayed data in BSC_USER_PARAMETERS_B, filtering to the language installed and active at the site. In EBS 12.1.1 and 12.2.2 this is the standard multilingual view pattern (base table, _TL table, _VL view). ETRM documentation notes that APPS.BSC_USER_PARAMETERS_VL references the two base tables above and is not referenced by any other database object — it is a terminal, read-only interface.

Key Columns

The view exposes the following columns (as documented in ETRM):

  • PARAM_LIST_ID (NUMBER) — primary identifier of the parameter list.
  • TITLE (VARCHAR2 100) — the translated, language-resolved name shown to users.
  • APPLICATION_ID (NUMBER) — owning EBS application.
  • INDICATOR, VIEW_TYPE, VALID_FLAG (NUMBER) — control attributes determining how the parameter list is rendered and whether it is active.
  • ANALYSIS_MEASURES (VARCHAR2 80) — specifies the analysis measure parameters associated with the list; this is the column most commonly returned when validating measure configuration.
  • DIMENSION1 … DIMENSION10 (VARCHAR2 80 each) — ten dimension slots defining the parameter list's dimensional structure.
  • TIME_PERIOD, DATA_SERIES, CALCULATIONS, BENCHMARKS (VARCHAR2 80 each) — parameter slots for time, data series, calculation, and benchmark selections.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing which parameter lists exist, confirming the ANALYSIS_MEASURES definition for a list, and feeding BI data models with translated titles.

List all valid parameter lists with their translated titles:

  • SELECT PARAM_LIST_ID, TITLE, APPLICATION_ID FROM APPS.BSC_USER_PARAMETERS_VL WHERE VALID_FLAG = 1 ORDER BY TITLE;

Retrieve the analysis measures and dimensional layout for a specific list:

  • SELECT PARAM_LIST_ID, TITLE, ANALYSIS_MEASURES, DIMENSION1, DIMENSION2 FROM APPS.BSC_USER_PARAMETERS_VL WHERE PARAM_LIST_ID = :p_id;

Search for lists referencing a given measure string:

  • SELECT PARAM_LIST_ID, TITLE, ANALYSIS_MEASURES FROM APPS.BSC_USER_PARAMETERS_VL WHERE ANALYSIS_MEASURES LIKE '%' || :search_term || '%';

Because the view is a language-resolved join, TITLE reflects the session's language; parties needing all languages should query BSC_USER_PARAMETERS_TL directly. Note that "analysis_measures" is not a standalone object — it corresponds to the ANALYSIS_MEASURES column exposed by this view.