Search Results insert_row_values




Overview
Explore in AI Chat

Overview

The APPS.BSC_DB_MEASURE_GROUPS_PKG package body is the foundational Data Base (DB) maintenance layer for measure groups within the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Enterprise Performance Foundation / Daily Business Intelligence family. In Oracle EBS 12.1.1 and 12.2.2, measure groups provide the logical buckets that organize individual measures (KPIs) into meaningful dashboards, scorecards, and analytical views. This package encapsulates the standard insert, update, delete, lock, and translation operations required to maintain the underlying BSC_DB_MEASURE_GROUPS_S (base/primary) and BSC_DB_MEASURE_GROUPS_TL (translation) tables. Because it is a DB-layer package, it is not classified as a public application programming interface (API); its classification is documented as OTHER, and it serves internal consumers such as Scorecard UI forms, seed data loaders, and dependent BSC packages.

Key Procedures and Functions

ETRM documents eight callable members, each handling a discrete maintenance operation on the measure group records:

  • INSERT_ROW — creates a new measure group row in the base table, normally carrying the group identifier and related attributes.
  • UPDATE_ROW — modifies the attributes of an existing measure group row identified by its primary key.
  • DELETE_ROW — removes a measure group row from the base table.
  • LOCK_ROW — issues a pessimistic lock against a specific measure group row to serialize concurrent modification.
  • TRANSLATE_ROW — populates or refreshes translated name/description columns in the translation table for a specified language.
  • ADD_LANGUAGE — inserts the default-language translations for a newly installed or newly enabled language into the translation table.
  • INSERT_DEFAULT_MEAS_ROW — seeds a default measure row association, supporting the creation of pre-populated measure groups.
  • INSERT_ROW_VALUES — inserts the individual column values for a measure group, typically called by INSERT_ROW or by loaders that bypass the top-level insert.

The design follows the standard EBS multi-lingual table pattern, where base attributes live in _S and language-specific attributes (name, description) live in _TL, coordinated through the translate/add-language pair.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • BSC_DB_MEASURE_GROUPS_S — the primary base table holding measure group definition rows; target of insert, update, delete, and lock operations.
  • BSC_DB_MEASURE_GROUPS_TL — the translation table holding language-specific names and descriptions; populated by TRANSLATE_ROW and ADD_LANGUAGE.
  • FND_LANGUAGES — the Oracle Application Object Library language repository, consulted to determine installed/active languages when adding or translating rows.
  • DUAL — used for singleton expressions and procedural boilerplate.

Additional dependencies include APP_EXCEPTION for error raising, and FND_MESSAGE / FND_MSG_PUB for the standard EBS message dictionary stack, ensuring user-facing errors are tokenized and translatable.

Usage Notes

Because the specification and body are not exposed as a supported public API, direct invocation by customer code is discouraged. In practice the package is driven from three sources: (1) the Balanced Scorecard administrative forms used to define and translate measure groups; (2) concurrent programs and seed/data-migration loaders that populate BSC_DB_MEASURE_GROUPS_S and BSC_DB_MEASURE_GROUPS_TL; and (3) other BSC DB-layer packages, of which two are documented as referencing it. The LOCK_ROW procedure should be called before UPDATE_ROW or DELETE_ROW in any custom code to replicate the module's concurrency behavior, and ADD_LANGUAGE should be executed after installing a new language so that measure group names remain consistent across all active languages. As with any internal EBS package, its signature is subject to change across patch levels within 12.1.1 and 12.2.2.