Search Results bsc_pmf_ui_api_pub




Overview
Explore in AI Chat

Overview

APPS.BSC_PMF_UI_API_PUB is a public PL/SQL package body in the Oracle E-Business Suite Balanced Scorecard (BSC) product family. It serves as the user interface application programming interface for the Performance Management Framework (PMF), exposing the business logic used by the Balanced Scorecard design-time and analysis configuration pages to create and maintain the analytical structures that underlie scorecard content. In practical terms, this package mediates between the browser-based PMF Designer user interface and the underlying BSC repository tables, allowing users to define datasets, dimensions, dimension sets, dimension levels, and analysis options without directly manipulating the repository. The package is classified as a PUB API, indicating it is an advertised, callable interface rather than a private implementation detail. Its status is VALID, and it depends on supporting packages such as BSC_DESIGNER_PVT, BSC_DATASETS_PUB, BSC_DIMENSION_GROUPS_PUB, BSC_DIMENSION_LEVELS_PUB, BSC_DIMENSION_SETS_PUB, BSC_ANALYSIS_OPTION_PUB, BSC_BIS_MEASURE_PUB, BSC_BIS_WRAPPER_PVT, and BSC_UTILITY.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions within this package body, covering creation, update, and display-name resolution responsibilities:

Tables Accessed

The package reads and writes repository tables through APPS synonyms. It maintains dataset definitions in BSC_SYS_DATASETS_B, dimension level definitions in BSC_SYS_DIM_LEVELS_B, measures in BSC_SYS_MEASURES, and analysis configuration in BSC_KPI_ANALYSIS_MEASURES_B, BSC_KPI_ANALYSIS_OPTIONS_B, and BSC_KPI_DIM_SETS_TL. It reads BIS_INDICATORS, BIS_INDICATORS_TL, and the BIS dimension/level views (BISFV_DIMENSIONS, BISFV_DIMENSION_LEVELS, BISBV_DIMENSION_LEVELS) for indicator and dimension metadata. Region/UI metadata is read from AK_REGIONS and AK_REGION_ITEMS, language information from FND_LANGUAGES, and utility objects such as PLITBLM and USER_OBJECTS support string handling and object existence checks. Message handling uses FND_MESSAGE and FND_MSG_PUB via FND_API.

Usage Notes

This package is typically invoked indirectly through the Balanced Scorecard PMF Designer and related HTML-based configuration pages, rather than by end users directly. Developers extending PMF functionality may call its public procedures from custom PL/SQL, but should be aware that the API expects the same parameter and message conventions used by the shipped Designer flow. The metadata records no inbound references from other database objects, confirming it is a top-level interface rather than a shared internal library. Because behavior can differ between EBS 12.1.1 and 12.2.2, any custom integration should be validated against the target release, and the FND_MSG_PUB message stack should be checked after each call to surface validation errors.