Fusion Applications BI Publisher : BI Publisher will not export 500,000 rows to Excel, generates an Apache Bridge error (Doc ID 1511630.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

You are exporting the data from a BI Publisher report to Excel.  The report contains a lot of data and as a result a large number of rows are being returned. It can also mean each row contains a lot of data if the row contains fields which have are defined as large VARCHARS or BLOBs.
When the report runs it returns data and you can click on Next to navigate through the pages of data.  You have not used Next to go through all the pages in the report as that would take too long.  If you try to use Export to Excel with the report open, it works for a while and then goes to an Apache Bridge error.

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