EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: July 27, 2021
  • Article by: Jeff Henkel

In EPM 11.2.x, you may find that you see timeouts in batch jobs that still successfully complete, or you may find the browser returning http 503 errors when FDMEE jobs run long.  

A look at the FDMEE Process Details log will reveal an error such as: HTTPError: HTTP Error 503: Service Unavailable

When this happens, you will need to update the mod_wl_ohs.conf file for OHS.  There are a couple of different Oracle Doc IDs that mention different settings to update, but by default the setting for FDMEE are essentially blank (unlike other EPM products, this one just has the server redirect information and no tuning).  In case you don’t know where this file is, it’s usually located at:  \Oracle\Middleware\user_projects\Foundation1\httpConfig\ohs\config\fmwconfig\components\OHS\ohs_component

The values to add are below, and go into the sections for:

  • <LocationMatch ^/aif>
  • <LocationMatch ^/aif/static>
  • <LocationMatch ^/oraclediagent>

The values to add to the the above sections are:

  • WLIOTimeoutSecs 60000
  • Idempotent OFF
  • WLSocketTimeoutSecs 6000
  • WLForwardUriUnparsed ON
  • KeepAliveEnabled ON
  • KeepAliveSecs 20
  • DynamicServerList OFF

Once that is done, OHS needs to be restarted and all FDMEE process should complete and users will stop seeing the browser side warnings and the process batch failures in FDMEE Process Details.

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: July 23, 2021
  • Article by: Mike Turner

Oracle dropped 11.2.6 this week and I’m working on a sandbox install but I wanted to get some quick highlights out for everyone.  We’re familiar with 11.2 updates by now, and this one is not any different, the release is both a  complete install package, and also a maintenance release for previous 11.2.x installs.  It’s important to note that Oracle has stated “you can directly apply an update to the previous two updates” – meaning you have to be at 11.2.4 or later to apply the update.  Oracle has said this in the last two updates, so they seem to be pushing everyone to stay current or plan on more work when it comes to the update process.  With a quarterly release cycle this means we should be targeting a patching/maintenance regimen of at least 1 every 6 months for EPM customers. Oracle has stated, EPM System updates are released on a quarterly basis, generally in January, April, July, and October.

NOW the NEW STUFF! WooHoo – 

  • MsSQL 2019 is officially certified
  • The installer now automatically handles patches/updates to the Fusion Middleware with “Apply Update” and its not a manual post install process anymore.
  • Support for ANY identity management product that supports header-based authentication
  • Updated HTTP Client
  • Planning is now certified with OGNL 3.2.18
  • And the documentation now outlines the procedure on how to change the DB passwords.
  • Planning supports a Custom Grid Spread
  • Profitability and Cost Management have a few new rest API’s

Some other things to note with this drop that stand out from previous 11.2.x versions…..

  • Oracle clearly states in the document that WebLogic has to be installed on same OS across the board in a distributed environment. This means if you have HFM and Essbase, the only component that can go on Linux is Essbase.
  • Essbase Studio is not included with 11.2.6 and has ben removed from future distribution
  • FDMEE support for scripting in Visual Basic is officially not supported. Customers need to port to Jython, if they have not already. It will not be available from a functional standpoint beginning with 11.2.7
  • And if you’ve been waiting for it – you should know the FDMEE SAP adapter “will be certified”, though they do not give a date, but it will be a third-party plugin for FDMEE available from Bristlecone Labs.

Over the next few days, I will be kicking the tires on the install and config so check back to see my take on how this new version works and if I run into any “gotchas” along the way….

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

