Search Results param_list_id




Overview
Explore in AI Chat

Overview

APPS.BSC_USER_PARAMETERS_PKG is a PL/SQL package body that manages the persistence of user-defined parameter lists used by the Oracle Balanced Scorecard (BSC) user interface views and related analytical components. These parameter lists act as reusable configuration records that capture how a scorecard indicator or dashboard view should be assembled, including the analysis measures, up to ten dimension selections, the time period, data series, calculations, and benchmark definitions. In Oracle EBS 12.1.1 and 12.2.2, this package provides the standard insert, update, delete, and translation operations that let the application store and maintain these user parameter definitions in a structured, language-aware manner. It abstracts the underlying table manipulation behind a clean API surface, ensuring that sequence-generated primary keys, audit columns, and translated title text are handled consistently across all callers.

Key Procedures and Functions

The package exposes five documented procedures forming a complete CRUD-with-translation API:

  • INSERT_ROW — Creates a new user parameter list record. It generates a new PARAM_LIST_ID from the BSC_USER_PARAM_LIST_ID_S sequence, inserts the business and configuration columns into the base table, and returns the generated identifier through its out parameter.
  • UPDATE_ROW — Modifies an existing parameter list, updating the measure, dimension, time period, data series, calculation, benchmark, and audit fields for a given PARAM_LIST_ID.
  • DELETE_ROW — Removes a parameter list from the base table, typically invoked when a user deletes a saved view configuration.
  • ADD_LANGUAGE — Inserts a translated row into the translation table for a specific parameter list and language, supporting the multi-language requirement of the BSC UI.
  • TRANSLATE_ROW — Updates the translated title (and related translatable text) of an existing parameter list row, allowing localized presentation without altering the base configuration.

Tables Accessed

The package operates against a small, well-defined set of objects referenced through APPS synonyms:

  • BSC_USER_PARAMETERS_B — The base table holding the core, language-independent parameter list definition, including APPLICATION_ID, INDICATOR, VIEW_TYPE, VALID_FLAG, the ten DIMENSION columns, and audit columns.
  • BSC_USER_PARAMETERS_TL — The translation table that stores the language-specific TITLE, keyed by PARAM_LIST_ID and language.
  • BSC_USER_PARAM_LIST_ID_S — The sequence supplying unique PARAM_LIST_ID values during inserts.
  • FND_LANGUAGES — The standard Oracle Application Object Library languages table, referenced for valid language validation and translation handling.

Usage Notes

This package is part of the internal Balanced Scorecard framework and is invoked primarily by the BSC user interface forms and associated application logic rather than by end users directly. Because the header records the package as first shipped in 2003 (BSCUVIWB.pls 115.7), it is a long-standing component present in both 12.1.1 and 12.2.2 environments without architectural change. Customizations and integrations should call the documented procedures rather than issuing direct DML against the underlying tables, since the API enforces sequence generation, audit stamping, and translation consistency. Developers extending BSC functionality, migrating parameter definitions, or building batch utilities that seed saved views for users should invoke INSERT_ROW, UPDATE_ROW, and DELETE_ROW within a properly committed transaction, supplying all audit context (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN). Translation-related operations should pair ADD_LANGUAGE and TRANSLATE_ROW for each supported language installed in FND_LANGUAGES. One other package references this API, confirming that it functions as a shared building block within the BSC module; dependency-aware impact analysis should account for that relationship before any modification or patching.