Search Results upgrade_bsc_pmf_dim_views

Overview

BSC_UPGRADES is a PL/SQL upgrade utility package in the APPS schema that supports the Oracle Balanced Scorecard (BSC) application within Oracle E-Business Suite. Its principal role is to reconcile and migrate metadata between the legacy Balanced Scorecard (BSC) data model and the Performance Management Framework (PMF) — the successor architecture introduced during the transition to Oracle EBS Release 12. The package orchestrates the synchronization of measures, dimensions, dimension objects, levels, and multilingual (translated) attributes so that existing scorecard definitions remain valid after the upgrade to the PMF-based Analytics engine.

The package is part of the upgrade and migration infrastructure rather than day-to-day transactional processing. It bridges the older BIS/BSC repository tables and the newer BSC/PMF structures, applying language-specific synchronization, adjusting profile options, provisioning access to launchpads, and managing view definitions used by the dimensional model. Because BSC_UPGRADES is categorized under the "OTHER" API classification, it is intended for controlled administrative execution during upgrades, patching, and one-time migration rather than for general application integration.

Key Procedures and Functions

The package exposes approximately twenty documented procedures and functions organized around four functional themes:

• Measure synchronization: SYNCHRONIZE_MEASURES, LANG_SYNCH_BSC_TO_PMF_MEASURE, LANG_SYNCH_PMF_TO_BSC_MEASURE, and LANG_SYNCH_EXISTING_MEASURES migrate and align measure definitions and their translated descriptions between the BSC and PMF repositories.
• Dimension and dimension-object synchronization: LANG_SYNCH_BSC_TO_PMF_DIMOBJ, LANG_SYNCH_PMF_TO_BSC_DIMOBJ, LANG_SYNCH_BSC_TO_PMF_DIM, and LANG_SYNCH_PMF_TO_BSC_DIM handle bidirectional language-aware migration of dimensions and dimension objects.
• View and schema maintenance: UPGRADE_BSC_PMF_DIM_VIEWS, REMOVE_BSC_PMF_EDW_DIM_VIEWS, and DROP_UPDATE_DIM_OBJ_VIEWS create, replace, or drop dimensional views supporting the PMF/EDW layer.
• Configuration and cleanup utilities: GETUNIQUEDISPLAYNAME resolves naming conflicts; UPGRADE_ADVANCED_PROFILE sets profile options; ADD_ACCESS_TO_LAUNCHPADS grants launchpad access; UPDATE_BSC_APPLICATION_IDS, UPDATE_DIM_HIDE_PROPERTIES, and HIDE_UNUSED_IMPORT_DIM adjust application identifiers and visibility flags for dimensions.

Tables Accessed

Through APPS synonyms, the package reads and writes the core BIS and BSC metadata tables that define the scorecard model. BIS_APPLICATION_MEASURES, BIS_INDICATORS, and BIS_INDICATORS_TL hold indicator and measure definitions with translations; BIS_DIMENSIONS, BIS_DIMENSIONS_TL, BIS_LEVELS, and BIS_LEVELS_TL define dimensions and their hierarchies. On the BSC/PMF side, BSC_KPIS_B, BSC_KPI_DIM_GROUPS, and BSC_KPI_DIM_LEVELS_B store KPI and dimensional groupings, while BSC_SYS_DATASETS_B, BSC_SYS_DATASETS_TL, BSC_SYS_DIM_GROUPS_TL, BSC_DB_MEASURE_COLS_TL, and BSC_DB_TABLES_RELS hold dataset, column, and table-relationship metadata. These tables are accessed specifically to migrate or reconcile definitions between the legacy and current models.

Usage Notes

BSC_UPGRADES is invoked during upgrade, patch, and migration activities rather than through standard concurrent programs or forms. It is referenced by the BSC_MIGRATION package, which serves as the driver orchestrating upgrade sequencing, and it calls supporting APIs including BIS_MEASURE_PUB, BIS_UTILITIES_PUB, BSC_DATASETS_PUB, and FND_API for standard error handling and concurrent processing. Because the package manipulates core metadata, executes as the APPS schema, and depends on FND_TABLE_OF_VARCHAR2_30 and STANDARD, it should be executed only through Oracle-supplied upgrade scripts or, in rare cases, controlled custom migration code. Direct invocation outside a supported upgrade path risks inconsistent BSC/PMF metadata.