Issues with Hyperion Planning RMI port in EPM 11.1.2.3.500 version

For environments running Enterprise Performance Management (EPM) Hyperion Planning 11.1.2.3.500 Patch Set Update (PSU), the Hyperion Planning environment may encounter communication errors with the Hyperion RMI service.

If this situation is encountered where the the utilities that use the RMI port are not able to connect to Hyperion Planning refer to the following Knowledge article:

After Applying EPM 11.1.2.3.500 Patch Encounter Errors When Connecting To Hyperion Planning Using Hyperion RMI Service On Port 11333
 Doc ID 1668349.1

This article provides a link to an Hyperion Planning patch that can be applied to the Hyperion Planning 11.1.2.3.500 environment.

Doc ID 1668349.1 Solution:

SOLUTION

After upgrading to 11.1.2.3.500, first apply Planning PSE  Patch 18614001 otherwise Planning server will not connect to Hyperion RMI server.

Look Smarter Than You Are: Oracle Exalytics X4-4 - Bigger, Better, Stronger

 If found this below interesting article,  check this out.



Look Smarter Than You Are: Oracle Exalytics X4-4 - Bigger, Better, Stronger

Unable to Create Database connection in FR reports

Issue in this case is with the permissions on shared locations.... When provided full access to EVERYONE issue got resolved.

SR 3-8531233031 : Unable to Create Database connection in FR reports

In EPM version 11.1.2.3 after installing Essbase in Active/Passive mode (For HA), APS is unable to access Essbase Cluster - Its a BUG in this new version(Bug 18242698 - UNABLE TO ACCESS ESSBASECLUSTER-1 FROM SMARTVIEW)

Please take appropriate backup before applying this Oracle Support Action Plan

SR 3-8451479611 : CCP:Unable to access EssbaseCluster-1 from APS & SmartView

ODM Action Plan Oracle Support- 25-Feb-2014 13:28 (1+ month ago)
Hi Venkata,
Development has given a quick work around for the issue and dev is working on the bug too.
ROOT CAUSE:
===========
It can be understood from the investigation above, the root cause of APS not being able to connect to HSS database is due to duplicate DATABASE_CONN
components and the necessary properties are missing in one of them.
WORKAROUND:
===========
A quick workaround is to add the "registryDatasourceJNDI" property to the @ DATABASE_CONN component whose ID
"7ace4ab6ea85541eS44e8a1fb143950369ceS7ff1".
Instructions are as follows:
- In a command-line session, goto to <EPM_INSTANCE_HOME>/bin.
- Run the following command to
./epmsys_registry.sh addproperty "#7ace4ab6ea85541eS44e8a1fb143950369ceS7ff1/@registryDatasourceJNDI" jdbc/EPMSystemRegistry
- Note that this step does not need any of the applications or servers to be shutdown/restarted. So, after running this registry command, rerun the
APS/SmartView usecase and see if you are able to connect to Essbase.

How to Customize the Oracle EPM Hyperion 11.1.2.x

Below links will help you in customizing your Oracle EPM Products, provided you need to check the licensing part before you attempt to implement this in a production environment, for testing and personal use you can try this out.

how to change the logon images in EPM system --> http://www.orahyplabs.com/2012/01/customizing-epm-workspace-1112.html#.Ux1Nsz-Sz7w

How to change the heading text that appears in the top bar of the browser? --> http://www.orahyplabs.com/2012/06/customizing-epm-workspace-1112-part-ii.html#.Ux1Okz-Sz7w

How to increase the number of items showing up in Quick Links of Workspace Home Page? --> http://www.orahyplabs.com/2013/05/customizing-epm-workspace-1112x-part-iii.html#.Ux1O8z-Sz7w

Becarful while applying the above customizations and you should be aware of fully what you are doing...

Happy Customization....