Purpose

This document includes important, late-breaking information about this release of Oracle Enterprise Performance Management System. Review this Readme thoroughly before installing EPM System.

Overview

This Quarterly Release Update is distributed as an OPatch comprising OPatches for individual EPM system components. Release 11.2.11 is a cumulative update and includes all updates from Release 11.2.10. This release update is applied on top of Release 11.2.8.x or Release 11.2.9.x or Release 11.2.10.x. 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.11 product OPatches together, using the ApplyUpdate script. See Applying Release 11.2.11 for more details.
  • Oracle Data Relationship Management (DRM) is installed separately and will continue as a full install release. See Installing Data Relationship Management in the Oracle Data Relationship Management Suite Installation Guide for instructions.

Release 11.2.11 (Release 11.2, Update 11) includes the following deliverables:

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

    Release 11.2.11 will not have an Installation and Configuration guide. See Installing EPM System Products in Oracle Enterprise Performance Management System Installation and Configuration Guide for instructions.

New Features

This section includes new features in this release. To review the list of new features from earlier releases, use the Cumulative Feature Overview tool. This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of new feature descriptions. This tool is available here: https://apexapps.oracle.com/pls/apex/f?p=20620:1:0

Release 11.2.11 includes the following new features:

Note:

Essbase version (11.1.2.4.047) remains unchanged in Release 11.2.11.
  • Certification of Essbase 21c (Version 21.4.0, Windows and Linux).
  • Java 8 Update 341.
  • WebLogic Patch Set Update 12.2.1.4.220711.
  • Fusion Middleware (FMW) Third Party Bundle Patch Set Update 12.2.1.4.220616.
  • OHS Patch Set Update 12.2.1.4.220608.
  • There are no April/July patches for ODI in Release 11.2.11.
  • Added a new System Settings option Workbench Export to File Format to export .XLS and .CSV files in FDMEE. See Setting System-Level Profiles.
  • Beginning with Release 11.2.11, the version numbers are displayed in "11.2.11.0.000" format under Help > About Oracle Enterprise Performance Management System Workspace, Fusion Edition. To view the build number, navigate to the status page for your deployment, for example, http://epm.example.com:19000/workspace/status. Build number is displayed as displayVersion for a logged in session, for example, displayVersion=11.2.11.0.000.04.
  • For all the new features in Release 11.2.10, see New Features: 11.2.10.

Supported Platforms

This update can be applied to all platforms supported in release 11.2.11.0.000. See the Oracle Enterprise Performance Management System - Certification Matrix for a list of supported platforms. This update supports all locales supported in Release 11.2.8.0.000.

Supported Paths

Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.11 product Opatches together, using the ApplyUpdate script. EPM System Release 11.2.11 can only be applied to Release 11.2.8.x or Release 11.2.9.x or Release 11.2.10.x. If you are updating from an earlier release, you must first update to Release 11.2.8.

  • EPM System updates are released on a quarterly basis, generally in January, April, July, and October.
  • Updates include changes for all embedded components, such as WebLogic and Java, as needed.
  • Updates are applied in place.
  • Any customer patches that were released are rolled into the next update.
  • Updates are expected to be easy to apply and have minimum impact for you to absorb.

Installing EPM for the first time

  1. Install Release 11.2.8: See Installing EPM System Products in Oracle Enterprise Performance Management System Installation and Configuration Guide for instructions.

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

    For the list of files available for download in Release 11.2.11, see Overview.

    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.11: See Applying Release 11.2.11 for more details.

Updating from Release 11.2.x

Oracle Enterprise Performance Management System Release 11.2.11 can be applied to Release 11.2.8.x or Release 11.2.9.x or Release 11.2.10.x. 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.11: See Step 2: Download Release 11.2.11 in Installing EPM for the first time for more details.

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

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

  1. Install Release 11.2.8: See Installing EPM System Products in Oracle Enterprise Performance Management System Installation and Configuration Guide for instructions.

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

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

Applying and Rolling Back Release 11.2.11

Prerequisites

  1. Disable the anti-virus software before you apply Release 11.2.11 to your environment. Ensure that you have the anti-virus software disabled for the entire duration of the update process. Anti-virus software can be re-enabled when the update is complete.
  2. Stop services:
    • Oracle Enterprise Performance Management System services
    • Node Manager Windows Service and Oracle HTTP Server, if you are using Oracle HTTP Server as your web server
    • WebLogic Administration Server

    For information about stopping services, see Starting and Stopping EPM System Products in Enterprise Performance Management System Installation and Configuration Guide .

  3. Back up these folders:
    • EPM Oracle Home. The default EPM Oracle home location is MIDDLEWARE_HOME/EPMSystem11R1.
    • EPM Oracle Instance. The default location for the EPM Oracle Instance is MIDDLEWARE_HOME/user_projects/epmsystem1.

    You can delete these folders after you apply the update and validate the installation.

  4. Back up the keystores from:
    • MIDDLEWARE_HOME\jdk\jre\lib\security\cacerts
    • MIDDLEWARE_HOME\EPMSystem11R1\common\JRE\Sun\1.8.0\lib\security\cacerts

    Note:

    Ensure that you restore the backed up keystores (cacerts) after applying the update to Release 11.2.11.

