Cannot Create Database Connection For Financial Reports or run a Financial Report
(Doc ID 2731839.1)
Last updated on MARCH 15, 2022
Applies to:Hyperion BI+ - Version 22.214.171.124.000 and later
Information in this document applies to any platform.
When trying to create a FR database connection the following error is thrown.
8001: The database connection could not be found: [UUID]
When trying to run a FR report the following error is thrown.
oracle.epm.repository.RepositoryException: java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier
This error will be in the FRLogging.log.
com.hyperion.reporting.util.HyperionReportException: The object requested:
[HRInternalFolder] does not exist in the repository
The ORA-00904 error in conjunction with dbms_lob indicates that the execute privilege has not been granted to "PUBLIC" or has been revoked.
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