You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Need inputs to display More than 65531 rows in excel output by using Excel template

edited Sep 27, 2019 6:06AM in Reporting and Analytics for HCM 7 comments

Content

HI All,

As per the requirement we developed Data Model and Excel template. While running the report getting below error,

Waiting Time: 0.4 seconds
Data Fetch Time: 1.2 minutes
Total Execution Time: 1.8 minutes
Job Priority: Normal

Output failed.
[INSTANCE_ID=bip.bi_server1] [OUTPUT_ID=3817] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.
[INSTANCE_ID=bip.bi_server1]

 

Thanks,

Visu

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!