Thursday, July 23, 2020

EPM 11.2.2.0 on Linux: Got It Working!



 Initial observations:

  • If you've ever installed EPM 11.1.2.x on Linux before, the installTool.sh process for EPM 11.2.2.0 is identical.
  • You obviously want a VNC client or PuTTY+XMing (unless you're using the VirtualBox console or the like).  If you don't own a license for VNCViewer, look up "TightVNC" on your favorite search engine.  It is open source.
  • Before you dive in and run configtool.sh, stop and run RCU. As I've stated in other posts and in comment replies, in a distributed environment you need to do this on every server except the Essbase server.
  • HFM is grayed out unless you're either installing on Exalytics or Windows.
  • The certification matrix says Red Hat 7 and Oracle Linux 7 are the only certified UNIX platforms for this release; AIX and Solaris are not mentioned.
  • After you run RCU and then configtool.sh, you will need to fix script permissions
  • If you've tried 11.2.0.0, 11.2.1.0 or 11.2.2.0 in Windows, the Linux directory structure is laid out in an identical fashion.  If you haven't tried 11.2.x yet, the directory structure is mostly the same as 11.2.1.x, but there are some minor differences (primarily with Oracle Middleware... user_projects is the same as what you're used to).
  • Financial Reporting's "FRConfig.sh" still shows an incorrect database schema, as do all prior EPM 11.2.x releases.  This is a bug someone will need to report to Oracle.  This bug means you will be forced to use either Workspace->Explore->File->Export or the LCM batch utility rather than LCM to export your reporting repository.  LCM will throw an error for this specific task.
  • Auto-installed patches are the same as 11.2.1.0's, and mostly the same as 11.2.0.0's (minor difference where WebLogic is concerned due to the addition of Chrome and Edge support).  Essbase is still 11.1.2.4.033 and Java is still about 1 year old at 1.8 Update 181.  Once you get the system stable, you'll want to look into applying WebLogic and Java patches from the July 2020 Oracle Critical Patch Update.  You can also patch the Essbase suite up to 11.1.2.4.039 or .040 if you want (as of this writing).
I'll look into writing a more thoughtful post over the weekend if there's anything else worthy of sharing.  Have fun installing!

Why won't EPM 11.2.2 Linux services start?

Why won't EPM 11.2.2 Linux services start using the pre-delivered scripts?

Because the executable permission is missing on some of the scripts after you've finished running configtool.sh

Quick & dirty fix:

cd to your Middleware directory and type

find . -type f -name *.sh -exec chmod u+x {} \;

Problem solved.

Wednesday, July 22, 2020

Confirmed: No HFM in EPM 11.2.2.0 for Linux

Rather than a lengthy post about Hyperion / Oracle EPM 11.2.2.0, how about a screenshot?

























So if you are running a Linux-heavy shop and need HFM, you will need Windows Server 2016 or 2019 in the mix.

July 27, 2020 Update:  an Oracle SVP of Development commented on my LinkedIn post about this topic, and stated HFM for Linux would become available sometime in 2021.  This is great news!

Saturday, June 27, 2020

Release the Kraken! EPM 11.2.2 is Out and Includes Linux

EPM 11.2.2.0 is out and includes installers for Linux as well as MS Windows.  This is the one many organizations have been waiting for.

Time to spin up a new sandbox and take it for a test drive!

Edit: As of this writing, the 11.2.x documentation portal was last updated in May 2020.  While it is still 11.2.1-centric, there is a comment within the Installation Readme stating that Microsoft IE11 will not be supported in 11.2.2.  So we'll want to carefully review the 11.2.2 certification matrix once it is published.  The path forward looks to be MS Edge, Google Chrome and Firefox.  I'll publish a separate post on this topic once Oracle has updated their documentation.

News Flash: Oracle Extends Essbase 11.1.2.4 Extended Support Through 2024

No supporting detail to digest yet, but here it is:

https://blogs.oracle.com/proactivesupportepm/essbase-1112x-updates-to-the-extended-support-end-date

In short, the post linked above says Extended Support for Essbase 11.1.2.x is extended through DEC 2024.  (Safe Harbor: the Internet is forever, so if you found my blog through a Google search, please check Oracle's site for the latest information)

We also see there is again a break-out between Premiere Support and Extended Support.  Until yesterday, June 26, 2020, Premiere Support and Extended Support were on the same DEC 2021 expiration timeline.  Premiere Support remains on the DEC 2021 timeline, but Extended Support now gets the new DEC 2024 timeline.

Keep a few things in mind.

Although the post says "Essbase 11.1.2.x", in reality we're talking just about 11.1.2.4.  The ship has sailed on new patches coming out for Essbase 11.1.2.3 and prior a long time ago.  The terminal Oracle Essbase 11.1.2.3 patch is 11.1.2.3.508 and it was issued Dec 10, 2015.

Also note the post linked above is careful to talk about Essbase alone - not the entire Oracle EPM / Hyperion stack for 11.1.2.x.

What does this mean for on-premises EPM shops?

It suggests to me that Oracle intends to continue maintaining and patching Essbase 11.1.2.4 past the prior DEC 2021 Safe Harbor date. 

Perhaps COVID-19 delayed efforts to gather the Dev team together to get Essbase 19c ready to roll out to EPM 11.2.1.x.  Certainly, I can say COVID-19 has impacted many organizations and they delayed their upgrade from 11.1.2.x to 11.2.1.0 by 1-2 years.  It is possible Oracle received push-back from their customers and this could have contributed to extending the date.

Organizations still need to take Microsoft end-of-life dates into account.

Windows 7 is already out of support and the end-of-life date for Internet Explorer 11 has been aligned with end-of-life for Windows 10.  Customers who have moved to the Oracle EPM Cloud, but still use Windows 7, have 2 months remaining (as of the date of this post) to upgrade to Windows 10 so Microsoft Edge may be used; EPM Cloud will stop supporting Internet Explorer 11 in Fall 2020 (see the July 2020 EPM Cloud Update notes for details on this).

I am glad to see Essbase 11.1.2.4 has received a breath of life.  This particular component has been the most heavily patched within the 11.1.2.4 EPM on-premises suite, with a new cumulative patch coming out with significant bugfixes at a pace of one every 2 months.  For the sake of comparison, Hyperion Planning has 10 cumulative patches as of this writing, whereas Essbase has 40.

Those of us who rely upon on-premises Oracle EPM will need to re-check Oracle's site periodically to learn if the DEC 2024 Extended Support date might be applied to the rest of the EPM 11.1.2.4 stack, or if it remains applicable to Essbase only.  The fact that EPM 11.2.0.0 and 11.2.1.0 use Essbase 11.1.2.4 under the covers is a reason why I believe the date may have been extended specifically for Essbase.

Thursday, June 18, 2020

11.1.2.4 EOS White Paper

I authored a white paper on the topic of Oracle EPM / Hyperion 11.1.2.4 coming out of Premiere and Extended Support.  You may have attended one of my ODTUG webinars or read some of my blog posts on this subject.  But here it is all in one place!

https://www.datavail.com/resources/its-the-eleventh-hour-for-hyperion-11-1-2-4-heres-what-to-do/

Download it and share if you need to give higher-ups a "push" to get a budget approved to either upgrade to 11.2 or move to the EPM Cloud.

Safe Harbor applies to my statement below:

The patching sunset date for 11.1.2.4 is currently set to DEC 2021.  11.1.2.4 then moves to Lifetime/Sustaining support starting JAN 2022.  Oracle could potentially change this due to so many of their customers having project delays due to COVID-19, but that is anyone's guess.  As always, look at Oracle's official site for the latest direction on this subject.

Regardless of what Oracle decides, you will want to either move to EPM 11.2.1.0 or EPM Cloud before Microsoft ends support for Internet Explorer 11.  I do not expect any sort of patch that would pack-port 11.2.1.0's support for Microsoft Edge down to 11.1.2.4.

Saturday, May 30, 2020

FCM/ARM 11.2 - Why Can't I Find The Target Libraries?

The Hyperion / Oracle EPM 11.2 Install/Config Guide says to do the following if you want to setup Financial Close / Account Rec:












This is a familiar step for anyone who has configured FCM/ARM in EPM 11.1.2.4.

But in 11.2, I couldn't see either epm-misc-libraries or epm-aif-odi-libraries in the expected screen.  What's going on here?

The answer is WebLogic Admin Console 12c behaves a little different from your grandfather's WebLogic 10.3.6.  Click "Customize this table", REMOVE this checkbox, and then click Apply!





















I can understand why Oracle made this design decision to make this the default setting - when libraries are included, the Deployments screen contains over 100 entries if you're doing a full-stack EPM implementation.

So take away "Exclude libraries when displaying deployments", set your Targets as needed, and then go back into "Customize this table" and turn the checkbox back on when you're satisfied.