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 Questions & Answers 7 replies

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?

7 replies

  • Support Enginatics

    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

    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 Enginatics

    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

    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 Enginatics

    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

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

  • Support Enginatics

    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.

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