Results for “bsc_mo_ui_pkg”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- BSC_CURRENT_SESSIONS and ICX_SESSIONS — session tracking; supports DELETEBSCSESSION.
- BSC_KPIS_B, BSC_SYS_MEASURES — KPI and system-measure definitions consumed by CREATEDBMEASUREBYKPIVIEW and GETRELATEDINDICATORS.
- BSC_DB_TABLES, BSC_DB_TABLES_COLS, BSC_DB_TABLES_RELS — physical table, column, and relationship metadata backing GETCOLDETAILS and RENAMEINPUTTABLE.
- BSC_TMP_OPT_UI_KPIS — temporary UI staging for optimizer/KPI work (CLEANUITEMPTABLE, TRUNCATETABLE).
- FND_APPLICATION, FND_CONCURRENT_REQUESTS — application context and concurrent request tracking for optimizer submissions.
- AD_DDL, ALL_OBJECTS, ALL_TAB_COLUMNS — dictionary introspection and DDL execution.
- DBMS_SQL, DBMS_STATS — dynamic SQL and statistics gathering used by the optimizer routines.
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.
-
PACKAGE: APPS.BSC_MO_UI_PKG 12.1.1
-
PACKAGE: APPS.BSC_MO_UI_PKG 12.1.1
-
SYNONYM: APPS.BSC_DB_TABLES 12.1.1
-
SYNONYM: APPS.ICX_SESSIONS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: PUBLIC.DBMS_STATS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.BSC_KPIS_B 12.1.1
-
SYNONYM: PUBLIC.ALL_OBJECTS 12.1.1
-
VIEW: APPS.BSC_KPIS_VL 12.1.1
-
SYNONYM: PUBLIC.AD_DDL 12.1.1
-
eTRM - BSC Tables and Views 12.1.1
Tab permissions
-
eTRM - BSC Tables and Views 12.1.1
Tab permissions
-
SYNONYM: PUBLIC.DBMS_SQL 12.1.1
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.1.1
No longer used