How to shrink the output XML for a BI Publisher offline scheduled report? Getting errors... (Doc ID 2239636.1)

Last updated on MARCH 30, 2017

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On CBZJ: 11.1.11.1.0 version, Analytics

Cannot export large CSV Report in OBIP

When trying to download a report in CSV format, using the offline export schedule, it fails with this error: “Report data size (4294969049 bytes) exceeds the maximum limit (4294967296 bytes). Stopped processing.”

With a further filtered setup of the export, the report works.
The problem is that this report has to show all the paid transactions in a batch for all Incentive Compensation participants, which will be used to validate the data.


ERROR
-----------------------
"Report data size (4294969049 bytes) exceeds the maximum limit (4294967296 bytes). Stopped processing"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Sales Cloud
2. Run the report
3. Download the .csv file
4. Receive error.


BUSINESS IMPACT
----------------------------
The issue has the following business impact:
Due to this issue, the customer cannot meet their customer validation requirements to show all paid transactions.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms