Search Results bsc_dimension_sets_pub




Overview
Explore in AI Chat

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.

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:

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.