Blitz Report™ Tutorial Videos
Learn how to use Blitz Report by following our tutorial videos
Blitz Report is an Oracle Forms-based software, fully integrated with Oracle E-Business Suite. It enables your IT support team to easily store and edit SQL scripts for reports, and to make them available to your business users. Blitz Report runs as a concurrent process and generates output files in XLSX or text delimited CSV format. Upon completion, reports automatically download and open in Excel.
Running Blitz Report
The video shows the process of running predefined Blitz Reports stored in Oracle E-Business Suite databases. Basic steps to run a Blitz Report are:
- Select a report
- Enter parameters
- Run the report and review the output
When opening Blitz Report, a selection of available reports is displayed automatically. The list can be restricted further by typing the first characters of the desired report name.
Report parameters and output formats
Report parameters filter, limit or define the extracted data. Parameters can have lists of values that either enforce selection of one particular value. Some parameters may allow entry of multiple values, depending on the definition of the parameter.
Blitz Report extracts data in XLSX format as a default. There is an option to extract data using delimited text formats CSV or TSV. While XLSX output is convenient to use, CSV output, on the other hand, is not limited in file size and offers maximum extraction performance.
Building a Blitz Report
A Blitz Report consists of the main extraction SQL and optional parameters that enable users to control or restrict data returned by a report. Basic steps to create a new report are:
- Enter a report name and an optional description
- Enter the main extraction SQL
- Define optional parameters and corresponding WHERE clause / SQL text
- Test the report by clicking the ‘Run’ button
- Set up the user access rights
Creating Report Parameters
Report parameters filter, limit or define the extracted data. Parameter definitions consist of:
- A parameter name, display sequence and optional parameter description and default value
- SQL text to be inserted into the main SQL dynamically at run-time
- An anchor as a reference to a position for the insertion
- A parameter type and optional LOV
- An optional matching value to restrict the SQL text insertion to certain parameter values
Report Parameters Types and Settings
Parameter type is used to control the LOV for parameter values at run-time. For parameter records with blank display sequence, type remains blank. The following types may be used: Char, Date, DateTime, Number, LOV, LOV custom, LOV Oracle.
Anchor defines the position inside the main SQL where the parameter SQL text is inserted. The LOV for this field shows all anchors used in the main SQL. A default value can be set for a parameter. If the value starts with the keyword ‘select’, then Blitz Report would execute the SQL to derive the default value dynamically instead of using a fixed value.
Definition of shared List of Values (LOV)
Blitz Reports often contain lists of values (LOV) shared among different reports and parameters. If an LOV is used multiple times, it is recommended to save it as a ‘reusable shared’ LOV rather than a ‘custom’ LOV. Changes on a shared LOV would automatically take effect on all report parameters where that LOV is used.
Sending Blitz Report Output to Email and Scheduling a Report
Tick the email checkbox to send the Blitz Report output file as an email attachment. Multiple email addresses can be entered as a comma-separated list. It is also possible to set up a default email address for particular reports or via profile option ‘Blitz Report Default Email Address’.
Blitz Reports can be scheduled as background processes to run at a certain date or time. This feature can be used to run time-consuming data extractions during non-office hours or to use a scheduled Blitz Report as an outbound interface. The easiest way to schedule a report, with the appropriate parameters, is to use the Blitz Report form to start a one-time run of the desired report and to then copy the submitted background concurrent request of that run.