Search Results bsc_mo_ui_pkg




Overview
Explore in AI Chat

Overview

BSC_MO_UI_PKG is an Oracle EBS 12.1.1 / 12.2.2 PL/SQL package owned by the APPS schema that supports the user-interface and metadata-management layer of Oracle Balanced Scorecard (BSC), part of the Enterprise Performance Management (EPM) / Daily Business Intelligence family. The package is classified as an "OTHER" API type in the ETRM repository, meaning it is intended for internal product use rather than as a public integration API. Its principal business role is to service the Scorecard "Measure Objective" (MO) authoring workspace — providing the runtime services that let administrators define, source, and maintain scorecard measures and their underlying database objects. It bridges the BSC repository metadata (KPI definitions, measure-to-table relationships, column mappings) with the physical database objects those measures query, and it manages short-lived session and optimizer state used while a user is editing scorecard content. Because it manipulates temporary tables, DDL, and DBMS_STATS, it functions as a privileged utility layer rather than a thin UI controller.

Key Procedures and Functions

The package exposes the following documented program units (13 total):

  • RENAMEINPUTTABLE — Renames a staging/input table, typically when finalizing a measure definition generated from a KPI view.
  • UPDATERELATEDINDICATORS — Refreshes dependent or related indicator records after a measure or KPI change.
  • GETLEVELSFORINDICATOR — Returns the valid scorecard levels applicable to a given indicator.
  • GETDESCRIPTIONFORCOLUMN — Resolves a descriptive label for a database column used in a measure definition.
  • LAUNCHOPTIMIZER — Initiates optimizer/statistics processing for measure source objects.
  • TRUNCATETABLE — Empties a working table, used to reset temporary measure-editing state.
  • GETCOLDETAILS — Retrieves column-level details (metadata) for tables participating in a measure.
  • GETRELATEDINDICATORS — Returns indicators related to a given KPI or measure.
  • DELETEBSCSESSION — Removes a Balanced Scorecard UI session record, cleaning up after a user session ends.
  • CREATEDBMEASUREBYKPIVIEW — Creates a database measure from a KPI view, the core function for turning a KPI definition into a queryable measure.
  • CLEANUITEMPTABLE — Cleans the temporary UI table used during measure authoring.
  • CHECKSYSTEMLOCK — Tests whether a system-level lock is currently held, guarding concurrent measure/optimizer operations.
  • GETSYSTEMLOCK — Acquires (or reports) the system lock used to serialize privileged BSC operations.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect the documented unit names and their evident purpose.

Tables Accessed

The package reads and writes through APPS synonyms across BSC repository, Oracle Application Object Library, and data-dictionary objects:

Usage Notes

BSC_MO_UI_PKG is invoked by the Oracle Balanced Scorecard HTML/UI layer and by BSC concurrent programs rather than being called from Forms directly. It is referenced by no other APPS packages per the ETRM dependency report, confirming it sits at the top of its call stack. Because it executes DDL (RENAMEINPUTTABLE, TRUNCATETABLE), dynamic SQL, and DBMS_STATS, it requires elevated privileges and should not be modified or called from custom code without Oracle support guidance. Environments upgrading between 12.1.1 and 12.2.2 should validate that the package remains VALID and that its BSC repository tables exist and are populated, since the package is dependent on both the scorecard schema and the OAF/UI deployment. Customizations should target documented BSC public APIs rather than this internal package.