Applying Release 11.2.11

Release 11.2.11 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.

Ensure that you meet all the prerequisites before you apply Oracle Enterprise Performance Management System Release 11.2.11 to your environment. See Prerequisites for more details.

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.

For the list of deliverables in Release 11.2.11 (Release 11.2, Update 11), see Overview:

Unzip the files into /download_location.

  • Use a zip file extraction program that can handle long path names, such as 7-Zip.
  • If you are prompted that any files or common components already exist, click Yes to overwrite the files.
  • Unzip to a directory with no spaces in the name.
  1. To Apply Release 11.2.11 (Release 11.2, Update 11):
    1. On Windows: Navigate to the directory where you extracted the ZIP files. Launch PowerShell from the Start Menu and run the following script from the directory where you extracted the ZIP file. For example, navigate to 11.2.11.0-Update-Win directory and run the following script.
      .\ApplyUpdate.ps1 <MIDDLEWARE_HOME>
    2. On Linux: Navigate to the directory where you extracted the ZIP files. Run the following script from the directory where you extracted the ZIP file. For example, navigate to 11.2.11.0-Update-Linux folder and run the following script:
      ./ApplyUpdate.sh <MIDDLEWARE_HOME>
  2. You must now start all the services. For information about starting services, see Starting and Stopping EPM System Products in Enterprise Performance Management System Installation and Configuration Guide.

To identify any EPM patch conflicts before applying the quarterly update, enter the following command:

  • On Windows: .\ApplyUpdate.ps1 <MIDDLEWARE_HOME> -verify
  • On Linux: ./ApplyUpdate.sh <ORACLE_HOME> -verify

Rolling Back Release 11.2.11

Ensure that you meet all the prerequisites before you proceed with the rollback feature. See Prerequisites for more details.

The rollback feature allows you to rollback all the OPatches except the following:

  • JDK Patches
  • Weblogic CPU Patches
  • OVD Patch
  • OHS Patch
  1. To Rollback the update:
    1. On Windows: Navigate to the directory where you extracted the ZIP files. Launch PowerShell from the Start Menu and run the following script from the directory where you extracted the ZIP file. For example, navigate to 11.2.11.0-Update-Win directory and run the following script:
      .\RollbackUpdate.ps1 <MIDDLEWARE_HOME>
    2. On Linux: Navigate to the directory where you extracted the ZIP files. Run the following script from the directory where you extracted the ZIP file. For example, navigate to 11.2.11.0-Update-Linux folder and run the following script:
      ./RollbackUpdate.sh <MIDDLEWARE_HOME>
  2. You must now start all the services. For information about starting services, see Starting and Stopping EPM System Products in Enterprise Performance Management System Installation and Configuration Guide.

Note:

If Essbase OPatches are applied externally, the rollback feature will update the Essbase version to 11.1.2.4.033. If you want to further upgrade the version, note that you must apply the required OPatch manually.

Verifying Status

You can check the status of the ApplyUpdate or Rollback script by following one of the steps below:

  1. Open Oracle Enterprise Management System Workspace, click Help > About Oracle Enterprise Performance Management System Workspace, Fusion Edition > Show Details.
  2. Check the inventory for Oracle Enterprise Performance Management (EPM) OPatches. To check the inventory for EPM OPatches, enter the following command in one line:

    Before running this command, ensure that you change the directory from the command line to : <MIDDLEWARE_HOME>\EPMSystem11R1\OPatch

    • On Windows: opatch lsinventory -oh <MIDDLEWARE_HOME>\EPMSystem11R1 | findstr /i /L /c:"Patch"
    • On Linux: opatch lsinventory -oh <MIDDLEWARE_HOME>\EPMSystem11R1 | grep "Patch[ ][ ]" 
    Sample Output:
D:\Oracle\Middleware\EPMSystem11R1\OPatch lsinventory -oh D:\Oracle\Middleware\EPMSystem11R1\OPatch | findstr /i /L /c:"Patch  "
Patch  33727616     : applied on Sun Feb 20 23:39:56 PST 2022
Patch  33678607     : applied on Sun Feb 20 23:36:01 PST 2022
Patch  33093748     : applied on Sun Feb 20 23:35:18 PST 2022
Patch  32720458     : applied on Sun Feb 20 23:34:51 PST 2022
  3. Check the inventory for Oracle Fusion Middleware (FMW) OPatches. To check the inventory for FMW Opatches, enter the following command in one line:

    Before running this command, ensure that you change the directory from the command line to : <MIDDLEWARE_HOME>\OPatch

    • On Windows: opatch lsinventory -oh <MIDDLEWARE_HOME> | findstr /i /L /c:"Patch"
    • On Linux: opatch lsinventory -oh <MIDDLEWARE_HOME> | grep "Patch[ ][ ]" 
    Sample Output:
