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 laterOracle 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 |