Home › Discussions › Questions & Answers › How to quickly create or modify Oracle E-Business Suite BI Publisher based reports

How to quickly create or modify Oracle E-Business Suite BI Publisher based reports

Avatar photoCustomer Questions & Answers 9 replies

Our largest time sink in BI Publisher development is creating and maintaining the complex XML data templates and RTF/XSL formatting files. When migrating the core SQL query to Blitz Report, do we eliminate the entire XML layer requirement?

9 replies

  • Support Enginatics

    Yes, that is the primary source of acceleration in our method. By extracting the raw SQL query from the BI Publisher data source (often a Concurrent Program that produces XML) and deploying it in Blitz Report, you instantly eliminate the need for the XML data templates and all subsequent XSL or RTF formatting layers.

  • Avatar photoCustomer

    So, how is the output formatting handled automatically if there are no external templates?

  • Support Enginatics

    Blitz Report’s engine natively handles the output formatting when generating the file. The tool takes the output of your proven SQL query and delivers a perfectly formatted native Excel file with filters already applied. The formatting of key data types like currency and dates is automatically managed.

  • Avatar photoCustomer

    This simplification allows for much faster modification times. If a user needs a slight change in the logic, how quickly can a developer implement and test it?

  • Support Enginatics

    Changes are immediate. You simply modify the SQL within the Blitz Report form, ensuring the change is tracked by the built-in version control. A complete report modification and test cycle can often be accomplished in under 10 minutes , drastically reducing the overall development effort compared to the BI Publisher lifecycle.

  • Avatar photoCustomer

    Does this conversion process also help us bypass the historical row limitation we faced with older BI Publisher exports?

  • Support Enginatics

    Absolutely. Because you are no longer relying on the legacy components that force the XLS format, Blitz Report guarantees no volume limitations on the data output to Excel. This ensures that high-volume reports derived from complex BI Publisher queries function efficiently.

  • Avatar photoCustomer

    We require assurance that the converted report still runs securely within the EBS framework.

  • Support Enginatics

    The report execution runs immediately through the Concurrent Request mechanism and respects EBS security. Furthermore, if the original BI Publisher report needed security, Blitz Report allows protecting sensitive data using Oracle VPD policies.

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