Oracle Interim Patch Installer version 13.9.4.2.7
OPatch version    : 13.9.4.2.7
OPatch detects the Middleware Home as "D:\Oracle\Middleware"
Patch  33727616     : applied on Tue Apr 12 19:02:01 EDT 2022
Unique Patch ID:  24578917
Patch description:  "WLS PATCH SET UPDATE 12.2.1.4.220105"
Patch  33678607     : applied on Tue Apr 12 18:59:04 EDT 2022
Unique Patch ID:  24558585
Patch description:  "RDA release 20.4-20211126 for OFM SPB"
Patch  33093748     : applied on Tue Apr 12 18:58:36 EDT 2022
Unique Patch ID:  24325771
Patch description:  "One-off"
Patch  32720458     : applied on Tue Apr 12 18:58:19 EDT 2022
Unique Patch ID:  24558359
Patch description:  "JDBC 19.3.0.0 FOR CPUJAN2022 (WLS 12.2.1.4, WLS 14.1.1)"
Patch  1221412      : applied on Tue Apr 12 18:57:54 EDT 2022
Unique Patch ID:  24516660
Patch description:  "Bundle patch for Oracle Coherence Version 12.2.1.4.12"
Patch  33697227     : applied on Tue Apr 12 18:54:58 EDT 2022
Unique Patch ID:  24560598
OPatch succeeded.
  4. Check the inventory for Oracle HTTP Server (OHS) OPatches. To check the inventory for OHS Opatches, enter the following command in one line:

    C:\Oracle\Middleware\ohs\OPatch>opatch.bat lsinventory -oh C:\Oracle\Middleware\ohs | findstr /i /L /c:"Patch"

The log file details and location of the files are described in the table below:

Table 1-1 Log Names and Location

Script Summary Log File Name Detail Log File Name Location
ApplyUpdate ApplyUpdateSummary.log ApplyUpdateDetail-<Day>.<DD>.<MM>.<YYYY>-<HH>.<MI>.<SS>.log <EPM_ORACLE_HOME>/diagnostics/logs/install/
RollbackUpdate RollbackUpdateSummary.log RollbackUpdateDetail-<Day>.<DD>.<MM>.<YYYY>-<HH>.<MI>.<SS>.log <EPM_ORACLE_HOME>/diagnostics/logs/install/

Summary log contains the status of each product OPatch and detail log contains the detailed information about the status of each OPatch applied along with the OPatch output. For more details on OPatches Common Error Messages, tips and troubleshooting, see Tips and Troubleshooting for more details.

Optional: Applying Individual OPatches

Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.11 product Opatches together, using the ApplyUpdate script. See Applying Release 11.2.11 for more details.

However, you can also apply selected OPatches based on your operating system environment:

Note:

It is recommended to take a back up of the original configure<OS>.properties file before you edit the properties file for the desired OPatches.
  1. From the directory where you downloaded and extracted the 11.2.11.0-Update-<OS> folder, open configureWindows.properties or configureLinux.properties file based on your operating system.
  2. In the configure<OS>.properties file, include only those products that you want to apply. For example, if you want to apply Oracle Hyperion Calculation Manager OPatch, ensure that the entry CALC=34522671 is present in the configure<OS>.properties file. The list of individual products and their OPatch IDs in the configure<OS>.properties file are listed below:
    • CALC=34522671
    • FCM=34487730
    • FDMEE=34489078
    • FR=34496942
    • HFM=34401036
    • HP=34505517
    • HPCM=34480803
    • HSS=34454973
    • Infra=34456028
    • TAXPROV=34509600
    • Workspace=34459461

    Note:

    • Oracle Hyperion Tax Governance is included in Oracle Hyperion Financial Close Management (FCM) OPatch.
    • Oracle Hyperion Profitability and Cost Management OPatch cannot be applied if you have applied any of the following OPatches:
      • 33832401 – Release Update Exception 11.2.8.0.500
      • 34049504 – Release Update Exception 11.2.9.0.500
      • 34315263 – Release Update Exception 11.2.10.0.500
    For more details on individual EPM system products, OPatch ZIP file names and OPatch IDs, see OPatch Dependencies and Details.
  3. Run the ApplyUpdate Script to apply the individual OPatch:
    • On Windows: 
      ApplyUpdate.ps1 <MIDDLEWARE_HOME>
    • On Linux: 
      ApplyUpdate.sh <MIDDLEWARE_HOME>

    Note:

    Refer to your individual OPatch Product Readme for more information.

OPatch Dependencies and Details

The following table lists the set of OPatches and dependencies for individual EPM system components:

Table 1-2 OPatch Details

Product Product OPatch ID OPatch Dependency - Component OPatch Dependency - ID
Oracle Hyperion Calculation Manager (CALC) 34522671 NA NA
Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) 34489078 NA NA

Oracle Hyperion Financial Close Management (FCM)

Note: Oracle Hyperion Tax Governance is included in this OPatch.

