Search Results create_analysis_measure_ui

Overview

The APPS.BSC_KPI_SERIES_PUB package is a public PL/SQL API within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It encapsulates the business logic required to manage the analytical presentation, structural definition, and color configuration of Key Performance Indicator (KPI) series. In the context of Oracle EBS 12.1.1 and 12.2.2, this package serves as the server-side engine behind scorecard setup screens, enabling administrators and analysts to define how KPI data is aggregated, displayed, and visually represented across scorecard dashboards and analytical reports.

The package is classified as a PUB (public) API, confirming it is designed for invocation by other Oracle application modules and, where appropriate, by custom extensions. Its status is VALID and it resides in the APPS schema. The package maintains a strong dependency on the generic EBS API infrastructure, specifically FND_API for standardized error handling and return-status conventions, and FND_TABLE_OF_NUMBER for passing numeric collections into and out of its procedures.

Key Procedures and Functions

The package exposes eleven documented procedures and functions that collectively manage the KPI series lifecycle:

• CREATE_ANALYSIS_MEASURE_UI — Creates a new analysis measure definition, typically invoked from a user interface context.
• UPDATE_ANALYSIS_MEASURE_UI — Modifies an existing analysis measure definition.
• DELETE_ANALYSIS_MEASURE_UI — Removes an analysis measure definition from the scorecard configuration.
• POPULATE_KPI_SERIES_COLORS — Populates the color assignments associated with a KPI series, driving visual rendering on charts and gauges.
• DELETE_KPI_SERIES_COLORS — Removes color assignments tied to a KPI series.
• CHECK_COLOR_PROPS — Validates color property definitions before they are persisted, ensuring consistency with scorecard display rules.
• CHECK_SERIES_DEFAULT_PROPS — Validates default property settings applied to a KPI series.
• UPDATE_COLOR_STRUCTURE_FLAGS — Updates flags governing the color structure and its rendering behavior.
• UPDATE_KPI_TIME_STAMP — Maintains the audit timestamp on KPI series records to reflect the latest change.
• CHECK_SERIES_STRUCTURE_CHANGE — Determines whether the structural definition of a series has changed, guarding against invalid modifications.
• SAVE_DEFAULT_CALCULATION — Persists the default calculation logic applied to a KPI series.

Tables Accessed

The package reads and writes the following tables via APPS synonyms, which constitute the core scorecard configuration schema:

• BSC_KPIS_B — Base table holding KPI definitions.
• BSC_KPI_ANALYSIS_GROUPS — Groups KPIs for analytical presentation.
• BSC_KPI_ANALYSIS_MEASURES_B — Stores analysis measures associated with KPIs.
• BSC_KPI_ANALYSIS_OPTIONS_B — Stores analysis option definitions.
• BSC_KPI_SERIES_COLORS — Holds the color configuration for KPI series.
• BSC_SYS_BENCHMARKS_B — Benchmark definitions used for comparative analysis.
• PLITBLM — A PL/SQL index-by table type used internally for collection processing.

Usage Notes

BSC_KPI_SERIES_PUB is typically invoked from Oracle Balanced Scorecard setup forms and concurrent processes rather than being called directly by end users. The _UI suffix on several procedures indicates that these routines are designed to be driven from a Forms-based user interface, where they perform validation and persistence in response to user actions.

The package references BSC_ANALYSIS_OPTION_PUB and is, in turn, referenced by BSC_BIS_KPI_MEAS_PUB, BSC_BIS_MEASURE_PUB, and BSC_OBJ_ANALYSIS_OPTIONS_PUB. This dependency chain — which also explains why a search for bsc_obj_analysis_options_pub surfaces this object — means that changes to this package can propagate through the scorecard analysis and measure APIs. Customizations should therefore be limited to wrapper code that respects the FND_API error-handling contract rather than direct modification of the packaged logic.