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 !!!
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…
We are using BI Publisher bursting to deliver documents to Oracle WebCenter Content (WCC). Under high volume (~500K documents), WCC is taking more than 10 hours to release documents because the BIP integration uses CHECKIN_UNIVERSAL, which triggers normal indexing. WCC support advised using DirectReleaseNewCheckinDoc=1 and…
Hi team We need a new implementation in Oracle fusion for the reports and analytics page that we need to restrict the access of some users who should able to view the report and disable the download the report option
Unable to open hyper link in new window with pdf output internal bug; 39503144 this should be implemented with out any work around.
As per the Statutory requirement published under Sec 4(2) and (3) of Executive Order No. 205 under Danish Bookkeeping Act, the backup copy (of application) must be stored on a server in an EU or EEA country(Norway, Iceland & Liechtenstein) that is hosted by a party which is not a related party and which is deemed to comply…
