Clarifying Oracle EPM Versioning

Introduction

Even for EPM insiders, Oracle's versioning scheme for Oracle EPM can be confusing. With this post I attempt to shed some light on this matter. This post will assume the latest version of EPM available at the time of writing, which is 11.1.2.4.x. The rumour is that this is the last EPM 11.x version, in 2017 version 12.x is expected. Essbase v12.x has recently been released embedded in the latest version of OBIEE.

Collect all Oracle EPM Patches Installed

As you may know from my previous post, I am fund of automating Oracle EPM installation and configuration tasks. However automating some documentation tasks is also very much appreciated ;-) Below a small old school Windows NT Shell script that produces a computername_epmservices.txt file containing all patches installed for each Oracle EPM Oracle home. Please note that this script requires another script which is a wrapper for opatch. Please copy hpatch.cmd to "\Oracle\Middleware\EPMSystem11R1\OPatch" and then execute getPatchList.cmd from anywhere.