Search Results bsc_copy_indicator_pub




Overview
Explore in AI Chat

Overview

BSC_COPY_INDICATOR_PUB is a public PL/SQL package in the APPS schema that supports the Oracle Balanced Scorecard (BSC) module, part of the Oracle E-Business Suite performance management family. Its primary business function is to manage the duplication and relocation of indicators (KPIs) and their associated configuration between scorecards and tabs. In Balanced Scorecard terminology, an "indicator" is a measured performance metric that draws data from an underlying KPI definition. Because KPI definitions carry substantial configuration — analysis measures, dimensions, periodicities, properties, and tab placements — reusing an existing indicator rather than rebuilding it manually is a frequent administrative requirement. This package provides the programmatic foundation for that copy and move capability, exposed through the public API entry points that the BSC user interface and related public packages call.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions in the package. Descriptions follow the documented names; parameter signatures are not enumerated here because they are not part of the published metadata.

  • COPYNEW_INDICATOR_UI_WRAP — A UI-oriented wrapper procedure that supports creating a new indicator as a copy of an existing one. It is the entry point invoked when a user chooses a "copy" action from the scorecard interface.
  • MOVE_INDICATOR_UI_WRAP — A UI-oriented wrapper procedure that supports relocating an existing indicator, typically from one scorecard tab or grouping to another, while preserving its definition and data associations.
  • MOVE_INDICATOR — The core (non-wrapper) procedure that performs the underlying move logic invoked by the UI wrapper.
  • CREATE_KPI_ACCESS_WRAP — A wrapper procedure that establishes access or linkage records required for the copied or moved KPI, ensuring the destination context can reference the indicator.
  • IS_NUMERIC_FIELD_EQUAL — A utility function that compares two numeric field values for equality, used in validation or duplicate-detection logic.
  • IS_VARCHAR2_FIELD_EQUAL — A utility function that compares two character field values for equality, complementing the numeric comparison utility.

Tables Accessed

Through APPS synonyms, the package reads and writes the core Balanced Scorecard configuration tables. BSC_KPIS_B and BSC_KPIS_TL hold the base and translated KPI definitions. BSC_KPI_ANALYSIS_MEASURES_B and BSC_KPI_ANALYSIS_MEASURES_TL store the analysis measures attached to a KPI. BSC_KPI_DIM_GROUPS, BSC_KPI_DIM_LEVELS_B, and BSC_KPI_DIM_LEVEL_PROPERTIES define the dimension groups, dimension levels, and their properties. BSC_KPI_PERIODICITIES and BSC_SYS_PERIODICITIES hold periodicity definitions, while BSC_KPI_PROPERTIES and BSC_KPI_DATA_TABLES capture KPI properties and source data table mappings. BSC_TABS_B records tab placement, BSC_SYS_DIM_LEVELS_B stores system-level dimension level definitions, BSC_SYS_DATASETS_TL holds translated dataset names, and AK_REGIONS supplies the region metadata used by the UI-facing wrappers. Collectively these tables represent the full dependency set that must be considered when an indicator is copied or moved.

Usage Notes

This package is a public API (the _PUB suffix confirms its supported status). It is normally invoked indirectly: the Balanced Scorecard forms call the UI wrapper procedures (COPYNEW_INDICATOR_UI_WRAP and MOVE_INDICATOR_UI_WRAP), which in turn drive the core procedures. It depends on FND_API and the FND_TABLE_OF_NUMBER and STANDARD constructs, and it is referenced by BSC_KPI_SERIES_PUB, indicating use within the broader KPI series processing flow. In Oracle EBS 12.1.1 and 12.2.2 the package remains valid in the APPS schema. Customizations should call only the documented public entry points rather than the internal body logic, and copying or moving indicators outside the supported path risks inconsistent configuration across the KPI tables listed above.