Home › Discussions › Questions & Answers › Oracle Discoverer replacement – importing worksheets into Blitz Report™

Oracle Discoverer replacement – importing worksheets into Blitz Report™

Avatar photoCustomer Questions & Answers 11 replies

We urgently need to transition off Oracle Discoverer. We understand Blitz Report offers an automated path to import existing worksheets. What exactly is imported during the Oracle Discoverer replacement – importing worksheets into Blitz Report™ process, particularly concerning the Discoverer business areas and folders?

11 replies

  • Support Enginatics

    Blitz Report is designed as a direct replacement. The platform features fully automated Discoverer migration capability. The tool focuses on importing the worksheet definitions, which contain the logic (metadata, items, conditions) derived from the Discoverer business areas and folders.

  • Avatar photoCustomer

    If a Discoverer worksheet uses multiple parameters, how well does the import process handle migrating that parameter structure into Blitz Report?

  • Support Enginatics

    The tool translates the parameter requirements, allowing developers to ensure the corresponding Blitz Report uses equivalent parameter setups, potentially leveraging features like custom LOVs for complex inputs. Once migrated, these reports gain features like the ‘Multiple Values’ parameter functionality.

  • Avatar photoCustomer

    We need to confirm that our Discoverer 11g environment is still compatible with our 19c database to perform a final data dump for validation purposes before migration.

  • Support Enginatics

    Be cautious. There are known compatibility issues, such as the ‘No matching authentication protocol’ error, when running Discoverer 11g with Oracle Database 19c. This highlights why replacement is crucial.

  • Avatar photoCustomer

    Can we consolidate various operational reports (like ASCP exception reports or Cost Accounting reports) that were previously in Discoverer?

  • Support Enginatics

    Yes, you can consolidate reports across all modules, whether it is Simple And Effective Cost Accounting Reporting or replacing Oracle ASCP exceptions. The platform provides a unified tool for all operational reports.

  • Avatar photoCustomer

    We have external data sources (like MySQL) connected to Discoverer via database links. Will this functionality be preserved after migrating to Blitz Report?

  • Support Enginatics

    Yes, Blitz Report fully supports running reports that Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases using database links, ensuring continuity for complex, integrated reports.

  • Avatar photoCustomer

    We need to train our end-users quickly on running these new reports post-migration.

  • Support Enginatics

    The system is designed for ease of use, focusing on EBS SQL to Excel reporting with Blitz Report for non-developers. The integrated Forms interface minimizes the learning curve.

  • You must be logged in to reply to this post.