New: Oracle HFM 11.2

HFM 11.2 is brand new. We will therefore extensively test this version in our test lab. But first, let’s have a look at the impact of 11.2: What are the consequences for your landscape?

After a long wait, Oracle HFM 11.2 has been released last December. This latest version of HFM is the successor to version 11.1.2.4 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

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 11.1.2.4? Then you will first have to upgrade to 11.1.2.4, 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 11.1.2.4 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 11.1.2.4; via the ‘explore’ button.

Functional impact

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 11.1.2.4 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

In the coming period, we will carefully investigate HFM 11.2 in our test environment, so that we can identify the advantages and disadvantages. In the following articles we’ll take a closer look at the results of our tests, such as the performance of 11.2 and a comparison with Oracle 11.1.2.4.

More info?

More information about the possibilities and developments of Oracle HFM for your organization? Please contact Bert Dotinga via 070-3003050 or send an email.