Blitz Report Technical Reference
Tables, PL/SQL APIs and webservice operations of Blitz Report, for building integrations with Oracle E-Business Suite.
Guides
- Overview: How Blitz Report is built into Oracle E-Business Suite, and which of its objects you can build on.
- Running reports from PL/SQL: Run a report in your own database session and receive the Excel file as a BLOB, or submit it as a concurrent request.
- Calling Blitz Report over REST: How another application (Oracle APEX on a separate database, middleware, a script) runs Blitz Reports through the webservices the Excel add-in uses. The operations themselves are listed under Webservice operations.
- Oracle APEX: Two ways to run Blitz Reports from an APEX application, depending on where APEX runs.
- Webservice operations: the 39 operations of package xxen_webservices.
PL/SQL packages
| Package | Purpose | Routines |
|---|---|---|
| xxen_api | Run and submit reports from PL/SQL, set parameter values, import, export and delete content. | 33 |
| xxen_util | Functions for report SQL: lookups, flexfields, organization and currency helpers, list handling. | 112 |
| xxen_fsg | Balance and drilldown functions behind the Blitz FSG workbook functions. | 8 |
| xxen_upload | Routines an upload package and its SQL call during a Blitz Upload run. | 23 |
| xxen_report | The report engine. Only the routines documented here are supported for direct use. | 11 |
| xxen_report_ebs | Concurrent request submission, session initialization and other EBS-specific engine routines. | 3 |
| xxen_xdo | Conversion of BI Publisher, Discoverer and other report definitions. | 2 |
Data model
53 tables in the Blitz Report schema.
Generated from Blitz Report 3.3.7 on .