Hello,
XLS template only support 65000 row of data, we need you to implement xlsx template to go further than the 65k row limitation
thanks
Original Idea Number: 153c64487e
As a workaround, I've used a Layout Editor (.xpt) or RTF template and then enabled the Excel xlsx output type. This removes the 65k row limit of the older version of Excel template. However, BIP being able to accommodate the xlsx as a template type would be nice so the additional features of Excel can be utilized within the template as well.
it would be very helpful if we can open reports in xlsx.
this would indeed be helpfull
Gives us the opportunity to run certain report for a whole month in one report which is now not possible.
This is an terrible situation. We choose Oracle as the application because it promissed to be the best solution for our large range number of transactions. How the report output is not able to handle these large numbers ......
Fusion cannot remain in excel 2003 forever. I hope MS retire excel 2003!!
As a consultant for multiple large enterprises (over 100k employees), the ability to create BI reports with more than 65k row output is critical. Still relying on 2003 software with such limitations in 2022 does not give a good impression. We have more than 15 custom reports for Compensation reporting and have had to create workarounds to adapt to the growing volume of data, since the OOTB xls template does not meet our needs.
There is a option at report
level which will move the rows more than 65k to next sheet without header.
Nav: Report -->properties -->Formatting -->Excel Template (set Enable Scalable Mode to true)
There is another way, which is a bit of a hack. Create an xlsx template in the normal way, rename this to xls and import into your report. This fools Publisher into thinking is has the 93-2007 style Excel.
When you download and open the generated xls, you will get a warning that the format does not match the extension, but now you can get reports containing up to 1,048,576 rows.
This issue has been known for many years now. Is it possible to advise if any development work being undertaken to support .xlsx templates at all?
Upvoted.. It will really help !!!
Current Situation Oracle BI Publisher currently supports hmac-sha2-256 and hmac-sha2-512 for SFTP delivery, but does not support their ETM (Encrypt-then-MAC) variants: hmac-sha2-256-etm@openssh.com hmac-sha2-512-etm@openssh.com Business Impact This is blocking SFTP connectivity between Oracle BI Publisher and modern SFTP…
BI Publisher web services in Fusion Applications currently accept only username/password authentication, and KB33531 confirms that JWT is not supported in any current BI release. At the same time, Oracle is retiring basic authentication on 31st of March 2027, which means integrations that depend on BIP reports will have no…
Oracle Fusion HCM BI Publisher does not currently preserve image Alternative Text from RTF templates when generating Word/DOCX output. Oracle Support has confirmed this as the expected current behavior, with no configuration available to enable it. As a result, Word Accessibility Checker flags the generated images as…
The current Peru Detraction process (Generate Detraction Invoice) fails with a generic "500: Internal Error" message when processing eligible supplier invoices. Since the error does not provide sufficient details regarding the root cause, business and support teams must rely on Oracle SRs and backend investigation to…
BI Publisher bursting currently reports an email delivery as successful once the email has been processed and sent from Oracle. However, there is no customer-accessible functionality in Oracle Fusion/BI Publisher to determine whether the email was subsequently delivered, rejected, bounced, or returned as undeliverable by…
