BI Publisher (MOSC)

MOSC Banner

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

edited Jan 25, 2018 7:49AM in BI Publisher (MOSC) 6 commentsAnswered ✓

Hi Team,
We have a custom report developed based on excel template. When the report gets completed and user try to open it, it doesn't get open.
When we checked this issue, we observed that the output (.xls)version is 97-2003. And also we found an note from Oracle document (https://docs.oracle.com/html/E22254_03/create_excel_tmpl.htm) that states that maximum row limit for version 97-2003 is 65,536 rows.(in our case there are more than 68,000 rows fetched)

We would like to know, weather we can get more than 66K records by using BI publisher reports in excel output format.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center