Search Results bsc_calculations_pub




Overview
Explore in AI Chat

Overview

APPS.BSC_CALCULATIONS_PUB is a public PL/SQL package in the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Enterprise Performance Foundation / Daily Business Intelligence technology stack. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the business logic used to define, persist, and validate KPI calculation definitions within the Balanced Scorecard framework. It functions as a public API (the "PUB" suffix indicates it is a published, callable interface intended to be invoked from outside its own schema boundary), allowing other BSC components and custom code to manage how scorecard measures are calculated rather than requiring direct DML against the underlying scorecard tables. The package is registered in the APPS schema with a VALID status and is built on the FND_API standard, using Oracle's common API error-handling and messaging conventions. It depends on the FND_API package and standard SYS constructs, and it is referenced by the BSC_BIS_KPI_MEAS_PUB package, indicating a role in the broader KPI measurement pipeline.

Key Procedures and Functions

The ETRM metadata documents eight public procedures and functions. Their names and purposes are as follows:

  • SAVE_OBJ_CALCULATIONS — Persists the calculation definitions associated with a scorecard object, storing the mapping between a measure and its calculation logic.
  • SAVE_YTD_AS_DEFAULT_CALC — Establishes a year-to-date calculation as the default calculation for a given measure or object.
  • SAVE_USER_WIZARD_CALCULATIONS — Saves calculations defined through the user-facing calculation wizard interface, capturing user-authored calculation specifications.
  • IS_BALANCE_MEASURE — A predicate function that determines whether a given measure is a balance-type measure (a stock measure whose value is point-in-time rather than a period flow).
  • IS_YTD_ENABLED_IN_DEF_MEASURE — Evaluates whether year-to-date aggregation is enabled on a defined measure, governing whether YTD values can be derived.
  • IS_CALCULATION_DEFAULT — Tests whether a specified calculation is marked as the default calculation for its associated measure.
  • IS_DATASET_BALANCE_TYPE — Determines whether a dataset is of balance type, which influences how aggregations and calculations are applied.
  • IS_CALCULATION_ENABLED — Reports whether a given calculation is currently enabled and therefore active in scorecard processing.

No parameter signatures are documented, and they should not be assumed; callers should reference the installed package specification for exact interfaces.

Tables Accessed

The package operates against several APPS-synonym tables central to Balanced Scorecard configuration:

These tables together constitute the metadata repository that drives scorecard calculation behavior.

Usage Notes

BSC_CALCULATIONS_PUB is typically invoked indirectly. It is referenced by BSC_BIS_KPI_MEAS_PUB, meaning KPI measurement processing calls into it during scorecard computation. It is also the likely back-end for the Balanced Scorecard calculation setup forms and the calculation wizard, where administrators define or amend calculations, and for any concurrent programs that initialize or refresh calculation defaults such as YTD settings. Custom integrators should call the PUB procedures rather than writing directly to BSC_KPI_CALCULATIONS, in order to preserve validation and the standardized FND_API error handling. Because the package depends on FND_API, any calling transaction should initialize and check the standard API return status. The package is common to both 12.1.1 and 12.2.2 and remains schema-valid in the APPS account; no release-specific behavioral divergence is documented in the available metadata.