34487730 NA NA
Oracle Hyperion Financial Management (HFM) 34401036 ADF 33697227
WebLogic 33751264
Oracle Hyperion Financial Reporting (FR) 34496942 NA NA
Oracle Hyperion Planning (HP) 34505517 Oracle Hyperion Essbase Runtime Client 11.1.2.4.047 Patch Set Update (PSU) 33485386
Oracle Hyperion Essbase Server 11.1.2.4.047 Patch Set Update (PSU) 33485383
ADF CPU 33697227
Oracle Hyperion Profitability and Cost Management (HPCM) 34480803 NA NA
Oracle Hyperion Shared Services (HSS) 34454973 NA NA
Oracle Hyperion Infrastructure (Infra) 34456028 NA NA
Oracle Hyperion Tax Provision (TAXPROV) 34509600 NA NA
Oracle Hyperion Enterprise Performance Management Workspace (Workspace) 34459461 NA NA

Error Correction Policy

This topic outlines the error correction policies for Oracle Enterprise Performance Management (EPM) Release 11.2.x.

For information on the Oracle Enterprise Performance Management Error Correction Policy, visit these My Oracle Support articles:

  • Oracle Enterprise Performance Management (EPM) 11.2 Software Error Correction Policy [Doc ID 2749950.1]
  • Oracle Enterprise Performance Management (EPM) Release 11.2 Grace Periods for Error Correction [Doc ID 2627593.1]

Defects Fixed

Release 11.2.11 resolves the following defects:

Table 1-3 Defects Fixed in 11.2.11

Product Defect Number Decsription
Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) 34514595 DRM To FDMEE Mapping Sync failing on Linux
34299757 Issue In FDMEE Export File.
Oracle Hyperion Financial Close Management 34615725 Close Manager/Tax Operations - Allow saving of Day Labels
34326503

Supplemental Data Manager/Tax Supplemental Schedules Correctly display column names in the Data Set summary view
34457707

Close Manager/Tax Operations - Ensure correct schedule will be closed
34353422

Close Manager/Tax Operations - Ensure end date appears for all completed tasks
34425162 Reconciliation Manager - Ensure aging violation indicator is always set correctly
Oracle Hyperion Financial Management 31625183 MERGE REQUEST ON VERSION 11.2.11.0.000 FOR 30503050 - SECURITY CLASS ACCESS IS NOT UPDATING PROPERLY FROM ASSIGN ACCESS CONTROL
32463987 HFM DATA FORM RIGHT CLICK SCROLLING ISSUE
32601647 UNABLE TO OPEN HFM APPLICATIONS AFTER UPGRADE FROM 11.1.2.3 TO 11.2.3
33175800 CONSOLIDATION PERFORMANCE ISSUE AFTER UPGRADING FROM 11.2.2 TO 11.2.5
33374184 WDEF RIGHT CLICK CONTEXT MENU OPTIONS ARE NOT GETTING FOCUSED WHEN MOVING MOUSE OVER
33505360 USERS BY GROUP SECURITY REPORT ERROS WITH EPMHFM-65962 EVEN AFTER APPLYING RUE
33658664 HFM SHOULD PREVENT USERS FROM CREATING JOURNALS FOR ENTITIES TO WHICH THEY LACK ACCESS
33698888 WHEN LOADING METADATA MODIFICATIONS TO THE ENABLECUSTOMAGGR PROPERTIES FOR DYNAMIC ACCOUNTS ARE IGNORED
33789415 FAILED DATA EXTRACTS TO DATABASE STILL SHOW AS COMPLETED TASKS IN TASKFLOW, TASK AUDIT AND RUNNING TASKS
33849807 TO CAPTURE SMART VIEW RETRIEVAL TIME IN TASK AUDIT
33885215 CELL LINE ITEM DETAILS - CANNOT INPUT MULTI PERIOD
33973463 RUNNING TASK PROGRESS BAR IS NOT UPDATING PROPERLY WHEN CONSOLIDATIONTHREADINGSCHEME IS SET TO 6 OR 7
34247650 UNLOCKING MULTIPLE PERIODS SELECTED USING SHIFT WILL ONLY UNLOCK THE LAST PERIOD
34256714 DATA IMPORT WITH HEADER FAILING WITH ERROR ERROR: NO SUCH MEMBER
34469937 HFM WEB NOT CLOSING OPEN FILE HANDLE FOR JOURNAL EXTRACTS GENERATED FROM TASKFLOW
34489314 UNABLE TO USE SSL ENABLED DSN TO EXTRACT DATA FROM TASKFLOW
34493017 EA EXTRACT OF ACCOUNT NOT REFLECTING AS EXPECTED FOR ISICP
Oracle Hyperion Financial Reporting 34389223 Format Chart utility has an ADF error in the Element style tab.
34374794 A report grid becomes a linked grid when saving the report.
34318378 Fonts selected to be used in a report appear as bold in HTML mode and in Web Studio but work in PDF.
34300434 Fonts selected to be used in a report appear as italic in HTML mode and in Web Studio but work in PDF.
34294780 Unable to enter a new annotation in an FR report when opening new report tabs.
34228214 After upgrading, some reports created in the previous version appear with italic fonts that cannot be changed.
34054242 The PeriodOffset function for HFM does not work in the web studio member selector.
34049309 Reports migrated with LCM appear with bold italics in HTML preview.
33623561 User Point Of View for Alias Table on Grid Properties does not show the alias on the report.
17603383 The shading in an FR text box is lost when exporting to Excel.
Oracle Hyperion Infrastructure 34447775 Essbase start up issue when OHS is configured is fixed
33625815 Issue Fixed for Email alerts from task manager when SMTP credentials are not present.
Oracle Hyperion Planning 34186847, 34037597, 34020220, 34181571 When a user opens Planning data form, save, refresh and other data form related icons may appear disabled.
34358010 If Period dimension members are renamed to numeric names, import of Scenario dimension may fail.
34227622 Planning metadata export may fail if the user running the export has "." in user-name.
33997226 Planning data form may not open if suppress missing data on columns is enabled.
33841498 Import of exchange rate tables may not work from Planning web.
34002354 If a business rule has GetStartYear("ScenarioName") or GetEndYear("ScenarioName") functions in the script, the rule may not validate correctly.
34192599 User may not receive warning message related to SmartView version when connecting to Planning from SmartView even after the property Smart_View_Display_Warning is set.
Oracle Hyperion Shared Services 33625815 EMAIL ALERTS FROM TASK MANAGER STILL DO NOT WORK AFTER APPLYING 11.2.6 RUE FOR BUG 33312214
Oracle Hyperion Enterprise Performance Management Workspace 33811463 Blank workspace screen after configuring OAM SSO.

