Blitz Report Custom Reports Converter – Oracle EBS SQL Report

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

Overview

Lists Oracle EBS concurrent programs that are candidates for conversion to Blitz Report - RDF reports, BI Publisher reports, and other data-extract concurrent programs - with usage statistics. Select the programs to convert with the Convert Program column, then upload the file. The upload submits a host concurrent program that gathers each selected program’s source artifacts (.rdf, .ldt, data definition, template, related packages and custom dependencies) into a single zip file for analysis by Enginatics.

With Include Custom Views set to Yes, the list additionally shows custom database views whose name starts with the Custom Object Prefix. Selecting a view gathers its definition and its custom dependency closure into the same zip - use this to extract the views that Discoverer-migrated or other custom reports are based on.

On instances running NoetixViews, the NOETIX_SYS query views are listed as program type Noetix View. Selecting one gathers the complete view definition closure - the view, its NOETIX_SYS helper views and packages, and the security wrapper views - into a noetix subfolder of the zip, as input for migrating Noetix based reporting to Blitz Report. Excel4apps Reports Wand programs show as program type Excel4apps and gather their report SQL.

Report Parameters

Customer Abbreviation, Custom Object Prefix, Upload Mode, Application, Program Type, Execution Method, User Concurrent Program Name, User Concurrent Program Name (contains), Concurrent Program Short Name, Concurrent Program Short Name (contains), Custom Programs Only, Execution File Name (contains), Request Group, Responsibility, Minimum Run Count, Minimum Distinct Users, Last Run Date From, Last Run Date To, Include Custom Views, Custom View prefix

Oracle EBS Tables Used

xdo_ds_definitions_b, fnd_application_vl, fnd_concurrent_programs_vl, fnd_executables_vl, fnd_concurrent_requests, dba_views, dba_objects

Report Categories

Enginatics, Upload

XDO Publisher Data Definitions, FND Concurrent Requests, Blitz Report RDF Import Validation, ECC Admin - Concurrent Programs, FND Concurrent Requests Summary, FND Attached Documents, FND Responsibility Access, FND Concurrent Programs and Executables, FND Concurrent Managers

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 Blitz_Report_Custom_Reports_Converter.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-custom-reports-converter/

© 2026 Enginatics