One day after my 11.2.4 Initial Thoughts post, I have a near-full-stack online consisting of everything except for Tax and Cost/Profitability. (The customers I've worked with who used those modules were a small slice of my customer population, so elected to go for the "biggest bang for the buck" where my "spare time" is concerned.
(Disclaimer - as of Jan 29, 2021 this post is a rough draft and may contain typos. I'll fix them over the weekend if any are found)
For the most part, standing up Oracle EPM / Hyperion 11.2.4.0 is exactly the same as Releases 11.2.0.0 through 11.2.3.0. Meaning:
- Microsoft SQL Server 2016 SP2 only if you're going the Microsoft route, or Oracle RDBMS through 19c.
- Oracle WebLogic 12c is still behind one "dot" release. Oracle Fusion Middleware ("FMW") 11.2.1.3 versus 11.2.1.4. The Certification Matrix suggests EPM 11.2.4 could work on FMW 11.2.1.4, as it says FMW "11.2.1.3+". This may be a permutation I attempt later after all Unit Testing is complete.
- Windows Server 2016 and 2019 and Linux 7 (RHEL and Oracle's only). Essbase 21c is still limited to Linux 7-8 as of this writing.
- While Essbase 21c is certified for Linux 7 and 8, Essbase 11.2.4 (really 11.1.2.4 behind the scenes) is certified for Windows 2016-2019 and Linux 7 only. Pro tip: if you're going to upgrade, don't use Windows 2012.... Essbase 11.2.4 (11.1.2.4) works on it, but 2012 is coming out of support before you will see a budget approved for another upgrade.
- DRM and HFM still restricted to MS Windows servers only.
- RCU hasn't gone away in 11.2.4 and we still need to deal with it. Click the link to see my posts which mention RCU.
- RCU does not support MS SQL Server when MSSQL is configured for SSL.
- Certain Financial Reporting and EAS Server configurations require manual edits of WebLogic and/or Oracle HTTP Server ("OHS") files. Instructions are contained within the 11.2.4 Release Notes.
- OHS does not get setup as a Windows service. The corresponding Linux pre-delivered startup scripts don't start OHS, either. See my OHS StoreUserConfig post for a reminder on how OHS in 11.2.x (it is OHS 12c in this release) is different from all prior EPM releases going back to over a decade ago.
- Installing OHS under the Foundation node in installTool is deselected by default. You need to manually select it and then ignore the warning message in the bottom pane about a missing "null" folder. It installs just fine.
- Planning RMI still does not bind to its port and you have to apply my RMI Java solution.
- The Java JDK that is bundled with EPM 11.2.4.0 is still over one year old: Java 8 update 181. You need to grab a newer Java 8 from the latest quarterly Oracle Critical Patch Update before your IT department runs a scanner and starts hectoring you about running vulnerable software.
- "Configure Database" step in configTool moved the checkbox that makes all DB entries the same. Instead of being at the top left corner, it is now above the DB Name column. In my testing, clicking that checkbox in an attempt to deselect all rows en-masse did not work. I had to click each row by hand, so that I could make the database/schema names different.
- "Deploy to Single Managed Server" is still the default. But now if you deselect it, deploy Foundation only, and then go back to deploy more things, the option is no longer grayed out. I have not explored this further. I avoid the "Single Managed Server" architecture and someday I'll write a lengthy blog post explaining my rationale. I understand why some folks like it. I don't. To each their own!
- The pre-delivered validate batch file in EPM_INSTANCE/bin produces an HTML report that begins with "EPM Deployment Topology Report (Release 11.2.3.0.0)". This is a typo.
- The EPM Workspace home page is back!!!!
Hi Dave
ReplyDeleteThank you for your posts.
One question, we had a fresh EPM 11.2.3 installation and today I upgraded to 11.2.4. Could you explain how to enable EPM Workspace HomePage? I have another installation in 11.1.2.3.500, I don't know if I can get something from 11.1.2.3.500.
Hi Xavier,
ReplyDeleteMy EPM 11.2.4.0 is a fresh install. I took a backup of my 11.2.3.0 instance and may spin it back up and attempt the in-place upgrade to 11.2.4.
In doing a fresh 11.2.4 install, there's no step to "enable" the Workspace home page. It just happens. In your case, if you're not seeing, I would try these steps.
1. Stop services.
2. Re-run configTool and pick these 2 options: Foundation->Deploy to Application Server, and Foundation->Configure HTTP Server.
3. Once configTool is done, close out of it and then delete the folders domains\EPMSystem\servers\FoundationServices0\tmp and \cache
4. Clear browser cache.
5. Restart OHS and EPM services, and try logging in. Both Foundation and Financial Reporting need to be running, or you will see multiple pop-up warnings.
Good luck!
Hi Dave,
DeleteI will schedule the task. Thank you very much for your blog!
Regards.
You might also want to try and verify that you set your home page to "Home" in your user preferences. In an update from 11.2.3 to 11.2.4, I found that any users that were previously provisioned needed to just reset their home page in their preferences. I believe the default for newly provisioned users is to have it set to the new home page, after you are in 11.2.4.
ReplyDeleteVery interesting, Larry. This stuff is stored in the back-end relational repository exclusively now, so I'm wondering if there's a SQL statement that could set the User Preferences for "Home" for everyone all in one shot. I wouldn't relish the task of having to click through every user one-by-one.
DeleteI avoided 11.1.2.4.9xx like the plague, so I'm having to go back and figure out the Financial Reporting repository changes now. The V8_CONTAINER table is gone, for example, but I have found what seems to be its replacement.
Hi Dave,
DeleteCan you please tell me more about the V8_CONTAINER table, I know it doesn't exist in the FR(biplus) separate schema. We have a requirement to extract list of reports from backend, where i knew V8_CONTAINER table came into picture.
Where are those details now stored in the Foundation schema?
Thanks,
Runita
Hi Runita,
DeleteThe way I'm doing 11.2 implementations currently is I blend Foundation / Shared Services and Financial Reporting into a single database/schema. I noticed when you deploy HFR to its own database, all of the tables it has are also included in the Foundation database by default.
I have definitely noticed considerable table changes - many tables removed, etc. I haven't had the time yet to crawl through and reverse engineer them, and I'm slammed with upgrades vs. providing support. I'm familiar with your requirement and figured it out for 11.1.2.4.7xx and prior. I'm not sure today how to accomplish the same goal in 11.2 yet. Perhaps when the dust settles.... ;)
We seem to be struggling to get a same report for Auditors. Once you have figured it out, please let us know.
DeleteCheers
Amit
Hi Amit. What are the auditors hoping to see? The most common request is to ask to see a report listing HFM users and the last time they logged in. Deprovisioning user accounts who haven't accessed HFM in 90+ days is a well-known SOX control.
DeleteHi Dave. Excellent topic. Thanks for posting. I am planning to install 11.2.4 on the top of 11.2.3. I think 11.2.3 version onwards support SQL2019 and i did used it. I had issue only on configuring RCU using SQL instance so i removed SQL instance and it worked fine.
ReplyDeleteHi Dave,
ReplyDeleteThanks for the post.
I have installed 11.2.4 on Windows Server and found that there may have "Startup document" errors if using IE. There is no such error if using other browsers. Do you have any idea?
Many thanks
Hi SL,
ReplyDeleteUnlike releases EPM 11.2.0 through 11.2.3, in 11.2.4 you need the Financial Reporting service installed, configured and up in RUNNING mode before attempting to login to Workspace. If this is not the case, you will get those error messages when someone attempts to access to Home page in Workspace.
Hi SL,
ReplyDeleteps: regarding response to your comment.
Oracle has de-certified IE11 for EPM 11.2. The primary reason for this is Microsoft announced an end-of-life date for IE11. Oracle recommends using Chrome, Edge or Firefox ESR instead of IE11. So respect to getting help from Oracle Support regarding your IE11 error message, be prepared that an SR might get closed with the above recommendation mentioned.
Thanks Dave.
DeleteHi Dave,
ReplyDeleteOn the other hand, we hit another issue when I'm selecting entity member in Data form. When I try to expand the parent member, there may have "ADF_FACES_6097" error. After click cancel and re-select again, there is no problem.
We are using HFM 11.2.4, any insight for the issue?
Many thanks.