Report Execution Flow from Oracle Business Intelligence Publisher

To execute a report using the Oracle Business Intelligence Publisher:

  1. Select a report template.
  2. Select different parameters available in the report or select a report configuration.

If report is scheduled using BIP, the system:

  • Adds an entry into Oracle Argus Safety database for status tracking (executing).
  • Assesses report parameters to make any changes in report execution.
  • Populates the temp tables based on selected report parameters and case series.
  • Before completion of temp tables population, verifies the user exits, and updates the temp table data.
  • Generates the report output.
  • Stores the report output in Oracle Argus Safety database.
  • Adds an entry into the common regulatory reports table.
  • Updates the status tracking in Oracle Argus Safety database to mark the report as generated.

You can view the report outputs from Oracle Argus Safety. Final report outputs are available on the Worklist -> Reports screen for submission.

If report is executed using the BIP Console, the system:

  • Assesses the report parameters to make any changes in report execution.
  • Populates temp tables based on selected report parameters.
  • Before completion of temp tables population, verifies the user exits, and updates the temp table data.
  • Generates the report output.

You can view the report output on the user's browser.