Oracle EBS: 使用excel格式(97-2003)的BI publisher report是否筆數能超過65536筆?

Q: 使用excel格式(97-2003)的BI publisher report是否筆數能超過65536筆?

A: 不行, 只能使用RTF格式, 或是把資料分割到多到工作表中. 在BI Publisher 11.1.1.9及後版本可以產生xslx檔. 

Ref:

1.Can we get more than 66K records by using BI publisher reports in excel output format ?

https://community.oracle.com/mosc/discussion/4115589/can-we-get-more-than-66k-records-by-using-bi-publisher-reports-in-excel-output-format

2.Splitting the Report into Multiple Sheets (Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher)

https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm#ext_multsheets

3.BI Publisher Excel Template Layout Output is Truncating Data to 65536 Rows (Doc ID 1469264.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=533024111404255&id=1469264.1&_afrWindowMode=0&_adf.ctrl-state=orvd8jckk_4