Friday, January 29, 2021

EPM 11.2.4 - Online and Here's Some Findings!

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.
Here are a few ways EPM 11.2.4 is different from 11.2.0.0 through 11.2.1.3:
  • "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!!!!


A final note before I dive back in and resume my Unit Test.

I said above that the JDK is at least 1 year behind.  A lot of other things are behind as well.  Oracle Middleware (WebLogic, ADF and OHS) and the Essbase Suite.  Here's a quick reference of the patches you get "out of the box" after you finish running installTool.

Oracle/Middleware/EPMSystem11R1 OPatch #s

29260139
30717472
31206874
31206851
31206864
(Look them up and you'll see they're mostly the Essbase Suite 11.1.2.4 and 6 months to a year behind - EAS, Essbase RunTime Client, Essbase Server, etc).  Grab the Essbase Suite patches 11.1.2.4.041 or a higher version you trust, and you may apply them to your 11.2.4.0 system.  Try it and you will see OPatch lets you do it.

Oracle/Middleware/ohs OPatch #s

30687404 
26550599 
26355633
26287183  
26261906 
26051289 
25549931
25360603
25115951

Oracle/Middleware OPatch #s
26626168
30447461
29338031 
27747932
27430060
26355633
26287183
26261906
26051289

"Now wait a minute, Dave?  No oracle_common patches?  No util\bsu WebLogic patches?  You slacker?!?"  Welcome to Oracle Middleware 12c, my friend!  Those things are gone and what I listed in bold above are the -oh parameters you pass to the Opatch utility (add your drive letter of course).

/Oracle/Middleware is the combination of WebLogic and ADF/JDeveloper for Oracle 12c.  OHS and EPM still get their own OPatch folders as before.

I'm not looking up the English descriptions of those patch #s for you, as I've already given away too much for free.  That lookup is very easy to do with an Oracle Support subscription and access to https://support.oracle.com.

Snowed in this week, so I figured I'd make myself useful to the community somehow!

Be well, upgrade to 11.2, and patch up!

January 31, 2021 Update
My earlier remark about being able to change the "Deploy to Single Managed Server" option may have been premature.  I went back into configTool tonight, and the option is now grayed out.  The earlier behavior I experienced, where it was not grayed out, may have been a one-time fluke?

15 comments:

  1. Hi Dave

    Thank 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.

    ReplyDelete
  2. Hi Xavier,

    My 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!

    ReplyDelete
    Replies
    1. Hi Dave,
      I will schedule the task. Thank you very much for your blog!
      Regards.

      Delete
  3. 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.

    ReplyDelete
    Replies
    1. Very 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.

      I 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.

      Delete
    2. Hi Dave,

      Can 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

      Delete
    3. Hi Runita,

      The 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.... ;)

      Delete
    4. We seem to be struggling to get a same report for Auditors. Once you have figured it out, please let us know.

      Cheers

      Amit

      Delete
    5. 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.

      Delete
  4. Hi 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.

    ReplyDelete
  5. Hi Dave,

    Thanks 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

    ReplyDelete
  6. Hi SL,
    Unlike 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.

    ReplyDelete
  7. Hi SL,
    ps: 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.

    ReplyDelete
  8. Hi Dave,

    On 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.

    ReplyDelete

Thank you very much for your interest in this blog! I hope you're finding it helpful.

Please keep comments relevant to the topic in the post, as this blog is not a free-for-all substitute for Oracle Support or traditional consulting. If you have many questions unrelated to the specific topic at hand, consider contacting me on LinkedIn (https://www.linkedin.com/in/daveshay) so we may discuss the possibility of consulting.

Commenting on posts older than 90 days unfortunately goes into moderation, thanks to spammers who've been hitting this blog. Please have patience, and thanks for your understanding!

Comments including URLs linking back to gambling or other things unrelated to Oracle EPM will be deleted on sight. If you're an EPM consultant and are offering me constructive criticism or a tip, go ahead and DO link back to your blog or firm's website if you so desire.

Thanks again for reading!