Oracle EBS Blitz Report Reports
51 ready-to-run SQL reports for Oracle E-Business Suite Blitz Report, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Blitz Report tables in these reports are xxen_reports_v, xxen_report_parameters_v, xxen_report_runs, fnd_user, fnd_application_vl, xxen_report_assignments.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Blitz Report SQL Reports
| Report | Description |
|---|---|
| Blitz Report Add-in Environment Setup | Generates connection configuration for the Blitz Report Excel Add-in. Open the output file in Excel with the add-in installed to auto-configure the environment. |
| Blitz Report Application Categories | Oracle application -> Blitz Report assignment via lookup XXENREPORTAPPSCATEGORIES. This setup controls how automatically imported BI publisher reports and… |
| Blitz Report Assignment Validation | Lists every Blitz Report with the number of assignments it has at each assignment level, so you can validate that all reports are assigned. Each level column… |
| Blitz Report Assignments | |
| Blitz Report Assignments and Responsibilities | Lists all responsibilities, users, and the bitz reports that they can access, presumed they have their Blitz Report Access profile option set to ‘User’ |
| Blitz Report Category Assignments | |
| Blitz Report Column Number Fomat Comparison between environments | Shows differences in Blitz Report column translations between the local and a remote database server |
| Blitz Report Column Translation Comparison between environments | Shows differences in Blitz Report column translations between the local and a remote database server |
| Blitz Report Column Translations | |
| Blitz Report Columns | Report showing all SQL columns of selected Blitz Reports by parsing their SQL on the fly. Use the Category or Report Name parameters to scope the results… |
| Blitz Report Comparison between environments | Shows Blitz Report differences between the local and a remote database server. Requires following view to be created on the remote environment to avoid… |
| Blitz Report Default Templates | |
| Blitz Report Deletion History | Shows deleted Blitz Reports and can be used to recover accidentally deleted reports. The history of deleted reports can be purged completely by running… |
| Blitz Report Dynamic Column Rules | |
| Blitz Report Execution Summary | Count and performance summary of historic Blitz Report executions |
| Blitz Report Extension Package API Signatures | Shows this instance’s signatures of the Oracle EBS APIs that Blitz Report’s extension packages call: every argument of every procedure, with its position, data… |
| Blitz Report History | History of Blitz Report executions |
| Blitz Report History Summary | Count and performance summary of historic Blitz Report executions |
| Blitz Report LOV Comparison between environments | Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered create or replace… |
| Blitz Report LOV SQL Validation | Validates Blitz Report LOV SQLs for valid syntax. This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or… |
| Blitz Report LOVs | Blitz Report list of values |
| Blitz Report License User History | Shows the history of active Blitz Report users at every at every month end, looking back the past 60 days. |
| Blitz Report License Users | Currently active Blitz Report users (running reports within the past 60 days) and their most frequently executeds reports. |
| Blitz Report Parameter Anchor Validation | Checks if all parameter anchors exist in the xxenreportparameteranchors table. |
| Blitz Report Parameter Bind Variable Validation | This report can be used to check which :bind variables were assigned to which Blitz Report parameter, in case there are more than one :binds in the parameter… |
| Blitz Report Parameter Comparison between environments | Shows Blitz Report parameter differences between the local and a remote database server. Requires following view to be created on the remote environment to… |
| Blitz Report Parameter Comparison between reports | Compares the paramaters of two reports for differences |
| Blitz Report Parameter Custom LOV Duplication Validation | Blitz report parameters using custom LOVs with the same query more than once so that they should be set up as a shared LOV instead |
| Blitz Report Parameter DFF Table Validation | Shows any parameters using the xxenutil.dffcolumns function, which reference an incorrect DFF table name. |
| Blitz Report Parameter Default Value Validation | Lists report parameters whose LOV returns an id that differs from the displayed value, and shows whether the parameter’s default value is stored as that id or… |
| Blitz Report Parameter Default Values | Blitz Report’s user or template specific parameter default values |
| Blitz Report Parameter Dependencies | |
| Blitz Report Parameter Link Validation | Lists orphaned parameter rows: additional-anchor (sub) parameter rows - those without a display sequence - that do not link to a visible parameter of the same… |
| Blitz Report Parameter Table Alias Validation | Blitz report parameters referencing table aliases, which do not exist as a table in the main report SQL |
| Blitz Report Parameter Uniqueness Validation | Validates if there are any duplicate blitz report parameters |
| Blitz Report Pivot Colums Validation | Checks if records in xxenreporttemplatepivot have a corresponding record in xxenreporttemplatecolumns |
| Blitz Report RDF Import Validation | Validates the import of RDF concurrent programs |
| Blitz Report Record History SQL Text Creation | Creates a string for the record history columns, based on a table alias. |
| Blitz Report SQL Validation | Validates Blitz Reports for valid SQL syntax. This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or… |
| Blitz Report Security | Shows all Enginatics reports and their security, for example parameter or SQL restrictions. |
| Blitz Report Template Sharing | Lists the sharing records for Blitz Report templates - who each template is shared with at Site, Responsibility or User level. The Owner column shows the user… |
| Blitz Report Templates | Blitz Report column or pivot aggregation layout templates |
| Blitz Report Text Search | This report can be used to understand which reports, parameters or LOVs contain a certain SQL Text string, or which reports currently use a specific LOV. It is… |
| Blitz Report Translations | |
| Blitz Report User History | Lists all active EBS users with their active responsibilities and blitz report execution counts. The report can be used to analyze blitz report usage within… |
| Blitz Report VPD Policy Setup | Lists tables and columns to be secured by Blitz Report’s VPD policy functionality (concurrent program ‘Blitz Report Update VPD Policies’) from lookup… |
| Blitz Report Web Service Sessions | Blitz Report runs that execute inside a web service call, from the Excel add-in or a Blitz FSG drilldown, and are still active, with the Oracle EBS user and… |
| Blitz Reports | All Enginatics report details can be seen here: https://www.enginatics.com/library/?pg=1&category[&utm_source=oraclereporting.com&utm_medium=referral&utm_campaign=oracle-ebs-sql&utm_content=module-blitz-report]=Enginatics Blitz Reports with parameters and assignments… |
| Blitz Upload Data | History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days. |
| Blitz Upload Dependencies | |
| Blitz Upload History | History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days. |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH