Tuesday, October 25, 2022

Oracle Hyperion 11.2.11 is out

Latest updates include:

Java JDK update 341

WebLogic PSU 12.2.1.4.22011

OHS PSU 12.2.1.4.220608

FMW Third-party Bundle PSU 12.2.1.4.220616

Essbase remain version 11.1.2.4.047, but the suite is now certified with the Windows and Linux releases of Essbase 21c.

Sunday, October 23, 2022

Oracle EPM cloud and configuring Google Chrome Browser

 

Configuring Google Chrome

You update the language settings of Google Chrome to access the service in a language other than the default browser language. For a list of languages in which the service is available, see Understanding EPM Cloud Localization.

To reconfigure Chrome for a new locale:

  1. In Google Chrome, access Settings by navigating to the following URL:
    chrome://settings/
  2. Click Settings, then Advanced, and then Languages.
  3. From Language drop-down list, select Add Languages.
  4. In Add Languages, select the display language for the service and then click ADD.
  5. Click More actions next to the display language for the service that you added in the preceding step and then select Display Google Chrome in this Language.
  6. Click RELAUNCH.
    Google Chrome restarts in the selected language.

Monday, October 3, 2022

Oracle Hyperion Financial Management (HFM) connector for Workiva

Recently we came across our Finance team looking to use HFM and Workiva.

Here is a good link, on how the setup is done:

https://support.workiva.com/hc/en-us/articles/360044301491-Oracle-Hyperion-Financial-Management-HFM-connector

Tuesday, August 23, 2022

Supported Browsers for Oracle EPM Cloud

 https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cgsus/1_epm_cloud_prereq_supported_browsers.html

Supported Browsers

Lists the supported and recommended browsers for Oracle Enterprise Performance Management Cloud.

To comply with Oracle Support policies, you must use a supported browser while accessing EPM Cloud. See Oracle Software Web Browser Support Policy.

Table 2-1 Supported Browsers for Each Client Platform

Client PlatformsRecommended BrowserOther Supported Browsers
Microsoft WindowsGoogle Chrome

Firefox ESR

Microsoft Edge Version 80 or newer

Apple Mac OS XGoogle ChromeSafari, Firefox ESR
Linux (all versions)Google ChromeFirefox ESR
iOS *SafariNone
Android *Google ChromeNone
* Only browser-based interaction is supported for iPads and Android mobile devices. Browser-based interaction is not supported on phones.

To ensure access to the service, you must configure your browser to:

  • Accept cookies from oraclecloud.com and cloud.oracle.com By default, the browsers are set up to accept cookies from websites. If your browser is configured to not accept cookies from sites, you must allow a per session or permanent exception for these sites
  • Allow pop-up windows from oraclecloud.com and cloud.oracle.com

Monday, August 1, 2022

Hyperion 11.2.10 and Oracle Technical Matrix

 Latest EPM 11.2.10.0 supported platform Matrices (updated July 25, 2022):

https://lnkd.in/gnaGdPKf

Saturday, July 30, 2022

Hyperion 11.2.10 and Weblogic patch

11.2.10.0 release includes the APRIL 2022 WLS Critical Patch Updates (CPU), as it applies the Oracle WebLogic Server Stack Patch Bundle 12.2.1.4.220418

Hyperion 11.2.10 includes this

 Release 11.2.10 includes the following new features:

Note:

Essbase version (11.1.2.4.047) remains unchanged in Release 11.2.10.

• Java 8 Update 331


• WebLogic Patch Set Update 12.2.1.4.220418


• ADF Bundle Patch 12.2.1.4.220314


• Added Oracle 21c database support.

Hyperion 11.2.10 update

 Applying EPM  11.2.10.0 uses the same method utilized when applying the 11.2.9.0 patch.

 You must be on 11.2.8.0 (or 11.2.9.0) in order to apply the 11.2.10.0 patch.

Hyperion 11.2.10 is out

 EPM on premise version 11.2.10.0 has been released on edelivery.oracle.com



Thursday, May 19, 2022

How to setup Microsoft Edge to connect with Hyperion Smartview (from version 21.200+)

1. Download Microsoft Edge WebView2. Use the Evergreen Standalone Installer.

2. Upgrade or Install SV 21.200+

3. Change the properties of SmartView Health Check. Change WebView2 Runtime to Enable



4. Restart Excel

5. Enjoy!

Tuesday, May 3, 2022

Updating from Release 11.2.x to 11.2.9 release for Hyperion

 Updating from Release 11.2.x

Oracle Enterprise Performance Management System Release 11.2.9 can only be applied to Release 11.2.8. To update from an earlier release. you must first update to Release 11.2.8 before proceeding with the steps below:

  1. Download Release 11.2.9: See Step 2: Download Release 11.2.9 in Installing EPM for the first time for more details.

  2. Apply Release 11.2.9: See Applying Release 11.2.9 for more details

Upgrading from Release Hyperion 11.1.2.x to 11.2.9 release

 Upgrading from Release 11.1.2.x

You can upgrade Oracle Enterprise Performance Management System Release 11.1.2.x products to Release 11.2.xEPM System Release 11.2.9 can only be applied to Release 11.2.8.

  1. Install Release 11.2.8: Complete instructions for installing Release 11.2.8 which is the latest full installer is mentioned in the Oracle Enterprise Performance Management System Installation and Configuration Guide . See Installing EPM System Products for more details.

  2. Download Release 11.2.9: See Step 2: Download Release 11.2.9 in Installing EPM for the first time for more details.

  3. Apply Release 11.2.9: See Applying Release 11.2.9 for more details.

Installing EPM 11.2.9 for the first time and things to take note

 Installing EPM for the first time

