DIS Worksheet Execution Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Discoverer worksheet access statistic summary from table eul5_qpp_stats to show the number of active Discoverer users, number of different workbooks and worksheets executed and the number of different folder (combinations) that these are based on.
Report Parameters
Workbook, Submitted by User, Business Area, Folder, View Name, Accessed within Days, Start Date From, Start Date To, End User Layer, Show User Details
Oracle EBS Tables Used
Report Categories
Related Reports
DIS Access Privileges, DIS Workbooks, Folders, Items and LOVs, DIS Folders, Business Areas, Items and LOVs, DIS Business Areas, DIS Worksheet Execution History, DIS Users, DIS Workbook Export Script, DIS Workbook Import Validation, DIS Worksheet SQLs
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DIS Worksheet Execution Summary 07-Oct-2022 230941.xlsx |
| Blitz Report™ XML Import | DIS_Worksheet_Execution_Summary.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dis-worksheet-execution-summary/ |
DIS Worksheet Execution Summary
Description
This report summarizes Discoverer usage statistics to provide a high-level view of system adoption and activity. It aggregates data from eul5_qpp_stats to show key metrics such as the number of active users, the variety of workbooks and worksheets being executed, and the diversity of underlying folders being accessed.
This summary is ideal for management reporting and capacity planning, helping administrators understand the scale of Discoverer usage and identify trends in user behavior. It complements detailed execution logs by providing the “big picture” of the reporting environment.
Parameters
- Workbook: Filter statistics by workbook.
- Submitted by User: Filter by user.
- Business Area: Filter by Business Area.
- Folder: Filter by folder.
- View Name: Filter by view name.
- Accessed within Days: Limit the summary to recent activity.
- Start Date From/To: Define the date range for the summary.
- End User Layer: Select the EUL to analyze.
- Show User Details: Option to break down statistics by individual user.
Used Tables
eul5_qpp_stats: The primary source for query performance and usage statistics in Discoverer.
Categories
- Enginatics: Management and usage reporting.
Related Reports
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
© 2026 Enginatics