Search Results update_kpi_analysis_options_b

Overview

BSC_DIMENSION_SETS_PVT is a private PL/SQL package in the APPS schema that supports the dimension-set and dimension-level configuration framework of Oracle Enterprise Planning and Budgeting / Balanced Scorecard (BSC) within Oracle E-Business Suite. The package encapsulates the low-level business logic that creates, retrieves, updates, and deletes the dimensional definitions used to organize Key Performance Indicators (KPIs) into analysis groups. It operates as the implementation layer beneath the public API BSC_DIMENSION_SETS_PUB, which exposes the corresponding public entry points to forms, concurrent programs, and integration code. Because its classification is PVT, the package is intended to be invoked only through the public wrapper; direct calls from custom code are discouraged and unsupported.

The package participates in the broader KPI dimensional model, where scorecard KPIs can be sliced and grouped across user-defined dimensions and levels. It validates input, applies the standard FND_API error-handling and message conventions, and performs the DML against the underlying BSC configuration tables. As documented in the ETRM repository, the object is VALID in the APPS schema and is referenced by BSC_DIMENSION_SETS_PUB, BSC_KPI_PUB, and BSC_PMF_UI_WRAPPER, confirming its role as a shared internal service within the BSC subsystem.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions, organized around four logical groups of operations.

• Dimension group operations: CREATE_DIM_GROUP_IN_DSET, RETRIEVE_DIM_GROUP_IN_DSET, UPDATE_DIM_GROUP_IN_DSET, and DELETE_DIM_GROUP_IN_DSET manage the association of dimension groups within a dimension set.
• Translated dimension set operations: CREATE_BSC_KPI_DIM_SETS_TL, RETRIEVE_BSC_KPI_DIM_SETS_TL, UPDATE_BSC_KPI_DIM_SETS_TL, and DELETE_BSC_KPI_DIM_SETS_TL maintain the language-dependent (TL) descriptive rows for KPI dimension sets.
• Dimension level properties: CREATE_DIM_LEVEL_PROPERTIES, RETRIEVE_DIM_LEVEL_PROPERTIES, UPDATE_DIM_LEVEL_PROPERTIES, and DELETE_DIM_LEVEL_PROPERTIES define and maintain attributes attached to individual dimension levels.
• Dimension levels: CREATE_DIM_LEVELS, RETRIEVE_DIM_LEVELS, UPDATE_DIM_LEVELS, and DELETE_DIM_LEVELS manage the level definitions themselves.
• Analysis options: UPDATE_KPI_ANALYSIS_OPTIONS_B modifies the base-table analysis options associated with KPI groups.

Across each group, the RETRIEVE routines supply the read access required by the public API, while the CREATE, UPDATE, and DELETE routines implement the transactional lifecycle of the dimension configuration.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• BSC_KPI_DIM_SETS_TL — translated dimension set descriptions.
• BSC_KPI_DIM_GROUPS and BSC_KPI_DIM_LEVEL_PROPERTIES — dimension group and level property configuration.
• BSC_KPI_DIM_LEVELS_B, BSC_KPI_DIM_LEVELS_TL, and BSC_KPI_DIM_LEVELS_USER — base, translated, and user-level dimension level definitions.
• BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_TL — seeded system dimension levels.
• BSC_KPIS_B and BSC_KPI_ANALYSIS_GROUPS and BSC_KPI_ANALYSIS_OPTIONS_B — KPI and analysis group/option data updated by UPDATE_KPI_ANALYSIS_OPTIONS_B.
• FND_LANGUAGES — used to resolve the active language for the TL tables.

Usage Notes

BSC_DIMENSION_SETS_PVT is invoked indirectly. UI actions in the Balanced Scorecard / KPI setup forms call BSC_DIMENSION_SETS_PUB, which in turn delegates to the private routines here. Concurrent programs and Java or PL/SQL integrations that configure dimension sets also traverse the public package, which is the supported entry point. Because BSC_KPI_PUB and BSC_PMF_UI_WRAPPER depend on this private package, changes require regression testing across the KPI and PMF flows. Direct calls to BSC_DIMENSION_SETS_PVT are not supported and may break in future releases.