Home › Discussions › Questions & Answers › Extracting Source SQL for Discoverer Migration

Extracting Source SQL for Discoverer Migration

Avatar photoCustomer December 2, 2024 at 1:26 pm

As part of our Discoverer migration, we need to extract the underlying SQL queries from all Discoverer worksheets to convert them into Blitz Reports. Which report facilitates this SQL extraction?

Viewing 6 reply threads
  • Author
    Replies
    • Support December 3, 2024 at 7:20 pm  

      Use the DIS Worksheet SQLs report. This report retrieves Discoverer worksheet SQL queries.

    • Avatar photoCustomer December 4, 2024 at 7:03 am  

      The standard location (`eul5_documents.doc_document`) stores the workbook in a binary format, making extraction difficult. How does this report manage to retrieve the SQL?

    • Support December 5, 2024 at 3:22 pm  

      The report leverages an active trigger function, `eul_trigger$post_save_document`, which writes each worksheet’s SQL query to the table `ams_discoverer_sql`.

    • Avatar photoCustomer December 6, 2024 at 7:25 pm  

      During the migration, how can we track user adoption to see who is still relying on Discoverer versus those transitioning to Blitz Report?

    • Support December 8, 2024 at 9:25 pm  

      Run the DIS Discoverer and Blitz Report Users report. It tracks user adoption by showing the monthly execution counts of Discoverer worksheets and Blitz Reports per user.

    • Avatar photoCustomer December 10, 2024 at 8:33 am  

      Is there a full checklist of validation reports recommended after importing Discoverer EEX files?

    • Support December 12, 2024 at 2:47 am  

      Yes, after running ‘Blitz Report Discoverer Import,’ you should verify the results using several reports, including ‘Blitz Report LOV SQL Validation’, ‘Blitz Report SQL Validation’, and ‘Blitz Report Parameter Uniqueness Validation’.

  • Author
    Replies
Viewing 6 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™ 123744

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14609

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11963

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9897

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

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

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