HFM Error: “EPMHFM-65536 – An Unexpected Error has Occurred”

EPMHFM-65536” is a very generic error message and can be caused by a number of different factors; ranging from an improper install to application processes crashing.

Below are some of the more common causes and solutions of the error:


1) User is Unable to Open the Application after applying patch:

If you recently applied, please review and confirm the following:

a) Ensure you followed all steps in HFM Patch 20455650 : Patch Set Update: for Oracle Hyperion Financial Management Readme and applied the appropriate SQL script to upgrade the schema to This is specifically listed as Step # 5 in the Readme; listed below:

FROM THE README for Patch 20455650: Patch Set Update: for Oracle Hyperion Financial Management:

Execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.

If you are using SQL Server, ignore the following warning:

Warning! The maximum key length is 900 bytes. The index ‘PK_XFM_PARAMETERS_NEW’ has maximum length of 1500 bytes. For some combination of large values, the insert/update operation will fail.


b) Rollback the patch and see if you still receive the error.


2) User is unable to open the Application After Installing or Upgrading to

The problem could be the load stop and the data audit sequence have not been updated with the upgrade.

To solve the problem, please execute the following steps with the assistance of your DBA:

Note: Please make sure you have a FULL Database/System backup before applying any changes:


1. Identify the last data audit ID by executing the below query

select max(lrownum) from <Application name>_DATA_AUDIT;

2. Drop the data audit sequence


3. Create the data audit sequence with the correct ID number.


MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1

START WITH <Identified ID from the Query 1> CACHE 20 NOORDER NOCYCLE ;


3) Upgrade Completed and Applications are Successfully Registered; however; error message is received when user opens the application: EPMHFM-66054: The system was unable to find the Datasource process for application <APPNAME>

To resolve, please check the following with the assistance of your DBA:

1. Confirm that the tables below exist:


2. Make sure that HFMTNS alias entry is added in tnsnames.ora file in:

  • \Oracle\Middleware\user_projects\config\dbclient\ AND
  • All DB client locations (\app\Administrator\product\11.2.0\client_1\network\admin)
  • Example:



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s