Search Results delete_invalid_zero_codes




Overview
Explore in AI Chat

Overview

APPS.BSC_UPDATE_VAL is a valid PL/SQL package in the Oracle E-Business Suite APPS schema that belongs to the Oracle Balanced Scorecard (BSC) product family. Its classification in the ETRM repository is "OTHER," meaning it is not exposed as a public extension API but rather serves as an internal validation and metadata-maintenance utility. The package operates against the BSC configuration tables that store the definition of database tables, columns, and relationships used to build Balanced Scorecard KPIs and dashboards. Its core business function is to validate the code values and structural metadata associated with precalculated KPI definitions, ensuring that the underlying table and column mappings referenced by scorecard indicators remain consistent and free of invalid or stale entries. In effect, BSC_UPDATE_VAL protects the integrity of the Balanced Scorecard data model during and after administrative configuration changes.

Key Procedures and Functions

The package exposes four documented procedures and functions:

  • DELETE_INVALID_ZERO_CODES — Removes code entries that are determined to be invalid or zero-valued, cleaning up stale metadata left behind by earlier configuration or validation cycles.
  • IS_TABLE_FOR_PRECALC_KPI — A boolean-style check that determines whether a given database table participates in precalculated KPI processing, allowing the validation logic to treat precalculation tables differently from ordinary source tables.
  • VALIDATE_CODES — Performs the primary validation of code values, comparing configured codes against the definitions held in the BSC metadata tables and flagging entries that are no longer valid.
  • VALIDATE_CODES_AT — A dated variant of the validation routine that evaluates code validity as of a specific point in time, supporting validation against historic or effective-dated configurations.

Parameter lists are not documented in the ETRM extract and should not be assumed; the procedures are described here by purpose only.

Tables Accessed

The package reads and writes several Balanced Scorecard configuration tables through APPS synonyms:

  • BSC_DB_TABLES, BSC_DB_TABLES_COLS, BSC_DB_TABLES_RELS — define the registered database tables, their columns, and the relationships between them, forming the structural model that validation checks against.
  • BSC_KPI_DATA_TABLES and BSC_KPI_PROPERTIES — associate KPIs with their underlying data tables and properties, determining which entries are subject to validation.
  • BSC_DB_VALIDATION — stores the validation results and rules applied to the registered database objects.
  • BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVEL_RELS — hold dimension level definitions and their relationships, used to validate dimension-related codes.
  • PLITBLM — a standard Oracle Applications PL/SQL table (index-by table) type utility referenced for in-memory collection handling.

Usage Notes

BSC_UPDATE_VAL is referenced by the APPS.BSC_UPDATE package and by itself, and is referenced by one other package in the repository. It is therefore invoked indirectly from Balanced Scorecard administrative and update processing rather than being called directly by end users. Typical invocation occurs during scorecard configuration activities — for example, when KPI metadata is refreshed, when precalculated KPI structures are redefined, or when scheduled validation is run to purge invalid codes. Because it is classified as OTHER and is an internal package, it is not a supported public API and should not be called directly from custom code; any reuse should be treated as an unsupported dependency, and upgrades between EBS 12.1.1 and 12.2.2 may alter its behavior without notice.