DIS Worksheet Execution History – 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 statistics from table eul5_qpp_stats, including folder objects used. Parameter ‘Show Folder Details’ switches between aggregate and list view of used folder objects.

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, 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

eul5_qpp_stats, eul5_objs, eul5_documents

Report Categories

DIS Converter Diagnostic Dump, DIS Workbooks, Folders, Items and LOVs, DIS Folders, Business Areas, Items and LOVs, DIS Workbook Export Script, DIS Workbook Conversion Selection, DIS Access Privileges, DIS Workbook Import Validation, DIS Worksheet Execution Summary, DIS Business Areas

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 History 04-Jan-2019 135450.xlsx
Blitz Report™ XML Import	DIS_Worksheet_Execution_History.xml
SQL Source	DIS Worksheet Execution History.sql
Full Report 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

© Enginatics GmbH