When BI Publisher Is Using 'Fusion Middleware Security Model' or 'LDAP Security Model' and Is Patched With Patch 14257433 (July Update), The Reports Applet Fails To Load Within P6 (Doc ID 1476377.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.1 and later
BI Publisher (formerly XML Publisher) - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When attempting to load the reports applet by selecting the Reports tab in P6, the applet fails to load and returns the following generic error message:

ERROR
-------------------
No data is available because your P6 user name is not valid for connecting to the reporting database.

When setting the logging level for P6 to WARN, the P6WebAccess.log returns the following WARN message:

WARN
-------------------
oracle.xdo.webservice.exception.AccessDeniedException: java.lang.SecurityException: Failed to log into BI Publisher: invalid username or password.

Changes

 This occurs after applying the following patch to BI Publisher:  Patch 14257433: UPDATE FOR BI PUBLISHER ENTERPRISE 11.1.1.5.0 JULY 2012

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