Search Results bsc_user_parameters_tl

Overview

The BSC_USER_PARAMETERS_TL table resides in the BSC (Balanced Scorecard) schema and stores translation-layer (TL) records for indicator data associated with information boxes in Oracle E-Business Suite. As a multilingual companion table, it holds language-specific descriptive attributes—most notably the display title—for parameter list definitions consumed by Balanced Scorecard dashboards, scorecards, and information box indicators. In Oracle EBS 12.1.1 and 12.2.2, TL tables are paired with a base (non-suffixed) table; the base table stores language-independent columns while the _TL table stores the translatable text, keyed by both the entity identifier and LANGUAGE.

The documented primary key is BSC_USER_PARAMETERS_TL_PK, composed of LANGUAGE and PARAM_LIST_ID. A secondary unique index, BSC_USER_PARAMETERS_TL_U1, covers PARAM_LIST_ID and LANGUAGE, confirming the business-key candidate that guarantees one translatable row per parameter list per installed language. Applying a heuristic Data Vault classification, the ETRM relationship metadata marks this object as standalone, meaning it exposes no mined foreign key dependencies. From a modeling perspective, this suggests treating BSC_USER_PARAMETERS_TL as a satellite-like construct anchored to a parent parameter-list hub (the base table), rather than as an independent hub or link. The classification is a suggestion only; the physical EBS schema does not enforce Data Vault semantics.

Key Information Stored

The table comprises nine documented columns. The most important are:

• PARAM_LIST_ID — the identifier of the parameter list to which the translated text belongs; part of the composite primary key and the leading column of the unique business key.
• LANGUAGE — the language code for the row's translated content; the second component of the primary key, ensuring one row per language per parameter list.
• SOURCE_LANG — the language of the source (base) text, used by the translation framework to identify the origin language for the translation pair.
• TITLE — the translated display title presented to end users in the Balanced Scorecard information box; this is the principal user-facing attribute of the TL layer.

The remaining columns are standard EBS WHO/audit attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN, which record insert and update provenance and support concurrent-program and audit reporting. The surrogate primary key (LANGUAGE, PARAM_LIST_ID) should be distinguished from the business-key candidate expressed by the unique index BSC_USER_PARAMETERS_TL_U1, which enforces the same pair at the logical level.

Common Use Cases and Queries

Typical uses include resolving the correct localized title for a parameter list at report runtime, auditing translation completeness across languages, and feeding multilingual scorecard rendering. A common pattern joins the TL row to its base object using PARAM_LIST_ID and restricts by the session language:

• Retrieve a localized title: SELECT title FROM bsc_user_parameters_tl WHERE param_list_id = :id AND language = USERENV('LANG');
• Detect missing translations: compare distinct PARAM_LIST_ID values across languages to identify gaps where no row exists for a given LANGUAGE.
• Audit translation currency: query LAST_UPDATE_DATE, LAST_UPDATED_BY, and SOURCE_LANG to verify which rows were updated after a source-language change.
• Bulk extract for ETL: SELECT param_list_id, language, title, last_update_date FROM bsc_user_parameters_tl ORDER BY param_list_id, language;

Reporting should always join back to the base parameter table to avoid duplicate titles when multiple languages are installed.

Related Objects

The metadata documents this object as standalone with no mined foreign keys, so relationships below are inferred from standard TL architecture and the BSC module's information-box framework:

• BSC_USER_PARAMETERS (base table) — joins on PARAM_LIST_ID; supplies the language-independent parameter definitions.
• BSC_USER_PARAMETERS_TL_PK — the primary key constraint (LANGUAGE, PARAM_LIST_ID).
• BSC_USER_PARAMETERS_TL_U1 — the unique business-key index (PARAM_LIST_ID, LANGUAGE).
• FND_LANGUAGES — validates the LANGUAGE and SOURCE_LANG values against installed EBS languages.
• FND_USER — resolves CREATED_BY and LAST_UPDATED_BY to user names for audit reporting.
• BSC_PARAMETER_LISTS / related BSC information-box tables — participate in the Balanced Scorecard indicator configuration that consumes parameter lists.

Because the ETRM record is limited to schema and key data, these related objects should be verified against the specific 12.1.1 or 12.2.2 instance before reliance in production queries.