See Defects Fixed: 11.2.0 - 11.2.10 for the list of cumulative defects fixed starting from Release 11.2.0.

Known Issues

Release 11.2.11 includes the following known issue. See Known Issues: 11.2.0 - 11.2.10 for the list of cumulative known issues starting from Release 11.2.0.

Table 1-4 Known Issues in 11.2.11

Product Defect Number Description
Oracle Hyperion Profitability and Cost Management 34510912 The Native option for the SPStatMethod installation preference for Standard Profitability applications is not functional in this patch.
34630290 Clustered environments including the Standard Deployment are not supported in this patch. If you need to install Profitability and Cost Management 11.2.11 on a clustered environment, contact Oracle Support through My Oracle Support for a patch that supports clustering.

Tips and Troubleshooting

Tips and troubleshooting topics are listed in the Installation and Configuration Troubleshooting Guide.

All Oracle Enterprise Performance Management System guides are available in the library on the Oracle Help Center: https://docs.oracle.com/en/applications/?tab=8.

Documentation Updates

Accessing EPM System Product Documentation

Find the latest Oracle Enterprise Performance Management System product guides in the Oracle Help Center (https://docs.oracle.com/en/). To access documents to view or download, click the Applications icon. In the Applications Documentation window, select the Enterprise Performance Management tab, and then look for your release in the Enterprise Performance Management list.

You can also find deployment-related documentation on the Oracle Technology Network (http://www.oracle.com/technetwork/index.html) and on the Oracle Software Delivery Cloud website (http://edelivery.oracle.com/EPD/WelcomePage/get_form).

Appendix

New Features: 11.2.8 - 11.2.10

This section includes the list of cumulative new features starting from Release 11.2.8. You can also review the list of new features from earlier releases, use the Cumulative Feature Overview tool. This tool enables you to identify the products you own and your current implementation release. With a single click, the tool quickly produces a customized report of new feature descriptions. This tool is available here:https://apexapps.oracle.com/pls/apex/f?p=20620:1:0

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.
  • Added -verify option support to the ApplyUpdate command. This option is used to identify any EPM patch conflicts.
  • Support for Console mode will be removed from EPM System Configurator in the next full installer of EPM Release.
  • Wallet creation section in the EPM Security guide is now updated. See Enterprise Performance Management System Security Configuration Guide 11.2 for more details.
  • Added support to enable Automated and Event Monitoring Integrations for Oracle Hyperion Financial Close Management.
  • Added support to Install and Configure SOA Suite 12c for Oracle Hyperion Financial Close Management. See Enterprise Performance Management Installation and Configuration Guide for Release 11.2.8 for detailed instructions.

Release 11.2.9 includes the following new features:

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

Release 11.2.8 includes the following new features:

  • EPM System Release now installs:
    • Essbase Release 11.1.2.4.045
    • Java 8 Update 301
    • Fusion Middleware Patch Set updates including:
      • WebLogic Patch Set Update 12.2.1.4.210330
      • ADR for WebLogic Server 12.2.1.4.0 JULY CPU 2020 for WebLogic Server SPB
      • Bundle patch for Oracle Coherence Version 12.2.1.4.8
      • ADF Bundle Patch 12.2.1.4.210706
  • Log4j is now upgraded to 2.17.1. For more details, see Oracle Support - Doc ID 2828262.1.
  • Planning and Profitability applications now support Essbase 21c (Version 21.2.2).

    Note:

    Essbase 21c (Version 21.2.2) is a Linux only release and it is not supported on Windows environment.
  • Added support for MSAD 2019.
  • Added support for Enabling User Access Control (UAC).
  • Added support for Delegated List Functionality from Shared Services Console.
  • Direct updates to 11.2.8 are now supported from all the previous releases (starting from Release 11.2.2).

Defects Fixed: 11.2.0 - 11.2.10

Table 1-5 Defects Fixed in 11.2.10

Product Defect Number Decsription
Oracle Hyperion Infrastructure 33451229 Unable to perform silent configuration of HFM Cluster.
Oracle Hyperion Financial Close Management 34094859 Enhanced Task Audit Trail report to handle a larger amount of data.
Oracle Hyperion Profitability and Cost Management 33976548

Profitability and Cost Management applications write various runtime statistics during the calculation processes. For large Standard Profitability applications, writing these statistics can add considerable time to the calculation. In the previous release update, a new installation preference was introduced which allowed bypassing the posting of statistics for Standard Profitability applications. This release update adds the option to write the runtime statistics using a different more efficient method. It uses the same installation preference but with a new value.

To enable writing of runtime statistics for Standard Profitability applications using this new more efficient method, execute this statement in SQL Developer or another SQL tool as the schema/database owner and commit the change, then restart the Profitability and Cost Management service:

For Oracle database: 

INSERT INTO HPM_INSTALLATION_PREFERENCE 
(ID, NAME, VALUE, HPM_INSTALLATION_ID, CREATED_TIMESTAMP, CREATED_USERID, MODIFIED_TIMESTAMP, MODIFIED_USERID, DISPLAY_ORDER)
VALUES (47, 'SPStatMethod', 'Native', 1, SYSDATE, 'INIT', SYSDATE, 'INIT', 47);

For Microsoft SQL Server Database: 

INSERT INTO HPM_INSTALLATION_PREFERENCE 
(ID, NAME, VALUE, HPM_INSTALLATION_ID, CREATED_TIMESTAMP, CREATED_USERID, MODIFIED_TIMESTAMP, MODIFIED_USERID, DISPLAY_ORDER)
VALUES (47, 'SPStatMethod', 'Native', 1, getDate(), 'INIT', getDate(), 'INIT', 47);
To revert this setting, delete the same row.
Oracle Hyperion Shared Services 34117795 If using Non-English, buttons on Migration status report page are small.
34108076 Email stage action fails when Japanese variables are used in HFM task flow creation on Japanese env.
Oracle Hyperion Financial Close Management 34094859 Enhanced Task Audit Trail report to handle a larger amount of data.
Oracle Hyperion Financial Management 15946914 NLS:BIDI:POV Square boxes are not shown.
17550726 Issues during Manual Data Entry on WEBDEF using 11.1.2.3.
22392296 Unable to scroll using scroll wheel in Firefox in Assign Access Control.
28035961 HFM 11.1.2.4 custom links sometimes don't work due to CR / LR chars in SSO token.
31146086 Journal report generating blank preview report if it doesn't have description.
31262916 Replacing \N character with underscore does not help when working with cell text.
31366064 HFM DSN database name field accepts only 50 characters and sending only SID connection not service name.
31542274 Level hierarchy does not collapse and expand correctly in a grid
31869483 Task lists and favorites in HFM 11.2.2 do not hold their position.
32804964 Consolidation in running tasks page stops updating for long period of time at 20-30% then suddenly jumps to 100%.
33175800 Consolidation performance issue after upgrading from 11.2.2 to 11.2.5.
33439961 TASK AUDIT shows the information that misleading the activity being run by a user.
33715034 Prevent overlapping consolidations from running in smartview based on the ALLOWOVERLAPPINGCONSOLIDATIONOVERRIDE setting.
33788166 Provisioning manager roles are missing for users while extract and loading the .sec file.
34006378 HFM 11.2.8 non-admin unable to use calculate button in data form: "EPMHFM-1659: YOU DO NOT HAVE THE PROPER ACCESS RIGHTS TO PERFORM THIS TASK"
34017995 INTERCOMPANY - ERROR in entity filter selection.
34060379 Unable to connect to TLS-enabled database when create DSN by using SSL parameters.
34135875 Unable to open HFM application after upgrade from11.1.2.4 TO 11.2.8: "AN UNKNOWN ERROR HAS OCCURRED IN THE HSVDSMEMBERLISTS OBJECT. [[]]"
34170218 Unable to open HFM application in 11.2.8.2 after upgrade from 11.1.2.4.
34178892 DB LINK does not appear in HFM import application on 11.2.7.
34200997 "EPMHFM-1659: YOU DO NOT HAVE THE PROPER ACCESS RIGHTS TO PERFORM THIS TASK" when performing calculate or force calculate from WDEF icons for non admin user.
Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) 33403091 Role security attributes reset when updating another tab.
34196067 User encountered ADF_Faces error while choose a file
33313175 Receiving multiple ADF errors while working on data management after upgrade to 11.2.5.
Oracle Hyperion Planning 32628016 User may not be able to create financial reports using Descendants function in non-English locale.
33775515 In certain cases, Planning unit promotion process may run for a long time.
33774981

User may get ADF error when navigating to UDA screen in edit member properties UI.
32727120 Page dimension members in Planning data forms may not indent correctly when using the SmartView
32993010 When creating a new member in dimension editor, attribute members assigned to previously added member may get added.
33744785 In certain cases, Outline Load utility may not display correct error message.
33516490 Financial Reports may take a long time to run.
Oracle Hyperion Financial Reporting 29275132 Locally exported FR Reports that contain Annotations with special characters change to different values after an import..
32221189 Copying a group of formatted cells in Web Studio to a target range only applies the format to the first target cell.
33146398 Substitution variables applied as substrings of one another in member selection result in additional printed dollar symbols.
33544481 Related Content links entered into report grids on load-balanced set ups can open with incorrect URLs.
33634818 FR Web Studio displays a border around bars in a bar chart when the width value is set to zero..
33878988 Search Index Maintenance process logs numerous error exception entries.
33905783 Combo chart preview displays circles instead of diamond line markers when using Format Chart refresh.
33938086 Expand All in HTML preview does not display all children members.
33970318 Create utility to gather FR artifacts for audit purposes.
33972033 Format Chart utility for line charts Element Styles does not save selected colors.
33985548 Create a feature in Web Studio that will wrap all of the text in a grid.
33991505 Bar chart color selections reset to the default settings.
33997631 FR Web Studio Format Chart for combo charts does not retain selected colors when switching charts.
33997644 Chart line markers change to circles when previewing the report.
34017657 FR Web Studio Format Chart for line charts does not retain selected colors when switching charts.
34055160 Grid view does not immediately display updated row and column headings values when using Replace value with.
34057578 Adjusted grid cell text vertical alignment is not visible in Web Studio after applying it in the grid editor.
34057589 Web Studio report preview does not reflect conditional formatted grid cells
34068098 Reports migrated from much earlier versions of FR can show a dash instead of a zero when exported to SmartView.
34074460 Web studio preview does not display empty cells formatted with shading and colors.
34144823 An extra line appears before grids in reports that are migrated from earlier versions of FR when exporting to Excel.
34150743 Colors selected for Pie charts do not save properly and return to the default selections.
34182405 User POV is not available for all users when viewing HTML and PDF reports.
34357706 Imported LCM artifacts should show the current date for the modified date.

Table 1-6 Defects Fixed in 11.2.9

Product Defect Number Decsription
Oracle Hyperion Infrastructure 33589968 EPM 11.2.7 / Essbase 11.1.2.4.044 Opmn Errors, Cannot Open LIBESSUTLU.SO
33907002 Applying 11.2.8 Update does not apply Fusion Middleware Patches listed in Readme.
33861399 EPM 11.2.7 Installation removes OCI Library files required for Essbase SQL Interface functionality.
33406589 FDMEE ODI Agent Log missing on Version 11.2.4.0
33805278 Applying 11.2.7 Maintenance Release JAVA doesn't change
Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) 33591510 CHANGE SIGN OPTION GETTING RESET WHEN YOU EDIT SCRIPT IN MAPPING PAGE
Oracle Hyperion Enterprise Management System Workspace 30833231 Default start up options are not shown for selected users in Manage Preferences section
33596553 Accessibility issue, press control plus F6 followed by tab not launching floating frame
Oracle Hyperion Financial Close Management 33974107 Performance improvement for handling high user loads.
33811290 Refresh button will now add new tasks to the Worklist.
33937144 Dataset Dashboard column headers will refresh correctly to match the table data

