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.