DIS Workbook Import Validation – 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 workbook migration validation report showing every workbook and worksheet next to its conversion state: whether the workbook xml is uploaded, selected for conversion or converted, the object use key derived from the workbook xml, and the migrated Blitz report and template.
Workbooks known only from the end user layer and workbooks whose xml was uploaded after deletion from Discoverer are both listed, so gaps in either direction are visible. The Not yet imported parameter restricts to worksheets without a migrated template.
The Accessed after parameter restricts the output to workbooks with recorded usage since that date, the same scope the DIS Workbook Export Script lists for export; left blank, every workbook is shown including those never accessed. The usage statistics columns show access count, last accessed date and user within the same window.
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, Accessed after, Workbook Owner, Not yet imported, End User Layer
Oracle EBS Tables Used
xxen_discoverer_workbook_xmls, xxen_discoverer_sheets, xxen_discoverer_workbooks, xxen_reports_v, xxen_report_templates_v
Report Categories
Related Reports
DIS End User Layers, DIS Converter Diagnostic Dump, DIS Workbook Conversion Selection, DIS Migration identify missing EulConditions, DIS Discoverer and Blitz Report Users, DIS Worksheet SQLs, DIS Workbook Owner Export Script, Blitz Reports, Blitz Report Template Sharing
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 Workbook Import Validation 23-Jan-2024 205356.xlsx |
| Blitz Report™ XML Import | DIS_Workbook_Import_Validation.xml |
| SQL Source | DIS Workbook Import Validation.sql |
| Full Report on Enginatics | www.enginatics.com/reports/dis-workbook-import-validation/ |
DIS Workbook Import Validation
Description
This report is a critical tool for validating the migration of Oracle Discoverer workbooks to Blitz Report. It provides a comprehensive overview of the migration status, highlighting which workbooks have been successfully imported and which are pending.
The report details:
- Workbook Information: Names and sheet details of Discoverer workbooks.
- Usage Statistics: How often workbooks were accessed within a specified timeframe, helping prioritize migration efforts based on usage.
- Import Status: Columns indicating the number of records in various import process tables (
xxen_discoverer_workbooks,xxen_discoverer_workbook_xmls), allowing for tracking of the migration pipeline. - Blitz Report Integration: Information on the created Blitz Report and its associated template, confirming successful conversion.
This validation report ensures that the migration process is transparent and that all critical reporting assets are accounted for in the new system.
Parameters
- Workbook: Filter by specific workbook names.
- Accessed after: Filter for workbooks accessed after a certain date to focus on active content.
- Workbook Owner: Filter by the owner of the workbook.
- Not yet imported: Flag to filter for workbooks that have not yet been imported into Blitz Report.
- Include Inactive: Option to include inactive workbooks in the report.
- End User Layer: Specify the End User Layer (EUL) to query.
Used Tables
eul5_documents: Stores Discoverer workbook definitions.eul5_qpp_stats: Contains query statistics for Discoverer worksheets.xxen_discoverer_workbook_xmls: Staging table for workbook XML exports during migration.xxen_discoverer_workbooks: Tracks the status of workbooks being migrated to Blitz Report.xxen_report_templates_v: View for Blitz Report templates.
Categories
- Enginatics: Part of the Enginatics toolkit for Oracle EBS reporting and migration.
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