If you have not installed EPM previously, follow the steps below:

  1. Install Release 11.2.8: Complete instructions for installing Release 11.2.8 which is the latest full installer is mentioned in the Oracle Enterprise Performance Management System Installation and Configuration Guide . See Installing EPM System Products for more details.

  2. Download Release 11.2.9: Download the Oracle Enterprise Performance Management System Release 11.2.9 files from Oracle Software Delivery Cloud (http://edelivery.oracle.com/). Oracle recommends that you download files to a shared drive.

    The files available for download are as follows:

    • Oracle Enterprise Performance Management System - 11.2.9.0.000 for Microsoft Windows x64 (64-bit)
    • Oracle Enterprise Performance Management System - 11.2.9.0.000 for Linux x86-64
    • Oracle Enterprise Performance Management System - Client Installers 11.2.9.0.000 for Microsoft Windows x64 (64-bit)
    • Oracle Data Relationship Management 11.2.9.0.000 for Microsoft Windows (64 bit)

    From the Oracle Software Delivery Cloud (http://edelivery.oracle.com/), select the products that you licensed and add them to the cart. All required zip files are included. Select your platform, and download the files into /download_location .

  3. Apply Release 11.2.9: See Applying Release 11.2.9 for more details.

More on Hyperion 11.2.9 on-premise release and ApplyUpdate script

 Overview

Beginning with Release 11.2.9 (Release 11.2, Update 9), release updates are distributed as set of OPatches for individual EPM system components. This release update is applied on top of Release 11.2.8. See OPatch Dependencies and Details for the list of OPatches for individual EPM system components.

Note:

  • Oracle recommends that you apply the set of all Oracle Enterprise Performance Management System Release 11.2.9 product OPatches together, using the ApplyUpdate script. See Applying Release 11.2.9 for more details.
  • Oracle Data Relationship Management (DRM) is installed separately and will continue as a full install release. Complete instructions for installing Oracle Data Relationship Management is mentioned in the Oracle Data Relationship Management Suite Installation Guide. See Installing Data Relationship Management for more details.

Release 11.2.9 (Release 11.2, Update 9) includes the following deliverables:

  • Oracle Enterprise Performance Management System - 11.2.9.0.000 for Microsoft Windows x64 (64-bit)
  • Oracle Enterprise Performance Management System - 11.2.9.0.000 for Linux x86-64
  • Oracle Enterprise Performance Management System - Client Installers 11.2.9.0.000 for Microsoft Windows x64 (64-bit)
  • Oracle Data Relationship Management 11.2.9.0.000 for Microsoft Windows (64 bit)

    Release 11.2.9 will not have an Installation and Configuration guide. Complete instructions for installing EPM Products are mentioned in the Oracle Enterprise Performance Management System Installation and Configuration Guide for Release 11.2.8, which is the latest full installer. See Installing EPM System Products for more details.

Release 11.2.9 (Release 11.2, Update 9) also includes:

  • ADF Patches
  • Weblogic Patches
  • Java Updates

Thursday, April 28, 2022

Hyperion 11.2.9 Maintenance Release update Apr 28, 2022

 https://www.iarchsolutions.com/news/applying-the-1129-maintenance-release

A good blog to check out by iArch

Hyperion 11.2.9 - Things to know !!

Released April 28, 2022 

EPM 11.2.9.0 New features:

****EPM System Release 11.2.9 can only be applied to Release 11.2.8.***
- You must update to 11.2.8.0 first before applying 11.2.9.0.
- Application of 11.2.9 is slightly different
- Release 11.2.9 applies a set of OPatches for all EPM system components on your environment. Oracle recommends that you apply the entire set using the ApplyUpdate utility.
- Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.9 product Opatches together, using the ApplyUpdate script. However, you can also apply selected OPatches based on your operating system
environment:

• EPM System Release now installs:
– Essbase Release 11.1.2.4.047
– Java 8 Update 321
– WebLogic Patch Set Update 12.2.1.4.220105
– ADF Bundle Patch 12.2.1.4.211221
• Added support for enabling HFM Server Connection with an SSL-Enabled Oracle
Database. See Enabling HFM Server Connection with an SSL-Enabled Oracle
Database for more details.

Tuesday, April 19, 2022

Oracle EPM Automate - System Status Website

As companies implement Oracle EPM Cloud components (FCC, Planning, ARC, etc.), EPM Automate is almost always a part of the process. 

Typically with data loads and backups, which all of the components need, but also restructures, database refreshes, and more. Along with the growth in these scripts is the need to communicate to users and admins the status of everything. 

Each script can send an email or a text with the status of each run. But with hourly data loads, backups, restructures, regression tests, etc. the number of emails can easily become overwhelming. 

An email or text should be sent if there are problems, but if things are going well, is a deluge of emails really the right solution?

As an alternative, a simple webpage can do the trick. Since EPM Automate typically runs on a server, the server can also serve up a webpage with the status of each job. 



The basic steps are to have each script write the status to a web page. 

Then use an overall web page that incorporates all of the individual status pages. 

Users can access the one overall page to see where everything is in real time.

Monday, April 4, 2022

Hyperion how to generate a deployment report after 11.2 install

 To generate a deployment report:

  1. Open a command line window and navigate to EPM_ORACLE_INSTANCE/bin.
  2. Run the command epmsys_registry.bat|.sh report deployment.

    By default, the report is saved as EPM_ORACLE_INSTANCE /diagnostics/reports/deployment_report_YYYYMMDD_HHMMSS.html.

    You can add an optional file name argument to the command to save the HTML report with a different file name or location. For example, this command saves the report as c:/epm_setup/epm_deployment.html:

    epmsys_registry.bat|.sh report deployment c:/epm_setup/epm_deployment

Hyperion 11.2 Start and Stop script using a single script

 

Starting and Stopping EPM System Using a Single Script

Use a single script to start or stop all Oracle Enterprise Performance Management System services. EPM System Installer installs a single start script in EPM_ORACLE_INSTANCE /bin, called start.bat | start.sh .

Running the single start script on a machine in your EPM System deployment starts all EPM System services installed on that machine. The single start script works by calling the individual start scripts for every product.

The user running the start script should be a member of the Administrators group.

To start EPM System services:

  1. From the Start menu, select Oracle EPM System, and then Start EPM System.
  2. Run this start script on each machine in your environment.

After the single start script completes, you can run Oracle Hyperion Enterprise Performance Management System Diagnostics to determine which services on a machine are running. See Validating the Installation and Verifying Deployment.

Note:

To stop EPM System services: A single stop script is also installed in EPM_ORACLE_INSTANCE /bin, called stop.bat | stop.sh . Running the stop script on a machine in your EPM System deployment stops all EPM System products on that machine. To stop services, from the Start menu, select Oracle EPM System, and then Stop EPM System.

Wednesday, March 2, 2022

Using Essbase 21c with EPM System

Using Essbase 21c with EPM System

Beginning with Release 11.2.8, you can use Oracle Hyperion Planning and Oracle Hyperion Profitability and Cost Management applications from an Oracle Enterprise Performance Management System deployment to report on Oracle Essbase cubes in a Oracle Essbase 21c deployment integrated with EPM Shared Services.

Installation considerations in a Linux distributed environment:

  • Machine 1 - Install and configure all the EPM system products such as Hyperion Shared Servics, Financial Reporting, PLanning and Calculation Manager.
  • Machine 2 - Install and configure HPCM and Essbase 21c. Set up Essbase 21c and register it to Hyperion Shared services running on Machine 1.

    Note:

    • Hyperion Profitability and Cost Management must be Installed and Configured on Machine 2 along with Essbase 21.2.2 where APS is up and running.
    • If you choose to use Essbase 21c instead of Essbase 11.1.2.x, ensure that you perform an upgrade only via LCM to import your Planning applications.
    • Essbase 21c is only supported in NON_HYBRID mode.

Tuesday, January 4, 2022

Hyperion Essbase Patch Set Update 11.1.2.4.047

The Hyperion Product Management recently advised the release of Patch Set Updates (PSU) for Oracle Hyperion Essbase 11.1.2.4.x.

These PSU downloads are available from the  My Oracle Support > Patches & Updates section.

Hyperion Essbase Server 11.1.2.4.047

Hyperion Essbase Client 11.1.2.4.047

Hyperion Essbase Administration Services 11.1.2.4.047

  • 33485370 - Hyperion Essbase Administration Services Server
  • 33485372 - Hyperion Essbase Administration Services Client MSI 

Hyperion Analytic Provider Services 11.1.2.4.047

  • 33485394 - Hyperion Analytic Provider Services

README FILE:

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes the supported paths per component, along with a full list of the defects fixed, additional support information, prerequisites, details for applying patch and troubleshooting FAQ's. It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file.

The Readme file is available from the Patches & Updates download screen for each of the Hyperion Essbase components.

Recommendations:

Caution: Oracle recommends using the same version of all Essbase portfolio products (Essbase, Essbase Administration Services, Hyperion Provider Services, and Essbase Studio) and components (server, client, runtime client, API, and JAPI). When only some Essbase portfolio products are included in a patch release, the last released versions of the products that are not included in the patch are supported.

Essbase Administration Services 11.1.2.4.047, Provider Services 11.1.2.4.047, and Essbase Studio 11.1.2.4.045 are supported for use with Essbase 11.1.2.4.047.  Furthermore, Essbase Runtime Client needs to be updated on systems that Essbase Administration Services is installed starting with this patch.

Recommendation: After you apply a patch within the same release codeline, Oracle recommends as a best practice that you export the data from your databases, clear the data from the databases, and then reload the data.

Unsupported Features:

  • MaxL Perl Module Will No Longer Be Supported in 12.2.1.3.0
  • Essbase Native Security Mode Is No Longer Supported

Defects Fixed in this Patch:

  • 33606460 - ANY RETRIEVE ON TBLAST MEMBER IS HAVING PERFORMANCE ISSUES
  • 30043421 - DATA EXPORT IS NOT EXPORTING DATA AT BASE MEMBER INSTEAD AT IMPLIED SHARING MEMBER
  • 33060864 - PORT TO 11.1.2.4.046: 32901984 - REQUEST FIX PLANNING BUG 32674898
  • 33434920 - PORT TO 11.1.2.4.047: 31645024 - ESSBASE ASO ALLOCATION RUNNING SLOW IN 11.1.2.4 COMPARED TO 11.1.2.1
  • 31804508 - SIGNIFICANT PERFORMANCE LOSS IN RUNNING CERTAIN MAXL SCRIPTS AFTER APPLYING ESSBASE .039 PATCH

======================================================================================

For your references: