The technical and functional impact of Oracle HFM 11.2

In this article, we’ll take a look at the technical and functional impact of Oracle HFM 11.2. What are the consequences for your landscape? And should you make the switch to 11.2?


Oracle HFM 11.2  is the successor to version and has both functional changes and technical modifications. We will therefore test it extensively in the coming period.

In order to be able to test the new version and all modifications thoroughly, we have installed a new environment in our test lab with version 11.2. In the following articles we will keep you informed of our test results. But first, we’ll look at the technical and functional consequences. What is the impact of Oracle HFM 11.2 on your environment?

Technical impact of Oracle HFM 11.2

Let’s start with one of the most important questions; can I upgrade my environment to 11.2 or do I have to do a new installation? The answer to this is that you have to do a new installation, after which you migrate the current application to 11.2. Are you on a lower version than Then you will first have to upgrade to, after which you can migrate to the 11.2 environment.

An important technical difference compared to the previous version is certification with other products. While HFM is not certified for the products below, HFM 11.2 is. This includes:

  • Windows 2019 (Linux 7 & AIX 7.2 to follow)
  • RDBMS: Oracle 12.2
  • SQL Server 2016

Another technical difference is that Financial Reporting is no longer present as a file directory on the application server. In the new version, this has been moved to the database. The access to the reports remains exactly the same as in; via the ‘explore’ button.

Functional impact of Oracle HFM 11.2

In addition to technical changes, there are also a number of functional changes. The first major change is that Oracle EPMA (Enterprise Performance Management Architect) no longer exists. As a result, metadata can no longer be modified via the dimension library. Oracle offers 2 alternatives for this. The first alternative is to go back to “classic”, which means that you need the old HFM client to edit metadata. The second alternative is DRM (Data Relationship Management); Oracle offers a stripped-down version of the DRM tool for this, where you can maintain the metadata.

The removal of EPMA seems to be a major change and we will investigate how this will work out. Fortunately, Oracle has already indicated that there will be an update with a metadata editor in workspace. In theory this seems to be the best option.

A second adjustment is a new configuration item, which allows you to determine the number of parallel calculations or consolidations. This number defaults to 8, which means that you can run up to 8 calculations in parallel. The next started calculation is then postponed until there is space again. With this setting, the load on the server can be partially controlled. This feature can be used to improve the overall performance of HFM.

A third major change concerns the task audit. It now shows much more information. Consider, for example, who opened or closed which journal periods and who locked or unlocked which data for a scenario, period or entity.

Should I switch to Oracle HFM 11.2?

At first glance, continuity seems to be the main reason to move to Oracle HFM 11.2, as this new version will be supported by Oracle for much longer. HFM 11.2 will continue to receive improvements and updates through 2030, including certifications of third-party products. Version will still receive premier support through December 2021.

Looking at the support levels, there is no rush in the coming period! Unless you want to switch to SQL server 2016 and / or Windows 2019, in which case the tradeoff will be different. More information about the differences in Oracle Support per Oracle product can be found in this overview.

Testing Oracle HFM 11.2

Of course, we have carefully investigated HFM 11.2 in our test environment, so that we can identify the advantages and disadvantages. Discover the results of our HFM 11.2 tests.

More info?

Discover the benefits of our support for Oracle EPM/ Hyperion and our EPM Support Services.

Text: Gabor Wieringa

Keep up with the latest developments

Sign up now