Search Results resequence_dim_level_values

Overview

APPS.BIS_PMF_MIGRATION_PVT is a private PL/SQL package in Oracle EBS that performs one-time data migration and dimensional re-sequencing for the Performance Management Framework (PMF) / Balanced Scorecard indicator data model. It was created in July 2000 and later modified in June 2004 through bug fix 3583357 to add logic for re-sequencing dimensions within BIS_INDICATOR_DIMENSIONS based on the dimensional level order defined in BIS_TARGET_LEVELS. The package is designated with an API classification of PVT, meaning it is an internal, private interface not intended for direct customer invocation. Its scope covers migrating legacy performance measures and indicator definitions into the current schema, and then maintaining consistency of the dimension level identifiers that structure how indicators are sliced by organizational, time, and user-defined dimensions.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

• MIGRATE_PERFORMANCE_MEASURES — migrates performance measure data into the current PMF model.
• MIGRATE_INDICATOR_DIMENSIONS — migrates indicator dimension definitions; this is the procedure most directly associated with the search term migrate_indicator_dimensions.
• RESEQUENCE_DIMENSION_LEVELS — re-orders dimension levels according to the order held in BIS_TARGET_LEVELS.
• RESEQUENCE_DIM_LEVEL_VALUES — re-sequences dimension level values to match the level ordering.
• RESEQUENCE_IND_LEVEL_VALUES — re-sequences indicator level values to match the level ordering.
• RESEQUENCE_IND_DIMENSIONS — re-sequences the indicator dimension rows themselves.
• UPDATE_BIS_INDICATORS — applies corrections or updates to indicator records.
• NEED_RESEQUENCE — evaluates whether a given indicator or dimension set requires re-sequencing.
• NEEDS_MIGRATION — determines whether migration is required for a given data set.
• GET_DIMENSION_ID — retrieves a dimension identifier used during migration or sequencing.

Together these procedures implement both the seed-set migration and the corrective re-sequencing logic introduced by the 2004 bug fix.

Tables Accessed

The package reads and writes the following tables through APPS synonyms: BIS_INDICATORS (indicator definitions), BIS_TARGET_LEVELS (dimensional level definitions for each target), BIS_TARGET_VALUES (target outcomes at each level combination), BIS_ACTUAL_VALUES (actual results), BIS_INDICATOR_DIMENSIONS (the mapping between indicators and their dimensions), BIS_LEVELS (level master data), BIS_USER_IND_SELECTIONS (user-specific indicator selections), and PLITBLM (the PL/SQL index-by table helper). The migration procedures populate the indicator and dimension tables, while the resequence procedures align level values in BIS_TARGET_VALUES, BIS_ACTUAL_VALUES, and dimension tables to the ordering defined by BIS_TARGET_LEVELS.

Usage Notes

Because APPS.BIS_PMF_MIGRATION_PVT is classified as PVT, it is not a public API and is not intended for direct execution by end users. It is typically invoked internally during upgrade or data-migration routines that introduce legacy PMF data into the current schema, and by the single dependent package documented in the ETRM metadata. Administrators encountering dimensional ordering issues in BIS_INDICATOR_DIMENSIONS following migration should recognize that this package is the component responsible for aligning those rows to the BIS_TARGET_LEVELS order. Custom code should not call it directly; instead, use the supported migration or upgrade path provided by Oracle for the corresponding EBS release.