Search Results load_reporting_calendar

Overview

BSC_BIA_WRAPPER is an Oracle Applications (APPS) PL/SQL package body that resides in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Its primary role is to act as a convenience wrapper around lower-level infrastructure maintained by the Oracle Business Intelligence (BSC) schema, specifically the BSC_BSC_XTD_PKG package and the FND_STATS statistics-gathering utility. Rather than exposing reporting users and dependent code to the underlying extended analytics objects directly, BSC_BIA_WRAPPER consolidates common operations such as refreshes of summary materialized views, management of reporting key tables, maintenance of the reporting calendar, and cost-based optimizer statistics on BSC-related tables. The package is classified as "OTHER," meaning it is one of the many supporting packages that Oracle does not expose as a formal public API, and it carries no row-level security or business-event semantics. Within the broader 12.x architecture it supports the performance and refresh lifecycle of the BSC/BIA analytics layer used by BI Publisher and associated reporting dashboards.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. The analytical and physical-housekeeping routines include:

• ANALYZE_TABLE — gathers optimizer statistics on a named table via FND_STATS with cascade disabled.
• DO_ANALYZE — a control function returning a Boolean to gate whether statistics gathering executes.
• DROP_RPT_KEY_TABLE and DROP_RPT_KEY_TABLE_VB — remove user-specific reporting key tables, delegating to BSC_BSC_XTD_PKG and surfacing error messages back to the caller.
• DROP_SUMMARY_MV and DROP_SUMMARY_MV_VB — drop summary materialized views.
• GET_SUM_TABLE_MV_NAME — derives the materialized view name corresponding to a summary table.
• IMPLEMENT_BSC_MV and IMPLEMENT_BSC_MV_VB — create or implement the BSC materialized views.
• INDICATOR_HAS_PROJECTION — determines whether a KPI indicator participates in a projection.
• REFRESH_SUMMARY_MV and REFRESH_SUMMARY_MV_AT — refresh summary materialized views, with the _AT variant performing the operation on a specified table.
• LOAD_REPORTING_CALENDAR, LOAD_REPORTING_CALENDAR_AT, and LOAD_REPORTING_CALENDAR_VB — populate or refresh the reporting calendar used by BSC/BIA analytics; the _AT variant allows targeting a specific reporting table, and the _VB variant provides the Visual Basic-style entry point suitable for calling from the classic Forms interface.

Tables Accessed

Direct and referenced object access is documented through APPS synonyms. BSC_DB_TABLES_COLS and BSC_DB_TABLES_RELS describe the column and relationship metadata for the reporting database tables, and are used to drive the calendar and materialized-view logic. BSC_KPI_DATA_TABLES identifies the KPI data tables that participate in projections and refreshes. PLITBLM holds the result messages and status for long-running operations. The package also relies on BSC_APPS_SCHEMA (via FND_STATS) and BSC_BSC_XTD_PKG for the drop_rpt_key_table operation.

Usage Notes

BSC_BIA_WRAPPER is referenced by twelve other packages within the BSC/BIA reporting stack, making it an internal hub rather than an end-user API. Typical invocation occurs from concurrent programs and scheduled refresh jobs that load the reporting calendar and refresh summary materialized views, from Forms-based dashboards through the _VB entry points, and from custom analytics code that needs a consistent interface for dropping or refreshing BSC reporting objects. Because the package is classified as OTHER and marked "noship," developers should treat its procedures as subject to change across patch levels and avoid embedding direct calls where a supported API exists.