DIS Worksheet Execution Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Discoverer · all Discoverer reports
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.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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 Converter Diagnostic Dump, 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
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
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 |
| SQL Source | DIS Worksheet Execution Summary.sql |
| Full Report 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
© Enginatics GmbH