Not pretty but EPM 126.96.36.199 reconfigured to new relational db!
Anonymous Posted Apr 25, 2012 11:44 AM
Ok, after a gruesome 2 days of working with Oracle Support and several logged SR tickets later (seperate for each EPM product), I was able to get my EPM 188.8.131.52 system up and running on the new SQL Server Database.
Turns out it wasn't as simple as just re-running the EPM System Configurator as there are many more steps post configuration.
I don't mind sharing these steps if someone may find them useful. For the most part, Oracle Support has them broken out by their own respective modules but spread out across their knowledge base site it may get a bit difficult to find them all. So I put together a consolidated breakout (at least for my system) in order by each EPM module (Foundation/HSS, Planning/Workspace, EAS, Essbase, Financial Reports, etc.)
Credit goes to Oracle Support for their excellent service and effort helping walk me through working out all the issues!