Financial Reporting Configuration Tasks

Note:

If Oracle database is used for Oracle Hyperion Financial Reporting tables, the execute privilege on dbms_lob is needed for the database user, which can be done with the following command:

SQL> grant execute on dbms_lob to Public;
or
SQL> grant execute on dbms_lob to [user];
where [user] is the schema name for the Financial Reporting repository.

If it has not been granted, users will not be able to create Financial Reporting database connections or run Financial Reporting reports.