Search Results bsc_db_loader_control




Overview
Explore in AI Chat

Overview

The BSC_DB_LOADER_CONTROL table is a core technical control table within the Oracle E-Business Suite Balanced Scorecard (BSC) module. Its primary role is to manage and track the data loading processes that populate the BSC data warehouse with performance measurement information. This table acts as a central registry for load processes, ensuring data integrity and providing a mechanism for monitoring and controlling the ETL (Extract, Transform, Load) operations critical to the Balanced Scorecard's reporting and analytics functions. Its existence is essential for the scheduled and ad-hoc data refreshes that underpin the strategic performance metrics in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores metadata that governs individual data load executions. As defined by its primary key, each record is uniquely identified by a combination of two columns. The INPUT_TABLE_NAME column specifies the source table from which data is being extracted for the load process. The PROCESS_ID column uniquely identifies a specific instance or execution of a load job. While the provided ETRM metadata does not list all columns, the table's description as "Loader control information" implies it likely contains status flags (e.g., LOAD_STATUS, ERROR_MESSAGE), timestamps (START_TIME, END_TIME), and control parameters necessary to orchestrate the data flow from source tables into the BSC analytical structures.

Common Use Cases and Queries

This table is primarily accessed for operational monitoring and troubleshooting of BSC data loads. Common administrative tasks include checking the status of current or recent load jobs, identifying failed processes, and determining which source table is associated with a particular load ID. A typical query would join this table to its referenced foreign key table to get additional context.

  • Monitoring Active/Running Loads: SELECT INPUT_TABLE_NAME, PROCESS_ID FROM BSC.BSC_DB_LOADER_CONTROL WHERE LOAD_STATUS = 'RUNNING';
  • Investigating Failed Loads for a Specific Source: SELECT c.PROCESS_ID, c.ERROR_MESSAGE FROM BSC.BSC_DB_LOADER_CONTROL c WHERE c.INPUT_TABLE_NAME = '&SOURCE_TABLE' AND c.LOAD_STATUS = 'ERROR';
  • Validating Loader Configuration: SELECT DISTINCT INPUT_TABLE_NAME FROM BSC.BSC_DB_LOADER_CONTROL; This lists all source tables configured for loading.

Related Objects

The BSC_DB_LOADER_CONTROL table has a defined relationship with one other key BSC table, as per the provided metadata.

  • BSC_DB_TABLES: This table is referenced via a foreign key constraint. The column BSC_DB_LOADER_CONTROL.INPUT_TABLE_NAME references the BSC_DB_TABLES table. This relationship enforces referential integrity, ensuring that a loader control record can only be created for a valid, registered source table within the BSC schema. A typical join would be: SELECT t.TABLE_DESCRIPTION, c.* FROM BSC.BSC_DB_LOADER_CONTROL c, BSC.BSC_DB_TABLES t WHERE c.INPUT_TABLE_NAME = t.TABLE_NAME; to obtain descriptive information about the source table involved in a load.