Search Results drop_kpi

Overview

BSC_AW_ADAPTER is a server-side PL/SQL package owned by the APPS schema that serves as the interface layer between the Oracle E-Business Suite Balanced Scorecard (BSC) module and the Oracle Analytical Workspace / OLAP engine. Its central responsibility is to translate user-defined KPI definitions and dimensional models into the physical database objects required for analytical processing and reporting. The package name reflects this adapter role: it adapts generic KPI metadata stored in the EBS repository into concrete analytical workspace constructs such as dimensions, cubes, and aggregation structures.

The package is classified as OTHER in the ETRM documentation, indicating that it is not a public, supported API intended for external customer extension, but rather an internal utility supporting the Balanced Scorecard feature set. Its header comment reference (BSCAWAPS.pls 120.6) identifies it as a core component of the BSC administrative framework.

Key Procedures and Functions

The package exposes several procedure groups, all documented at the specification level:

• IMPLEMENT_KPI_AW — The primary KPI provisioning routine, provided in three overloaded forms. It accepts a KPI list with processing options and materializes the analytical workspace structures for the specified KPIs. The overloads return an affected KPI list to callers that require feedback on which KPIs were processed.
• DROP_KPI — The counterpart to implementation, provided in two overloads. This is the procedure relevant to the search term "drop_kpi." It removes the analytical workspace objects associated with a supplied KPI list, cleaning up dimensions, cubes, and related metadata when KPIs are retired or redefined.
• SET_UP — Initializes the environment required for subsequent adapter operations based on the supplied options string.
• CREATE_DIM — Creates dimension objects from a supplied dimension-level list, supporting the hierarchical structures used by analytical KPIs.
• UPGRADE — Provided in two overloads, this procedure manages version transitions of the analytical workspace schema, ensuring compatibility between stored KPI definitions and the current engine version.
• INIT_ALL — A global initialization routine that populates package-level state.
• LOG / LOG_N — Diagnostic logging utilities used to record processing messages, with LOG_N providing newline-aware output.

Tables Accessed

The documented metadata identifies references to DBMS_SQL and PLITBLM via APPS synonyms. DBMS_SQL is the Oracle-supplied dynamic SQL package, and its use here indicates that BSC_AW_ADAPTER constructs and executes DDL or DML statements dynamically at runtime—consistent with its role in generating analytical workspace objects whose names and structures depend on user-supplied KPI and dimension definitions. PLITBLM (the PL/SQL tables package) is referenced for associative array manipulation supporting the dbms_sql.varchar2_table parameters used throughout the procedure signatures. No application base tables are documented in the excerpt.

Usage Notes

BSC_AW_ADAPTER is invoked indirectly by the Balanced Scorecard module rather than by end users. Within EBS, it is typically called from BSC administration forms or concurrent programs that manage KPI lifecycle operations—implementation, dimension creation, upgrade, and removal. The g_debug flag and LOG procedures support troubleshooting when KPI deployment or drop operations fail. Because the package is classified as OTHER and is referenced by four other packages, customizations should avoid direct calls; instead, customers should use supported BSC administrative interfaces. The DROP_KPI overload accepting only a KPI list is the simplest entry point for cleanup scenarios, while the overload with an options parameter permits controlled removal behavior.