12.2 E-Business Suite Upgraded Instance Has Performance Issues With BI Publisher Reports Running Slower (Doc ID 2174267.1)

Last updated on AUGUST 23, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Oracle Applications Technology Stack - Version 12.2 and later
Information in this document applies to any platform.

Goal

BI Publisher 11g, E-Business Suite Specific issues

 

After an upgrade from E-Business Suite 11i to 12.2, all BI Publisher reports in the 12.2 instance are consistently slower than they were in 11i.

In the new upgraded instance, BI Publisher reports are often taking double the amount of time required in 11i.


Further review of the instance shows the java version is 1.7.0_25, which is the base java version certified with 12.2 and provided with the install upgrade / install media.

Solution

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