PSA HFM 11.2.4 and 11.2.5 SmartView Bug (BUG# 32692920)

  • Date: May 27, 2021
  • Article by: Jeff Henkel

For those customers using Hyperion Financial Management who have upgraded recently, are in the process of upgrading, or are considering upgrading, this is a public service announcement.

It has come to our attention here at iArch Solutions that there is a bug in the HFM SmartView connection for both 11.2.4 and 11.2.5 that renders Row Suppression for No Data / Missing and Zero to be unusable when performing Ad-Hoc retrieves.  

These values are set in the SmartView Data Options (shown below).  In the case of the ‘Zero’ value, the product doesn’t actually suppress the data.  In the case of using the No Data /Misssing suppression you get the error “An Unknown Error has Occurred”.

Here is a data grid from the HFM Sample Application COMMA, with no suppression enabled.  You will note we have one Dimension in rows (Account) and one in the columns (Year):

Now enable Suppression by Suppress Rows:

Refresh with suppression and here are the results, with the data suppressed as expected and everything seems to be working.

However, this issue will escape basic validation because if you do a simple ad-hoc query with a single dimension in the columns and rows, the data will suppress as expected, but if you add an additional dimension to rows or columns, and refresh you get the following error:

This happens when simply trying to drag a new member in the grid hierarchy from the POV selector, when suppression is enabled.  But let’s assume you had a pre-existing sheet with multiple dimensions already in the columns/rows, and you choose to refresh that.

In the case below, we have the same dimensions from above, but we’ve also added ‘Customer’ to the Columns and refreshed.  Then you are greeted with the below error:

The above issue was encountered by one of our clients and Oracle has confirmed this is an unpublished Bug #3262920.  Oracle has stated that the fix for this will be included in the forthcoming 11.2.6 maintenance release, but there is a backward compatibility patch available from Oracle support if you open an SR.  The patch requires the latest HFM public release patch for 11.2.4 (Patch Number 32592115) and also a one-off patch that is comprised of one file, but is locked so you’ll need the password to access (32804571).

As a final note, this is a pretty key piece of basic functionality (which performs as expected for Planning/Essbase) and may be a cause of concern for HFM customers, and we recommend clients going through the proper channels to acquire the patch if needed. 

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

11.2.5 Install – First Impressions

  • Date: May 7, 2021
  • Article by: Mike Turner

Last week Oracle dropped 11.2.5 on e-delivery and I gave a quick summary of what was found in the read me and promised to get back to you with a first impressions from an install.

I’ve done the install now for two (2) scenarios:

Clean 11.2.5 Install using SQL Server

Apply Maintenance Patch to 11.2.4 > 11.2.5

This is my experience, and your mileage may vary but here goes….

Install:

The install was straight forward in both scenarios. The installer does it’s normal pre-checks and then either asked what I wanted to install or showed me a list of what was installed and asked if I wanted to upgrade. There were no surprised here and it performed as I expected.

One thing to note in 11.2.x – in a new install all packages are checked by default at the parent level. HFM however is only checked for the SDK, make sure you expand all the levels and select the components you want installed. I forgot this and ended up running the installer twice to get the HFM WebApp and HFM server installed.

From here let’s cover each scenario separately….

In both installs I am using Windows Server 2019 as my OS choice.

SCENARIO 1: CLEAN INSTALL

Windows Server 2019 

MsSQL Server 2017 Edition

After I fixed the HFM install, the config went smoothly based on the documentation. RCU config worked

And I updated the RCU.properties file before running the configuration tool.

Once configured and then started I verified some things about the new middleware:

WL Version is 12.2.1.4.0

Node Manager is 12.2.1.4.0

Oracle-HTTP-Server-12.2.1.4.0/2.4.39

Build ODI_12.2.1.4.0_GENERIC_190913.1025

Java is now: 1.8.0_251

Some Infra things to note:

Java:

Oracle changed the path to the primary JAVA instance, instead or using a version like …\oracle\middleware\jdk_1.0.8_251 path at has been done in the past it is now simply …\Oracle\Middleware\jdk.  I’m sure this was done to make updating the java version simpler going forward.

Planning RMI issue still exists:

Planning RMI still does not correctly start. This is a known issue, still not resolved in 11.2.5. The RMI Property “JVM Library” in the registry must be updated to use a 32-bit java. The path the installer populates the registry with is, …Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0\jre\bin\client\jvm.dll ,this does not work for two reasons, 1. it references 1.6.0 in the property which is invalid (1.8.0 is installed), it points to a 64-bit java which does not work…

C:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.8.0\bin

The path needs to be updated to the Oracle DB Client JRE included, if you installed the native Oracle client, which I do even when using MsSQL server, down the road we may want to use an Oracle Data Source so why not?

That path is:  C:\Oracle\Middleware\dbclient32\jdk\jre\bin\client\jvm.dll

FDMEE:

Some of you may have noticed in prior 11.2 version FDMEE process logs incorrectly echo out a JAVA_HOME pointing to 1.6.0. It did not seem to affect the functionality, but it was confusing and misleading in the log files..

The issue is a value in the FDMEE tables. There is a table AIF_PROFILE_OPTION_VALUES with a row for JAVA_HOME. If you look in any 11.2 version prior to 11.2.5 you will see an invalid 1.6.0 path. In 11.2.5 Oracle fixed this and the value now correctly reflects the path to …Oracle\Middleware\jdk.

If you are on a previous 11.2 release you can update this value in the table to clean up your logs.

For the remining components there were no surprises. Everything came up as expected and the validation tool showed they were all functional. I even restarted the server and did a clean start to verify everything was working.

SCENARIO2: Maintenance Application on top of existing 11.2.4 install

Windows Server 2019 

MsSQL Server 2016

Configuration Experience:

RCU.properties

First thing I noticed was the RCU.properties file was overwritten with a blank template.

I was not intending to re-build the WL Domain, so this was not too big an issue for me. I left it blank to see what would happen and my application deployments all completed successfully. From what I can tell, the config tool only needs this file the first time it builds the WL domain folder on each server.

FDMEE:

For a maintenance upgrade there are new MANUAL CONFIGURATION steps for FDMEE that need to be done prior to starting the system. These center around an OCI upgrade utility, on windows named ua.bat. I ran into issues running this utility and have opened an SR for its behavior but was able to find a workaround. 

For my install in SQL server my FDMEE database is named EPM_FDMEE, but I do not use separate credentials for each database, my user hypsql has “dbo” access to all the databases. This is not  uncommon on the SQL side, but very different from the ORACLE side. I started the utility and made the selections outlined in the documentation which brought me to a Database Connection panel. I entered the MS SQL information and made the connection using the button in the utility and it automatically populated a drop-down box titled “SCHEMA” below the connect info with “EPM_FDMEE.” This box has another below it that says, “SCHEMA PASSWORD.” In MsSQL server this is not a conventional idea. I did not have a login with the name “EPM_FDMEE” I had a database by that name. There simply was not password. I tried several different things for this value – the pw for HYPSQL, I changed my connection identity to SA hoping it would let me use HYPSQL for the schema identity, but nothing worked. The drop down that was filled with “EPM_FDMEE” was auto populated and there was no way to change the value and clicking the “drop-down” had no content.

I have opened an SR for this, but I was able to find a workaround. I created a native id named EPM_FDMEE and gave it “dbo” access to my Database EPM_FDMEE. Then I had a password to put into the utility and that worked. For installs where you use login ID’s that match database names you might never encounter this issue, but in my experience MsSQL DBA’s like to give me one ID with access to all the databases.

Once I figured all that out, I was able to run the config tool successfully and it did not error on any of the tasks. All Web Deployments reported successful, even though the RCU.properties file was still blank. After everything was configured and then started I verified some things about the new middleware:

WL Version is 12.2.1.4.0

Node Manager is 12.2.1.4.0

Oracle-HTTP-Server-12.2.1.4.0/2.4.39

Build ODI_12.2.1.4.0_GENERIC_190913.1025

Java is now: 1.8.0_251

Then I ran the EPM Validation tool to make sure everything was working. Everything returned green. I stopped all the services and rebooted the server. Once the server came back I logged in and started node manager, then OHS, and then ran the “start.bat” file to start all the component on the server.

I was on the home stretch! Until I ran the validation tool. APS was not happy.  

APS:

I went to the WL domain folder for APS and went to logs\ and opened the AnalyticProviderServices0.log

This reported a “classdefnotfound” error when trying to start the “aps” deployment. I’ve encountered this before, so I was half expecting it, but my success with the clean install had me hopeful. The Oracle KB can be searched and the recommended “fix” for this is to install an 11.1.2.4 patch for APS. “11.1.2.4.040”, I downloaded the patch. Stopped all the services and used opatch to install the patch.

OPATCH was successful, and the README does not say you have to re-deploy so I tried that first. I deleted the tmp, logs, and cache dirs from the WL domain for AnalyticProviderServices0 and started the service in windows – NO DICE! Still got the same error. To keep the story short, I and several of my colleagues went through every reconfig option we could come up with to solve this issue. We did not solve it. My APS server still will not start in 11.2.5. I have a bug opened with oracle. Although I followed the Oracle KB what has worked in the past, did not work for me in 11.2.5.

Conclusion:

Other than APS, everything else seems to be happy. Logging into workspace I was able to open everything including a sample HFM app, data management and Planning. For a clean install 11.2.5 went smoothly. As a maintenance patch I ran into a few more issues, and would not be ready to upgrade anyone with APS in the mix, until Oracle provides me with an answer to my SR.

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

Oracle releases EPM On-Premise version 11.2.5

  • Date: April 29, 2021
  • Article by: Mike Turner

Oracle dropped 11.2.5 this week and its chock full of EPM goodness. The big news is the upgrade of the middleware stack.

Oracle has upgraded to Fusion Middleware 12.2.1.4 which includes newer versions of: Oracle HTTP Server, Oracle WebLogic Server. and Java 1.8.0_251. They have also added support for MsSQL 2017.

While 11.2.5 as a new install offers upgrade paths from 11.1.2.4 and 11.1.2.3, it’s also a complete patch to the 11.2 family of code. You can apply the new 11.2.5 patch directly to 11.2.3 and 11.2.4. Previous versions of 11.2 require a patch to 11.2.3 at a minimum and then you can apply 11.2.5. Like the previous 11.2 patches, the patch is applied directly to the already installed software and then the config tool is used to update the instance.

Some new features in the app stack include a configurable Content Management system for FCM, a legacy feature missing in previous 11.2 releases, and for Planning, SmartView gets extended dynamic members or “on-the-fly” members through the use of business rules.

Huge for Financial Reporting migrations, the read me now provides guidance on how to migrate Financial Reporting roles and Provisioning from 11.1.2.4 which until now has been a complete rebuild in 11.2. The readme provides details how to use LCM for the migration and how to edit the export file for 11.2 including role Maps for the new “Document Repository Roles”

Another big win for EPM is the Certification of Essbase 21c. While not support for Planning yet, Shared Services, SmartView, and Financial Reporting are now supported with Essbase 21C.

Over the next few days, I will be kicking the tires on the install and config so check back to see my take on how this new version works and if I run into any “gotchas” along the way….

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

Back By Popular Demand

  • Date: February 22, 2021
  • Article by: Jeff Henkel

Well, as usual the people have spoken.  When the people speak (and by people I mean the customers paying the bills) even vendors as large as Oracle sometimes listen.  

So what am I referring to?  

Why nothing less than the return of the default splash/welcome/frequently-used-items Home Page.  In 11.2.4 the Home Page is back and it’s looking slicker than ever.

There’s really not much more to say, so we’ll let the picture say it best:

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More

OWSM Blog Part 1 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2

  • Date: November 18, 2020
  • Article by: Brad Spelman

Many of the guides for setting up DRM Web Services API deal with configuration of older versions of WebLogic than what comes with Oracle EPM 11.2 . The EPM 11.2 documentation ‘Deployment Options Guide’ is a fine document but has no screen shots. The other DRM documents out there either say ‘look at these other documents’ (many of which were not yet updated to show WebLogic 12c navigation) or are written for the WebLogic 11 server menus. This document generally follows the Oracle EPM 11.2 DOG.

Part 1, Database Configuration and Installation of OWSM

The RCU, Oracle’s utility for database creation, is straight-forward and has not changed for our purposes. If you have installed EPM already, you should already have run RCU as part of preparation for the EPM WebLogic application deployment steps. Be sure you have deployed at least one WebLogic component (Foundation Services) prior to following this guide. Run these steps on the Oracle EPM server you will be using as your primary WebLogic server.

If you did not already, go back and run RCU again, this time ensuring the checkboxes under AS Common Schemas for ‘Oracle Platform Security Services’ and ‘Metadata Services’ are checked. Note the Schema Owner as these will be required later.

If you should have any questions or concerns with your EPM environment, let us know, we’re here to assist as always!

Share me

EPM 11.2.x FDMEE OHS Configuration Updates

  • Date: Jul 27, 2021
  • Article by: Jeff Henkel
Read More

Oracle Releases EPM On-Premise version 11.2.6!

  • Date: Jul 23, 2021
  • Article by: Mike Turner
Read More