DIS Worksheet Execution History – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Discoverer worksheet access statistics from table eul5_qpp_stats, including folder objects used. Parameter ‘Show Folder Details’ switches between aggregate and list view of used folder objects.

Report Parameters

Workbook, Submitted by User, Business Area, Folder, View Name, Object Use Key, Object Id, Accessed within Days, Start Date From, Start Date To, Latest Workbook only, Show Folder Details, End User Layer

Oracle EBS Tables Used

&restrict_to_latest_workbook1, table, eul5_objs, eul5_documents

Report Categories

DIS Workbooks, Folders, Items and LOVs, DIS Items, Folders and Formulas, DIS Folders, Business Areas, Items and LOVs, DIS Access Privileges, ONT Orders, DIS Workbook Export Script, DIS Workbook Owner Export Script, DIS Workbook Import Validation, DIS Business Areas

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 History 04-Jan-2019 135450.xlsx
Blitz Report™ XML Import	DIS_Worksheet_Execution_History.xml
Full SQL on Enginatics	www.enginatics.com/reports/dis-worksheet-execution-history/

DIS Worksheet Execution History

Description

This report provides a historical log of Discoverer worksheet executions, offering detailed insights into user activity and system usage. It queries the eul5_qpp_stats table to retrieve access statistics, including which folders and objects were utilized during execution.

Features include:

Execution Log: A chronological record of who ran which workbook and when.
Folder Usage: Identifies the specific EUL folders accessed by each execution, useful for understanding data consumption patterns.
Drill-Down Capability: The ‘Show Folder Details’ parameter allows users to switch between an aggregate view and a detailed list of used folder objects.

This history is valuable for auditing, performance tuning, and identifying obsolete or heavily used reports during a migration project.

Parameters

Workbook: Filter by workbook name.
Submitted by User: Filter by the user who executed the report.
Business Area: Filter by Discoverer Business Area.
Folder: Filter by specific folder usage.
View Name: Filter by underlying view name.
Object Use Key: Filter by object key.
Object Id: Filter by object ID.
Accessed within Days: Limit history to a recent time window.
Start Date From/To: Define a specific date range for the history.
Latest Workbook only: Restrict results to the most recent version of workbooks.
Show Folder Details: Toggle detailed folder usage information.
End User Layer: Select the EUL to query.

Used Tables

eul5_objs: EUL objects (folders).
eul5_documents: Discoverer workbook definitions.
eul5_qpp_stats: Query execution statistics.

Categories

Enginatics: Usage analysis and auditing tool.

DIS Workbooks, Folders, Items and LOVs

Useful Links

© 2026 Enginatics