Search Results bsc_objective_id_null




Overview
Explore in AI Chat

Overview

The APPS.BSC_KPI_MEASURE_WEIGHTS_PVT package body is a private (PVT) PL/SQL implementation unit within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It provides the low-level data manipulation logic that supports the public APIs responsible for maintaining the weighting relationship between an objective and its associated KPI measures. In Balanced Scorecard terminology, an objective aggregates one or more KPI measures, and each measure carries a weight that determines its relative contribution to the objective's scorecard result. This package encapsulates the insert, update, delete, and query operations required to persist those weighting definitions in the underlying schema.

Because the package is classified as PVT, it is not intended to be called directly by external applications or integrators. It is invoked exclusively by the corresponding public (PUB) layer, which applies the standard Oracle EBS API validation and error-handling conventions before delegating persistence work to the private routines.

Key Procedures and Functions

  • CREATE_KPI_MEASURE_WEIGHTS — Validates and inserts a new objective-to-KPI-measure weighting row. As shown in the documented source, it raises the error message BSC_OBJECTIVE_ID_NULL when objective_id is null and BSC_KPI_MEASURE_ID_NULL when the KPI measure identifier is missing, consistent with the search term bsc_objective_id_null. Validated data is inserted into BSC_KPI_MEASURE_WEIGHTS, and the caller's p_commit flag governs transaction control.
  • UPDATE_KPI_MEASURE_WEIGHTS — Modifies an existing weighting record, typically the weight value or related attributes for a given objective/measure pairing.
  • DEL_KPI_MEASURE_WEIGHTS — Removes a single weighting row identified by its key.
  • DEL_OBJ_KPI_MEASURE_WEIGHTS — Removes all weighting rows associated with a specified objective, supporting cleanup when an objective is redefined or deleted.
  • RETRIEVE_KPI_MEASURE_WEIGHTS — Reads weighting data for display or downstream processing, returning the persisted records to the calling layer.

Tables Accessed

The package operates against a single documented table, BSC_KPI_MEASURE_WEIGHTS, accessed through an APPS synonym. This table stores the intersection between objectives and KPI measures, carrying the indicator (objective) identifier, the kpi_measure_id, and the numeric weight. The package also populates the standard EBS auditing columns — creation_date, created_by, last_update_date, last_updated_by, and last_update_login — defaulting them from SYSDATE and FND_GLOBAL when the caller does not supply values.

Usage Notes

This package is invoked indirectly through the Balanced Scorecard setup and administration user interfaces where objective-to-measure weights are defined. It is also referenced by one other documented package, indicating a dependency within the BSC API stack. Standard API conventions apply: callers must initialize the message stack, supply a valid record structure, and inspect x_return_status, x_msg_count, and x_msg_data to determine success or failure. The p_commit parameter allows the caller to defer or force a commit, and error paths roll back to the BscKpiMeasureWeightPvt_Create savepoint to preserve transactional integrity.