Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
R12 only

12 reports

DescriptionDownload
AD ADOP Sessions
Online patching (adop) sessions of Oracle EBS 12.2 with one row per node and phase, showing the status, start and end time and duration of each phase. Phases that do not apply to a session, for example all phases but apply in a hotpatch session, are not shown. The Patches column lists the patches applied in the session's apply phase.
 System Enginatics, R12 only XLS XML
AD Code Levels
Code level and baseline of each Oracle EBS product and product family, as maintained by the patching utilities in AD_TRACKABLE_ENTITIES. Patch readme files and My Oracle Support notes state prerequisites as code levels, for example R12.AD.C.Delta.15 for AD code level C.15.
 System Enginatics, R12 only XLS XML
DBA AWR Latch by Time
Latch contention wait time history. Each row shows the system-wide latch contention wait time per latch name of one AWR snapshot interval to identify high latch contention at specific times.
 System Enginatics, R12 only XLS XML
DBA Editions
Database editions, their type and status
 System Enginatics, R12 only XLS XML
DBA Hierarchical Profiler Data
Excel version of Oracle's hierarchical profiler dbms_hprof PLSQL performance analysis. PL/SQL units that have been compiled in NATIVE mode cannot be profiled. To gather information, you must ensure that the PL/SQL code is INTERPRETED." Before compilation of the profiled code, execute: alter session set plsql_code_type=interpreted; Create and setup access to profiler tables as sys: exec dbms_hprof.create_tables(force_it=>true); create public synonym dbmshp_trace_data for sys.dbmshp_trace_data; create public synonym dbmshp_runs for sys.dbmshp_runs; create public synonym dbmshp_function_info…
full description		 System Enginatics, R12 only XLS XML
DBA ORDS Configuration Validation
Validates the Oracle REST Data Services (ORDS) configuration for Blitz Report webservices. Checks: ORDS schema enablement and URL mapping, REST module status, PL/SQL package validity, all 27 expected endpoint handlers and their ORDS template registrations, execute grants, URL-pattern privileges that intercept xxen_webservices calls and the OAuth client's role grants (catches HTTP 401 caused by pre-existing catch-all privileges), ORDS URL profile configuration with token endpoint validation, OAuth2 client_id/secret availability, and ORDS connection pool sessions. Use this report to diagnose…
full description		 System Enginatics, R12 only XLS XML
DBA Object Access Privileges
Database object privileges for a specific user, including privileges inherited through role grants. Useful for DB access security audits to understand exactly what objects a user can access and how the access was granted (directly or through which role chain).
 System Enginatics, R12 only XLS XML
DBA Profiler Data
Excel version of Oracle's dbms_profiler PLSQL performance analysis, see Oracle note: Using DBMS_PROFILER (KB85737) https://support.oracle.com/support/?kmContentId=97270 PL/SQL units that have been compiled in NATIVE mode cannot be profiled using the DBMS_PROFILER package. To gather information using DBMS_PROFILER, you must ensure that the PL/SQL code is INTERPRETED." Before compilation of the profiled code, execute: alter session set plsql_code_type=interpreted; To start and stop profiling code, use the following commands (see use…
full description		 System Enginatics, R12 only XLS XML
DBA Registry SQL Patch
DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database. A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility. Each row contains information about an installation attempt (apply or roll back) for a given patch.
 System Enginatics, R12 only XLS XML
DBA Trace File Contents
V$DIAG_TRACE_FILE_CONTENTS contains trace data that is present in the trace files that are part of the current Automatic Diagnostic Repository (ADR). Supported starting from Oracle Database 12.2.
 System Enginatics, R12 only XLS XML
FND SOA Runtime Error System Enginatics, R12 only XLS XML
FND Attached Documents (Operating Unit Secured)
Attachments of operating unit striped documents: sales orders and lines, purchase orders, lines, shipments and releases, requisitions, AP invoices, AR transactions, projects and delivery details. Each row shows the document the attachment belongs to, its category, title, file name and a clickable download link for file attachments. Short text, long text and URL attachments are shown inline. The report is secured by operating unit: only documents of the operating units accessible to the running responsibility (profile options MO: Security Profile or MO: Operating Unit) are returned, so it can…
full description		 System Enginatics, R12 only XML