Search Results bsc_user_parameters_tl_u1

Overview

BSC.BSC_USER_PARAMETERS_TL is a translation (TL) table in the Oracle EBS Balanced Scorecard (BSC) product family, owned by the BSC schema and registered in FND Design Data as BSC.BSC_USER_PARAMETERS_TL. The table stores the language-specific descriptive text associated with parameter lists used by portlets and dashboard regions. In a multilanguage EBS deployment, the base record for a parameter list resides in a corresponding non-translated table, while this table supplies the translated TITLE attribute for each installed language, enabling the same portlet configuration to display localized captions to users with different language preferences.

From a Data Vault modeling perspective, the mined relationship data classifies this object as standalone, with no foreign key dependencies. This suggests it is best treated as a reference or lookup structure rather than a transaction hub or link. Its role is descriptive and subordinate; it enriches a parent configuration entity with translated labels rather than recording business events.

Key Information Stored

The table contains nine documented columns. The most significant are:

• PARAM_LIST_ID (NUMBER) — Identifier of the parameter list to which the translated title belongs. This is the primary business-key component and the principal join key back to the parent parameter list entity.
• LANGUAGE (VARCHAR2) — Language code identifying the locale in which the title is expressed. Together with PARAM_LIST_ID it forms the composite primary key BSC_USER_PARAMETERS_TL_PK and the unique index BSC_USER_PARAMETERS_TL_U1.
• SOURCE_LANG (VARCHAR2) — The source language from which the current translation was derived, used by EBS translation tooling to track linguistic lineage.
• TITLE (VARCHAR2, length 100) — The translated display title or caption for the parameter list, shown to end users on portlet and dashboard pages.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN, which record audit and concurrency information for each translation row.

The surrogate primary key is the composite (LANGUAGE, PARAM_LIST_ID), while the unique index BSC_USER_PARAMETERS_TL_U1 covers (PARAM_LIST_ID, LANGUAGE) and serves as the documented business-key candidate. Both enforce the rule that exactly one title exists per parameter list per language.

Common Use Cases and Queries

Typical usage centers on localized display of portlet parameter configuration. Reporting and validation queries commonly join this table to the base parameter list table on PARAM_LIST_ID and filter by a specific LANGUAGE or SOURCE_LANG value. A representative pattern:

• Retrieve all translated titles for a given parameter list: SELECT PARAM_LIST_ID, LANGUAGE, TITLE FROM BSC.BSC_USER_PARAMETERS_TL WHERE PARAM_LIST_ID = :p_id.
• Detect missing or untranslated rows by comparing available LANGUAGE codes against the set of installed languages in FND_LANGUAGES.
• Audit translation changes using LAST_UPDATE_DATE and LAST_UPDATED_BY to identify who modified a title and when.
• Trace translation origin using SOURCE_LANG when reconciling patches or language installations.

Because the table is populated largely through EBS translation and patching mechanisms, direct DML is uncommon; most customization occurs through the application configuration or the underlying base table.

Related Objects

The metadata documents that BSC_USER_PARAMETERS_TL does not reference any database object and is referenced by the APPS synonym BSC_USER_PARAMETERS_TL. The most significant related objects include:

• BSC_USER_PARAMETERS_B — the base (non-translated) parameter list table; join on PARAM_LIST_ID to obtain configuration attributes alongside translated titles.
• BSC_USER_PARAMETERS_TL_U1 — the unique index supporting language-specific lookups.
• BSC_USER_PARAMETERS_TL_PK — the composite primary key on (LANGUAGE, PARAM_LIST_ID).
• FND_LANGUAGES — reference table validating the LANGUAGE and SOURCE_LANG values.
• APPS.BSC_USER_PARAMETERS_TL — the APPS synonym through which application code and reports access the table.

Consumers should treat BSC_USER_PARAMETERS_TL as a read-oriented translation satellite, joining to its base table for complete parameter list metadata.