Running report in BI Publisher Desktop triggers a "Run Time Error 6 'Overflow'" error

(Doc ID 1538299.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.4.0.0 and later
Information in this document applies to any platform.
Checked for currency on 18-Sep-2014 - JMAYALL

Symptoms

When running a custom BI Publisher report based on a SQL data model in BI Publisher Desktop the report execution would fail with the following error message :


A check of the data set provided for the data model showed a record count of around 39,000 rows but in the test case just a single column was being extracted for each row.

If a smaller data set is used then the report execution completes without 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