The EPM patch 11.1.2.3.700 resolves several issues that we see in previous versions of the 11.1.2.3 patches. For example, we were in 11.1.2.3.500, and two of the major issues were:
a. IE 11 Enterprise mode- In order to log in to Workspace in version 11.1.2.3.500, IE 11 has to be set to Enterprise mode. It does not work in regular IE 11.
b. Accessing Workspace reports (R&A) via SmartView throws error.
There might be other issues as well, however, the ones mentioned above were the ones that were the main issues.
My environment: Windows Server 2008 R2. Oracle DB 11G, EPM 11.1.2.3.500, IE 11.
Following are the patches that I applied in order to upgrade to version 11.1.2.3.700. Well Oracle has a list of the patches, however, a list and sequence always helps.
NOTE:
The two first patches to be applied are:
1. Shared Services patch 20675028
2. Workspace patch 20612400 (Pre-requisite patch - 17529887 )
After applying these patches, the other patches could be applied in any sequence. However, make sure to go over the READ ME and make sure the pre-requisites are met. In my case, I went through the following path:
Financial Reporting Patch 20838970
Reporting And Analysis Framework patch 20768325
Web Analysis patch 20880421
Planning patch 20643564
Calculation Manager patch 21292109
ADF patch 21240419
NOTE ** ADF patch has a slightly different syntax as compared to the other patches. Check the READ ME. sample ADF patch syntax ---
D:\oracle\Middleware\EPMSystem11R1\OPatch\21240419\oui -oh D:\oracle\Middleware\oracle_common -jre D:\oracle\Middleware\jdk160_35
Patches, sometimes, are intimidating, especially in the case of applying patch 500 or patch 700. Moreover, every environment could be different. Also in the processing of applying the set of patches, there are so many times we need to uninstall or reinstall or reconfigure certain products while also deleting some folders, such as TMP, cache, etc. Therefore, it is always recommended to go through the READ ME very carefully and also backup the system before taking any step or applying each patch.
Happy patching.
Acknowlegements
Two entities I would like to thank for some suggestions - Oracle Support and John Goodwin
