Upgrade to 12c: Reports are not Displayed Completely After Editing

(Doc ID 2335145.1)

Last updated on DECEMBER 11, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Symptoms

After Upgrading BI Publisher from 10.1.3.4.2 to 12.2.1.2.
Reports are run without any problem in the 12c environment.
But if one edits the report which was created in 10g, even if no changes are made.

Ex:
Click DataSet=>SQL Query
Copy and the whole SQL query and paste it again without doing any changes
Then save and run the report again, some data will not be displayed.

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