My Oracle Support Banner

Cannot Create Database Connection For Financial Reports or run a Financial Report (Doc ID 2731839.1)

Last updated on AUGUST 23, 2023

Applies to:

Hyperion BI+ - Version 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.

javax.jcr.PathNotFoundException: HRInternalFolder
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

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