Home › Discussions › Questions & Answers › Seamless Oracle Discoverer Migration: Blitz Report Automated Worksheet Import Utility

Seamless Oracle Discoverer Migration: Blitz Report Automated Worksheet Import Utility

Avatar photoCustomer November 16, 2025 at 9:08 am

With Oracle officially desupporting Discoverer, we face the immense task of migrating hundreds of complex worksheets that are critical for our business operations. We require an efficient and reliable Discoverer replacement solution capable of automatically importing the underlying worksheet SQLs, along with associated parameters and Lists of Values (LOVs), to minimize manual rework. Can the Blitz Report import utility handle this mass migration accurately and quickly?

Viewing 5 reply threads
  • Author
    Replies
    • Support November 16, 2025 at 11:33 am  

      Yes, Blitz Report was developed specifically to serve as a comprehensive Oracle Discoverer replacement, featuring automated functionality for importing Discoverer worksheets. The Blitz Report’s Discoverer report import capability automatically migrates the worksheet SQLs, including parameters and LOVs, ensuring crucial report logic is preserved.

    • Avatar photoCustomer November 16, 2025 at 3:33 pm  

      We need to analyze our existing Discoverer usage first. Are there diagnostic tools available to help us prioritize which reports to migrate based on activity?

    • Support November 16, 2025 at 7:23 pm  

      We highly recommend starting with the analytical reports available in the Blitz Report library, such as ‘DIS Worksheet Execution History’. This report provides worksheet access statistics, allowing you to prioritize migration efforts based on which reports have been recently accessed or frequently run.

    • Avatar photoCustomer November 16, 2025 at 9:32 pm  

      How is the actual import performed for a high volume of reports?

    • Support November 17, 2025 at 2:45 am  

      For mass migration, you can utilize the Blitz Report API by running a single SQL script from a tool like SQL Developer. This process is highly efficient, capable of migrating roughly 1,000 reports in about 10 minutes.

    • Support November 17, 2025 at 8:32 am  

      Once imported, the reports run through the standard concurrent manager, delivering beautifully formatted Excel output instantly, completing your move away from the desupported Discoverer platform.

  • Author
    Replies
Viewing 5 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123806

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19954

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14683

How to check if a patch is applied in Oracle EBS 12.2 14437

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14124

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11999

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9946

Migration to Java Web Start in Oracle EBS 12.2 instance 9938

Securing sensitive data with Oracle VPD 7865

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6491

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018