Table 1-7 Defects Fixed in 11.2.8

Product Defect Number Decsription
Oracle Hyperion Infrastructure 32850663 The cluster name does not get erased during reconfiguration in distributed set up.
33318327 Deployment Options Guide updated with credential map update steps in DR environment.
33542696 The CALC issue in SSO environment has been addressed and security guide is updated with Calc URLs to unprotect.
32506218 The Oracle Enterprise Performance Management System Installation and Configuration Guide is updated with steps for creating the RCU Schema for a Non - System Admin User.
27551746 Import metadata failure in Admin tool for SSL enabled Essbase is now addressed.
33200333 RCU now supports CONNECTION STRING option.
33318327 Deployment Options Guide updated with credential map update steps in DR environment.
33215104 MSAD connection pool settings are retained during restart.
33254858 Update failure because of out of space issue is now addressed.
33343399 MSAD ADVANCED OPTIONS PARAMETERS VALUES ARE RETAINED IN SHARED SERVICES.
33026674 The RCU connection string is now supported.
29302847 The connectivity issues between SSL enabled Essbase SSL and OBIEE admin tool are now resolved.
33298961 After applying an update, the FDMEE restart or redployment is now not required.
Oracle Hyperion Financial Close Management 33156475 Lists of more than 25 Templates or Schedules are now handled correctly.
33291093 Allows the Set Attribute action from the Reconciliation List to update a large number of Reconciliations where the Attributes are marked as Copy To Profile.
33324146 Improved performance while importing Tasks directly into a Schedule.
33387103 Obsolete Preparer names are no longer displayed in the Reconciliation List.
33390345 Tasks will not automatically close when the Task owner, who is also a member of the assignee team, submits without claiming the Task.
33499663 Questions are now in the right order after direct Task import.
33503310 Unexplained differences amounts are now correctly transfered during the LCM operation.
33576925 Auto reconciliation status is now correctly transfered during the LCM operation.
Oracle Hyperion Financial Management 22682291 Loading a RULEFILE now displays correct error messages.
23104733 Security Class for Documents without "OVERRIDE SECURITY CLASS" can now be changed.
27864093 Entity Dynamic Member list on Books POV is now in use.
30740926 Arabic Translations for Menus are now included.
32424617 Journal Module now displays the time correctly after Daylight Savings time change.
33046057 German Translation for description in Function tab is now corrected.
33050981 After submitting the data in Webform, Form picks correct cell information and the POV.
33063515 Dashboard Menu is now created correctly.
33136001 Double Clicking on Data Grid icon or Form icon from Documents tab now opens Grid or Forms.
33155183 Fixed invalid session ID's when users log off.
33162142 HFM Java API now returns correct Journal Create/Posted dates.
33192273 Member list is now extracted correctly.
33193552 Selecting Indentation Totals now works correctly.
33240790 HS.ENTITY.NUMDESCENDANT and HS.ENTITY.NUMBASE now displays the same behavior as in Release 11.1.2.4.
33391695 Server Filter in Data Audit Page now returns the records correctly.
33427715 HFM application now opens correctly after upgrade from 11.1.2.4 to 11.2.6.
33538445 HFM performance is now improved when drilling down the Account hierarchy.
33698811 ICP report now displays correctly.
33700358 HFM cluster preference is enabled for Taskflow submitted tasks.
Oracle Hyperion Financial Reporting 33635024 BI Publisher supported fonts list is now updated. See Release 11.2.8 Documentation Updates.
Oracle Hyperion Planning 31216871, 33056121 When switching between the dimensions in Planning dimension editor, the members displayed for the selected dimension may be incorrect.
31516829 When the alias is set for DTS members, user may not be able to perform ad-hoc analysis in SmartView.
31606396 The message displayed when a user logs-in to the Planning application that is in maintenance mode is changed to accurately describe the correct behavior.
32635299 When the smartlist drop down for a data form cell is open, user may not be able to open smart list drop down for another cell in data form.
32961459 When editing menu of type data form, User may not be able to update data form selection.
33124893 User may not be able to define formula on the row or column of data form.
33274479 If a RTP in business rule has limits defined on it, user may not be able to launch the business rule from SmartView.
33282726 For opening the data form in Planning web, user must hover the mouse over the data form name.
33439141 When the browser zoom level is se to to 100%, the buttons on the Run Time Prompt window of a business rule may not be visible when it is launched from My Tasklists.
33455696, 33551576 If a RTP in business rule has limits defined on it, user may not be able to launch the business rule from SmartView.
33557556 Changing the user variable value at run time from data form will not update the value displayed under user preferences.
Oracle Hyperion Profitability and Cost Management 33651383 The "Run SP Multi POV Calculation" REST API reports displayed the status as Complete after the script generation and prior to script execution. The API now displays the correct status after the calculation has been completed.

