DIS Workbook Conversion Selection – Oracle EBS SQL Report

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

Overview

Lists the Discoverer workbook xmls uploaded to Blitz Report (Setup>Tools>Import>XML Upload), enriched with information supporting the decision which workbooks to convert: latest run date, run count and distinct users from the end user layer’s usage statistics, last update and creation date from the workbook definition, owner, description and sheet count.

Set Convert Workbook to Yes for each workbook that should be converted to Blitz Report and upload the file. The selection is stored on the staged workbook xml, and the ‘Blitz Report Discoverer Import’ concurrent program converts the selected workbooks.

With the Submit Import parameter set to Yes, the upload submits the ‘Blitz Report Discoverer Import’ itself after storing the selection, waits for it to complete, and reports per workbook how many Blitz reports and templates exist for its worksheets. A workbook whose worksheet folder sets could not all be converted is reported as an error row.

The usage statistics are informational only: workbooks without any usage history are listed as well, with an empty run count and last run date.

The migration process is described in the following link: https://www.enginatics.com/blog/discoverer-replacement-with-blitz-report/

Report Parameters

Upload Mode, End User Layer, Workbook, Workbook Id, Submit Import, Report Name Prefix

Oracle EBS Tables Used

xxen_discoverer_workbook_xmls, eul5_documents, eul5_qpp_stats, xxen_discoverer_sheets, xxen_reports_v

Report Categories

Enginatics, Upload

DIS Workbook Import Validation, DIS Converter Diagnostic Dump, DIS End User Layers, DIS Worksheet SQLs, DIS Discoverer and Blitz Report Users, DIS Workbooks, Folders, Items and LOVs, DIS Workbook Export Script, DIS Access Privileges, DIS Worksheet Execution History

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
Blitz Report™ XML Import DIS_Workbook_Conversion_Selection.xml
Full SQL on Enginatics www.enginatics.com/reports/dis-workbook-conversion-selection/

© 2026 Enginatics