Home › Discussions › Questions & Answers › EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536

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

Avatar photoCustomer December 22, 2024 at 9:56 am

We are operating on EBS 12.1.3, and any attempt to generate high-volume inventory valuation or supply chain reports using BI Publisher Excel templates results in failure at exactly 65,536 rows. Can you explain the root cause of this limitation and confirm if it is a standard Oracle issue?

Viewing 6 reply threads
  • Author
    Replies
    • Support December 23, 2024 at 4:37 am  

      Yes, this is a well-documented constraint within EBS 12.1.3 environments. The root cause is that the BI Publisher Excel templates in this version default to generating output in the older XLS format, which has an inherent technical restriction of exactly 65,536 rows. To handle larger datasets, the output must be generated in the newer XLSX format, which is not the standard behavior for these templates.

    • Avatar photoCustomer December 24, 2024 at 3:59 am  

      This inability to generate XLSX output is severely impacting our high-volume operational reporting. How does Blitz Report overcome this specific row volume barrier immediately?

    • Support December 25, 2024 at 7:01 pm  

      Blitz Report is architected entirely differently, fundamentally bypassing this restriction. It delivers the output as native Excel files and explicitly states that it has no volume limitations. Whether your report is for 500,000 inventory items or millions of transactions, Blitz Report processes the request efficiently.

    • Avatar photoCustomer December 26, 2024 at 4:02 am  

      Does this mean implementing Blitz Report eliminates all the complex setup related to trying to configure BI Publisher for XLSX output in 12.1.3?

    • Support December 27, 2024 at 10:15 am  

      Precisely. You eliminate the need for complicated XML formatting and the technical hurdles associated with forcing BI Publisher templates to generate XLSX output. You simply define the required SQL, and Blitz Report outputs the perfectly formatted data directly to Excel.

    • Avatar photoCustomer December 27, 2024 at 8:19 pm  

      This sounds like an essential feature for our high-data volume modules. How quickly can we test this volume capacity in our environment?

    • Support December 29, 2024 at 12:08 am  

      The installation takes less than 15 minutes , and you can immediately begin using the software. Blitz Report is entirely free for your first 30 different reports, allowing you to run critical high-volume stress tests before any licensing commitment.

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

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14607

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

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 11961

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9896

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 6444

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