Table 1-8 Defects Fixed: 11.2.0 - 11.2.7

Release Link to Defects Fixed
11.2.7 Defects Fixed: 11.2.7
11.2.6 Defects Fixed: 11.2.6
11.2.5 Defects Fixed: 11.2.5
11.2.4 Defects Fixed: 11.2.4
11.2.3 Defects Fixed: 11.2.3
11.2.2 Defects Fixed: 11.2.2
11.2.1 Defects Fixed: 11.2.1
11.2.0 NA

Known Issues: 11.2.0 - 11.2.10

Known Issues in Release 11.2.10

Release 11.2.10 includes the following known issue:

Table 1-9 Known Issues: 11.2.10

Product Defect Number Description
Oracle Hyperion Financial Reporting 34333268 On windows environments, generating audit reports from FR Web Studio may show up a dialog with no indication of the destination where the report is generated. This occurs if the EPM_ORACLE_INSTANCE environment variable is not set.

Workaround: Set the EPM_ORACLE_INSTANCE environment variable using the steps below.

  1. On the Windows taskbar, right-click the Windows icon and select System
  2. In the Settings window, under Related Settings, click Advanced system settings.

  3. On the Advanced tab, click Environment Variables.

  4. Click New to enter a new environment variable.
  5. Enter the following under each label:
    • Variable Name : EPM_ORACLE_INSTANCE
    • Variable value: MIDDLEWARE_HOME\user_projects\epmsystem1 (for example, C:\Oracle\Middleware\user_projects\epmsystem1)
  6. Click OK.
  7. Restart FR services.

Known Issues in Release 11.2.9

There are no known issues in Release 11.2.9

Known Issues in Release 11.2.8

See Known Issues in Release 11.2.8.

Known Issues in Release 11.2.0 - Release 11.2.7

The following table lists out the known issues starting from Release 11.2.0 - Release 11.2.7

Table 1-10 Known Issues: 11.2.0 - 11.2.7

Release Link to Known Issues
11.2.7 Known Issues: 11.2.7
11.2.6 Known Issues: 11.2.6
11.2.5 Known Issues: 11.2.5
11.2.4 Known Issues: 11.2.4
11.2.3 Known Issues: 11.2.3
11.2.2 Known Issues: 11.2.2
11.2.1 Known Issues: 11.2.1
11.2.0 Known Issues: 11.2.0