Home › Discussions › Questions & Answers › Blitz Report Solves BI Publisher’s 65,536 Row Limit and Enables Seamless XLSX Output in EBS

Blitz Report Solves BI Publisher’s 65,536 Row Limit and Enables Seamless XLSX Output in EBS

Avatar photoCustomer November 24, 2025 at 6:23 pm

We are consistently facing issues with high-volume data exports using BI Publisher-based reports in EBS 12.1.3, specifically hitting the hard 65,536 row limit because we can only generate XLS output. Oracle documents confirm that generating XLSX output is not natively possible in 12.1.3, and the overflow functionality to a new worksheet doesn’t work either. How can we overcome this critical limitation and achieve truly unlimited EBS reporting?

Viewing 5 reply threads
  • Author
    Replies
    • Support November 24, 2025 at 9:08 pm  

      This is a widespread pain point, as Oracle confirms that generating XLSX output is generally not supported in EBS 12.1.3, resulting in the 65,536 row limit characteristic of the XLS format. Blitz Report is designed precisely to address these limitations by generating output files directly in XLSX or CSV formats, completely bypassing the inherent constraints of BI Publisher.

    • Avatar photoCustomer November 24, 2025 at 11:31 pm  

      If we have millions of records, how does Blitz Report handle the sheer volume without encountering the same row limits?

    • Support November 25, 2025 at 2:28 am  

      Blitz Report can generate output files of virtually unlimited size and row numbers. Specifically, in the XLSX format, if the data exceeds the standard worksheet capacity, it features automatic overflow to additional worksheets at every 1,048,575 rows, ensuring no data is lost.

    • Avatar photoCustomer November 25, 2025 at 5:36 am  

      That sounds like a direct solution. Can we easily convert our existing BI Publisher report logic into Blitz Reports?

    • Support November 25, 2025 at 9:52 am  

      Yes, Blitz Report provides functionality to easily convert and quickly modify existing Oracle BI Publisher based reports. This approach significantly reduces development time by eliminating the need for laborious XML template redesign.

    • Support November 25, 2025 at 3:22 pm  

      Furthermore, while PDF generation typically uses OPP, Blitz Report also supports generating PDF output using a custom postprocessing option, offering greater flexibility in report delivery.

  • 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™ 123736

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14607

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11960

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9895

Migration to Java Web Start in Oracle EBS 12.2 instance 9886

Securing sensitive data with Oracle VPD 7790

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

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