Search Results bsc_color_ranges_pub




Overview
Explore in AI Chat

Overview

APPS.BSC_COLOR_RANGES_PUB is a public PL/SQL package body in the Oracle E-Business Suite Balanced Scorecard (BSC) module. It provides the API layer that maintains the color range definitions used to visually represent KPI performance on scorecards and dashboards. Color ranges map threshold values to specific colors, enabling end users to interpret whether a KPI is performing above, at, or below target. The package follows the standard EBS PUB/PVT pattern, acting as the publicly callable interface while delegating core business logic to the companion package APPS.BSC_COLOR_RANGE_PVT. It is valid in both Oracle EBS 12.1.1 and 12.2.2, and is catalogued as an API-classified public package within the APPS schema.

Key Procedures and Functions

The package exposes twelve documented procedures and functions that cover the full lifecycle of color range configuration, including defaults and property-level variants:

The remaining documented entries relate to supporting operations such as property range retrieval. Because the ETRM metadata does not publish parameter signatures, parameter lists are not reproduced here; integrators should inspect the package specification for exact arguments.

Tables Accessed

The package interacts with several APPS-synonym base tables and supporting objects. BSC_COLOR_RANGES is the primary table holding color range records, and BSC_COLOR_RANGE_ID_S supplies the sequence used to generate unique identifiers. BSC_COLOR_TYPE_PROPS stores the color type property definitions that ranges are linked to. BSC_KPIS_B and BSC_KPI_ANALYSIS_MEASURES_B provide the KPI and measure metadata against which color ranges are applied, while BSC_SYS_DATASETS_B and BSC_SYS_INIT supply dataset and system initialization data. FND_USER is referenced for audit or ownership context. DUAL and PLITBLM are used for utility queries and PL/SQL table handling.

Usage Notes

APPS.BSC_COLOR_RANGES_PUB is typically invoked indirectly through the EBS Scorecard setup UI rather than called manually. Forms and concurrent programs that configure KPI color thresholds call the public API, which validates input, emits messages through FND_MESSAGE and FND_MSG_PUB, and applies FND_API error handling conventions. Custom code integrating with Balanced Scorecard should call this public package rather than the private BSC_COLOR_RANGE_PVT package to preserve upgrade safety. The package references BSC_COLOR_RANGES_PUB and is referenced by ten other database objects, confirming its role as a central dependency in the scorecard configuration flow.