Blitz Report™ for Oracle APEX
Run, schedule and develop SQL reports in a browser and get perfectly formatted Excel output, on any Oracle database and on Oracle Fusion Cloud.
- Runs in your own APEX workspace, on Oracle Database 19c or higher
- Excel, CSV, TSV and PDF output, in the browser and in Excel
- The same report engine as Blitz Report for Oracle EBS
Blitz Report for Oracle APEX: no Oracle E-Business Suite needed
Inside Blitz Report for Oracle APEX
Find and run reports in seconds
The Reports page lists the reports you can run, with search and your recent reports. Enter the parameters, run, and the output downloads when the run completes.
- Background runs as database scheduler jobs
- Run history with the output and log of every run
- Online viewer for the workbook before downloading
User configurable layouts
Templates choose the columns, conditions and pivot tables of the output, and are shared with other users.
- Select, summarize, sort and pivot the columns of a report
- Conditions and parameter defaults per template
- Sharing with other users, or a global default for everyone
Schedule and e-mail
Schedule a report with a preset or a calendar expression and have the output e-mailed to its recipients, through the mail server your administrator configured.
- Every scheduled run in the run history, with its output and log
- Server copy of the output in a database directory when needed
- No empty e-mails: a run without data sends no output
Reporting on Oracle Fusion Cloud
Fusion users open Blitz Report from Fusion and run SQL reports on Fusion data, formatted in Excel like any other report.
- Sign-in through Fusion, no second account
- Fusion data security: BI Publisher runs the SQL as the signed-in Fusion user
- Opens inside Fusion from a navigator entry
Run reports from Excel
The Excel add-ins run Blitz Reports directly in Excel, connected through Oracle REST Data Services (ORDS).
- Database and Cloud add-ins for standalone and Oracle Fusion installations
- Download of the add-in from the application
- ORDS webservices installed with the application
Quickest report creation with SQL only
A report is a SQL query plus parameters, lists of values and templates. The engine is the same as in Blitz Report for Oracle EBS, and reports move between the editions as XML files.
- Version history of every SQL change
- Access control by user, role and assignment
- Import and export between instances
Implementing Blitz Report for Oracle APEX
- Installs into your existing database and APEX instance
- App Builder import or command-line installer
- No application server, service or client software
- Trial license for 10 users included
Already on the classic Blitz Report application 131? Follow Upgrading from the classic application.
Blitz Report for Oracle APEX FAQ
Do I need Oracle E-Business Suite?
No. Blitz Report for Oracle APEX runs on an Oracle database without Oracle E-Business Suite, with or without Oracle Fusion Cloud. For Oracle EBS, use Blitz Report for Oracle EBS.
What does it need?
Oracle Database 19c or higher and Oracle APEX 22.2.3 or higher, served through Oracle REST Data Services (ORDS). Users need a current browser.
Can I reuse reports from Blitz Report for Oracle EBS?
Yes. The report engine is the same: SQL, parameters, lists of values and templates work in the same way, and reports move between the two editions as XML files.
How do users sign in?
With an Oracle APEX account or a database account; Oracle Fusion users sign in through Fusion. Their Blitz Report access level decides what they may do.