My Oracle Support Banner

After the 19C update, BI Publisher Reports that refer to "Oracle BI EE" data source don't work and fail with authentication error while making the JDBC connection (Doc ID 2576016.1)

Last updated on MAY 14, 2023

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.13.19.04.0 and later
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.21.04.0 to 11.13.21.04.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

 
Reports that refer to "Oracle BI EE" data source don't work and fail with authentication error while making the JDBC connection.  This is happening after 19c upgrade for customers who have system user explicitly configured for the BIEE data source.

The consistent error is:


oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: java.sql.SQLException: java.io.IOException: [nQSError: 43113] Message returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password. Could not get data source connection for: Oracle BI EE

 

Changes

1) Go to BI Publisher Administration → JDBC→ Oracle BI EE datasource. It should show explicit system user configuration and the test connection may fail with the following error:

" java.sql.SQLException: java.io.IOException: [nQSError: 43113] Message returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password."


2) Confirm that the username is FUSION_APPS_BI_SYSTEM_APPID.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.