Run large BIP reports using ScheduleReportWSSService

Summary:

In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes.

Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)

ScheduleReportWSSService is the suggested way to execute the BIP Reports through Web Services. This service
uses scheduler to execute BIP reports, which support large data volume, higher SQL query timeout and higher
process timeout

So, I tried this service in OIC to run a report that created a CSV file around 700 MB in size. Although the report submission was successful, it ultimately resulted in a size error.

Stopped processing the report. Report data size of 5368714245 bytes exceeds the maximum limit of 5368709120 bytes. The estimated XML data size exceeds the 10240000000 bytes. Review your data model SQL queries. Add more filters to limit the data fetch size.