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 containing OPatches for individual EPM system components. Release 11.2.22 is a cumulative update that includes all updates from Release 11.2.15. This update can be applied on top of any release from 11.2.15 onwards.

For a list of OPatches for individual EPM system components, see OPatch Dependencies and Details.

Oracle recommends that you read the 11.2.22 Readme Guide in its entirety before applying the patch to Release 11.2.22.

Release 11.2.22 (Release 11.2, Update 22) includes the following deliverables:

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

Note:

Release 11.2.22 will not contain an Installation and Configuration guide. See Oracle Enterprise Performance Management System Installation and Configuration Guide for Release 11.2.15 for more information.

EPM System Update and Upgrade Policies

See EPM System Update and Upgrade Policies for more information on update and upgrade policies for Oracle Enterprise Performance Management System.

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.22 includes the following new features:

  • Business Scritping Language (HFM)

    Table 1-1 Script Engine Change Summary

    Category Description
    Product Oracle Hyperion Financial Management
    Change (Effective Release - 11.2.22)
    • Financial Management uses Microsoft VB Script as a scripting language for writing business logic against any application created on Financial Management System.
    • Starting with 11.2.22 release, Financial Management includes the Native Script Engine as an option to use. The default engine is still Microsoft VB Script Engine.
    • As part of this change, a new native scripting language called Business Script Language (BSL) is being introduced to provide built-in support.
    • Business Script Language (BSL) is same as Microsoft VB Script language within the defined scope.
    Recommendation
  • User Directory Configuration change

    Table 1-2 Changes to User Directory Configuration

    Feature Change (Effective Release - 11.2.22) Recommendation
    Configuring Relational Database as User Directory Deprecated and Discontinued
    • Use Native Users for development purposes.
    • Use Lightweight Directory Access Protocol LDAP-based users for production purposes.
    • Migrate to LDAP-based user directories at the earliest opportunity for continued support. See Migrating Users and Groups Across User Directories for more details.
    • Once the migration to supported providers is complete, the external Database directory should be removed from the environment before upgrading to Release 11.2.22.
  • Patches and Updates

    Table 1-3 Bundled Patch Updates

    Component Version
    Java Java 8 Update 451
    WebLogic Patch Set Update 12.2.1.4.250418
    Application Development Framework (ADF) Bundle Patch 12.2.1.4.250416

    Note: Important UI Changes in Recent ADF Patch Update

    To enhance accessibility in EPM applications in alignment with the latest Oracle Accessibility Guidelines (OAG), we recommend applying ADF patch 37836334. This update increases row heights and spacing across various EPM applications, including HFM, FDMEE, Planning, and Reports, to improve usability for users with accessibility needs. While these changes align with accessibility standards, they may result in fewer visible rows per page and increased scrolling.

    Oracle HTTP Server (OHS) 19c Bundle Patch 12.2.1.4.250307
    Oracle Data Integrator (ODI) No patches in this release
  • Dependency Updates

    Table 1-4 Dependency Removal Summary

    Component Change Effective Release
    Microsoft Visual C++ 2010 Dependency removed for EPM
    • No longer installed by EPM.
    • EPM System works correctly with or without it.
    • If already installed, it is not uninstalled automatically. See Removing Visual C++ 2010 for more details.
    11.2.17
  • For details on new features introduced in previous versions, see New Features: 11.2.8 - 11.2.21.

Supported Platforms

Information about system requirements, browser support, supported languages and supported platforms for Oracle Enterprise Performance Management System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Supported Platforms Matrices page on Oracle Technology Network (OTN):

Oracle Enterprise Performance Management System - Certification Matrix.

Supported Paths

Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.22 product Opatches together, using the ApplyUpdate script. If you are updating from an earlier release, you must first update to Release 11.2.15.

  • 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

Before you install and configure, review the installation prerequisites and requirements listed in Installation Prerequisites and Requirements.

Table 1-5 Installing EPM for the First Time

Task Reference
1. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). Optional: Removing Microsoft Visual C++ 2010
2. Install Release 11.2.15 Installing EPM System Products
3. Apply Update to Release 11.2.22 Applying Release 11.2.22
4. Configure Release 11.2.22 Configuring EPM System After Applying an Update

Updating from Release 11.2.x

Before you apply the update to Release 11.2.22, review the prerequisites and requirements listed in Applying an Update Prerequisite Tasks.

Table 1-6 Updating to Release 11.2.22 from 11.2.8

Task Reference
1. Apply Update from Release 11.2.8 to Release 11.2.12 or 11.2.13 or 11.2.14 Applying an Update to EPM System Products
2. Install Update to Release 11.2.15 Installing EPM System Products Using Apply Update
3. Apply Update to Release 11.2.22 Applying Release 11.2.22
4. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). Optional: Removing Microsoft Visual C++ 2010
  1. Restart your machine.

  2. Redeploy all the web applications. (Under HFM, ensure that you check the Configure Application Server option.

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

5. Configure Release 11.2.22 Configuring EPM System After Applying an Update

Table 1-7 Updating to Release 11.2.22 from Versions Earlier than 11.2.8

Task Reference
1. Install Update to Release 11.2.8 Installing EPM System Products Using Apply Update
2. Apply Update from Release 11.2.8 to Release 11.2.12 or 11.2.13 or 11.2.14 Applying an Update to EPM System Products
3. Install Update to Release 11.2.15 Installing EPM System Products Using Apply Update
4. Apply Update to Release 11.2.22 Applying Release 11.2.22
5. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). Optional: Removing Microsoft Visual C++ 2010
  1. Restart your machine.

  2. Redeploy all the web applications. (Under HFM, ensure that you check the Configure Application Server option.

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

6. Configure Release 11.2.22 Configuring EPM System After Applying an Update

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

Table 1-8 Upgrading from Release 11.1.2.x

Task Reference
1. Upgrade from 11.1.2.x to Release 11.2.8 Upgrading EPM System
2. Apply Update from Release 11.2.8 to Release 11.2.12 or 11.2.13 or 11.2.14 Applying an Update to EPM System Products
3. Install Update to Release 11.2.15 Installing EPM System Products Using Apply Update
4. Apply Update to Release 11.2.22 Applying Release 11.2.22
5. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). Optional: Removing Microsoft Visual C++ 2010
  1. Restart your machine.

  2. Redeploy all the web applications. (Under HFM, ensure that you check the Configure Application Server option.

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

6. Configure Release 11.2.22 Configuring EPM System After Applying an Update

Prerequisites

Table 1-9 Prerequisites for Applying Release 11.2.22

Step Description
Disable Anti-Virus Disable the anti-virus software before you apply Release 11.2.22 to your environment and ensure it remains disabled through out the update process. You may re-enable it after the update is complete.
Check for Patch Conflicts To identify any EPM patch conflicts before applying the quarterly update, enter the following command:
  1. On Windows:

    Note: The following script must only be run with Administrator privileges.

    .\ApplyUpdate.ps1 <MIDDLEWARE_HOME> -verify
  2. On Linux:

    ./ApplyUpdate.sh <ORACLE_HOME> -verify

Stop Services 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.

Back Up Folders Back up the following folders before applying the update:
  • 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.

Back Up Keystores 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: A new version of JDK is included with every 11.2.x Release update. During this update process, existing JDK folders are removed and replaced with newer versions. After applying the Release update, you must restore the backed up keystores (cacerts).

To import the keystores, run the following command: Once the keystores are imported, restart all the EPM services for the changes to take effect.

keytool -import -alias alias_name -keystore <path_to_keystore_file> -file <path_to_certificate_file> -storepass keystore_password -trustcacerts

See Configuring SSL-Enabled External User Directories for more information.

TEMP Directory Redirecting the TEMP directory (/tmp) is not supported or feasible during the Apply Update procedure. Ensure the /tmp directory has sufficient space and the necessary permissions. Additionally, confirm that the noexec option is not set on the /tmp directory and remove it if it is enabled.

Applying Release 11.2.22

Release 11.2.22 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.22 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.22 (Release 11.2, Update 22), 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.22 (Release 11.2, Update 22):
    1. On Windows: Launch Windows PowerShell as an Administrator from the Start menu. Navigate to the directory where you extracted the ZIP files and run the following script. For example, navigate to 11.2.22.0-Update-Win directory and run the following script.

      Note:

      • The following script must only be run with Administrator privileges.
      • Before running the following script, ensure that you do not extract any additional OPatch ZIP folders or OPatch ZIP files under 11.2.22.0-Update-Win directory (which contains the ApplyUpdate.ps1 script) in addition to the ZIP files/folders that are already present.
      .\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.22.0-Update-Linux folder and run the following script:

      Note:

      Before running the following script, ensure that you do not extract any additional OPatch ZIP folders or OPatch ZIP files under 11.2.22.0-Update-Linux directory (which contains the ApplyUpdate.sh script) in addition to the ZIP files/folders that are already present.
      ./ApplyUpdate.sh <MIDDLEWARE_HOME>
  2. Redeploy Oracle Hyperion foundation services after applying Release 11.2.22. For remote server, Weblogic Admin server must be up and running to redeploy and start Foundation services.
  3. 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.

Rolling Back Release 11.2.22

Ensure that you meet all the prerequisites before you proceed with the rollback feature.

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

  • JDK OPatches
  • Weblogic CPU OPatches
  • Oracle Virtual Directory (OVD) OPatch
  • Oracle HTTP Server (OHS) OPatch
  • Fusion Middleware (FMW) OPatches
    • FMW.ADF
    • FMW.EM
  • ODBC OPatch
  • Oracle Hyperion Shared Services OPatch
  • Oracle Hyperion Infrastructure OPatch
  1. To Rollback the update:
    1. On Windows: Launch Windows PowerShell from the Start menu as an Administrator and run the following script from the directory where you extracted the ZIP file. For example, navigate to 11.2.22.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.22.0-Update-Linux folder and run the following script:
      ./RollbackUpdate.sh <MIDDLEWARE_HOME>
  2. Optional: Install Microsoft VC++ 2010.
    1. Restart your machine.
    2. Redeploy all the web applications. Under Hyperion Financial Management (HFM), ensure that you check the Configure Application Server option.

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

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 2024
    Patch  33678607     : applied on Sun Feb 20 23:36:01 PST 2024
    Patch  33093748     : applied on Sun Feb 20 23:35:18 PST 2024
    Patch  32720458     : applied on Sun Feb 20 23:34:51 PST 2024
  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 2024
    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 2024
    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 2024
    Unique Patch ID:  24325771
    Patch description:  "One-off"
    Patch  32720458     : applied on Tue Apr 12 18:58:19 EDT 2024
    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 2024
    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 2024
    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-10 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.

Optional: Applying Individual OPatches

Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.22 product Opatches together, using the ApplyUpdate script. See Applying Release 11.2.22 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.22.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=37869158 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=37869158
    • FCM=37867339
    • FDMEE=37815482
    • FR=37885900
    • HFM=37722377
    • HP=37912256
    • HPCM=37872768
    • HSS=37834307
    • Infra=37834325
    • InfraCommon=37452775
    • TAXPROV=37883702
    • Workspace=37882466
    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:

      Note:

      The following script must only be run with Administrator privileges.
      ApplyUpdate.ps1 <MIDDLEWARE_HOME>
    • On Linux:
      ApplyUpdate.sh <MIDDLEWARE_HOME>

    Note:

    For additional information, refer to your individual OPatch Readme Guide.

OPatch Dependencies and Details

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

Table 1-11 OPatch Details

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

Oracle Hyperion Financial Close Management (FCM)

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

37867339 NA NA
Oracle Hyperion Financial Management (HFM) 37722377 ADF 37836334
WebLogic 37851508
Oracle Hyperion Financial Reporting (FR) 37885900 NA NA
Oracle Hyperion Planning (HP) 37912256 NA NA
Oracle Hyperion Profitability and Cost Management (HPCM) 37872768 NA NA
Oracle Hyperion Shared Services (HSS) 37834307 Oracle Hyperion Infrastructure (Infra) 37834325
Oracle Hyperion Infrastructure (Infra) 37834325 Oracle Hyperion Shared Services (HSS) 37834307
Oracle Hyperion Infrastructure (Infra) Commons 37452775 NA NA
Oracle Hyperion Tax Provision (TAXPROV) 37883702 NA NA
Oracle Hyperion Enterprise Performance Management Workspace (Workspace) 37882466 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.22 resolves the following defects:

Table 1-12 Defects Fixed in 11.2.22

Defect Number Description
Oracle Hyperion Financial Management
37151402 Journal extract POV filter value is not working as expected.
38012371 HFM 11.2.21 insights module throws error"ADF_FACES-60096:SERVER EXCEPTION DURING PPR, #2".
37442079 Unable to rename account member with more than 40 characters.
36775893 SmartView error EPMHFM-69542: EACH DIMENSION MUST BE USED ONLY ONCE.
36542290 HFM 11.2.15 writing data extract POV details to HYS9FINANCIALMANAGEMENTJAVASERVER-SYSOUT.LOG, making file size grow quickly.
38068912 Financial Management Native Script Engine to replace Microsoft VB Script.
38062169 HFM 11.2.21 System loads hanging when updates performed on two different applications at the same time.
37570438 Rendering issue with Financial Reporting. Report not displayed correctly.
36980342 Missing POV Details in HFM Task Audit Description.
Oracle Hyperion FDMEE
36192488 Scheduled LCM Export fails with
EPMFDM-140087:INTERNAL ERROR ENCOUNTERED.
37608931 FDMEE does not honor HFM preferred cluster settings.
37936313 Refresh member is exteremely slow and inconsistent base on user initiating the job.
Oracle Hyperion Financial Reporting
37871303 Static folder security permissions do not work from a batch scheduler batch.
37821279 Stored Cross-Site Scripting vulnerability with book components.
Oracle Hyperion Planning
37704263 Cube refresh command line utility does not output log statements to console window after applying Planning 11.2.20.0.000.
34811762, 36785731. Accessibility issues with Planning data form.
37148918 Business rule listing page may throw an error when changing plan type drop down.
34621813 Business rule execution may fail with an error when member name starting with number is passed for run time prompt.
37864213 Enhance the handling of leading or trailing spaces in Planning application and system properties and their values for better usability.
Oracle Hyperion Shared Services
37755510 In Japanese language, Close button is not displayed in the artifact list screen.
Oracle Hyperion Workspace
34867421 Mail subscription is not working while deleting files and folders.

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

Known Issues

Release 11.2.22 includes the following known issues.

Table 1-13 Known Issues in 11.2.22

Defect Number Description
Oracle Essbase
37850493

Unable to Launch EAS Web Console with JDK 8 Build 451, without JAVAFX.

Workaround: See Doc ID 3082972.1.

Oracle Hyperion Financial Management
24824013 HFM Application Snapshots Fail Unless HFM'S MS SQL User is a Member of SYSADMIN.
Oracle Hyperion Financial Reporting
NA
  • Prepositions used in search strings are not working. For example, when you search:
    • "StockAgeing_analysis by BS", if you remove "by" it works.
    • "PL by entities", search string "PL entities" works fine
  • When using the search feature, ensure the search text field on Workspace's top right side has the intended search string, or if using Advanced Search this top right search field is empty; otherwise, it will append the previous search text and the new search text.
Oracle Hyperion Profitability and Cost Management
36888486

By default, Profitability and Cost Management supports up to 15 Management Ledger applications. This limit is in place because Management Ledger applications use a dimension cache to accelerate UI interactions and improve the performance of batch jobs. During the startup of the Profitability service, the cache for all existing Management Ledger applications is loaded. The limit prevents out-of-memory errors during service startup, and long service startup times. Starting in Release 11.2.19, the applications limit is controlled by a user-configurable governor which allows you to increase this limit, provided the server is configured with sufficient memory. Contact Oracle Support if you need access to this governor.

35889576

When you install Profitability and Cost Management on Linux using a language other than English, only that language will be functional for end users in the UI, even after you select a different language in the browser settings.

When you install on Linux using English, all supported languages will be available for end users, by changing the language in the browser settings. This problem is not known to affect Windows installations.

36487973

Upgrading to Essbase 21C may result in a considerable increase in calculation run times for some Management Ledger applications. In this case, the Execution Statistics System Report will show a significant increase in the calculation scripts generation time for one or more rules.

Workaround: See Generation of CALC script duration has increased after ugrading to Essbase 21C topic under Chapter 7 - Essbase 21C of the Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.

36198484

For clustered environments where there are more than one managed Profitability instance, e.g. Profitability0 and Profitability1, there is an installation preference that must be set in order to fully enable the communication between the clustered nodes. Execute the following SQL in a tool like Oracle SQL Developer, while logged in as the Profitabilty product schema owner. Be sure to commit the change, and then restart the Profitability service.

INSERT INTO HPM_INSTALLATION_PREFERENCE
   (ID,NAME,VALUE,HPM_INSTALLATION_ID,CREATED_TIMESTAMP,CREATED_USERID,MODIFIED_TIMESTAMP,MODIFIED_USERID,DISPLAY_ORDER)
VALUES (46, 'dimension.cache.cluster.refresh.enabled', 'Y', 1, SYSDATE, 'INIT', SYSDATE, 'INIT', 46);

This will ensure that dimension updates will be visible in both nodes.

If you revert to non-clustered mode, you should delete this row and restart the Profitability service, to disable the dimension cache cluster refresh.

36353159 When a Profitability application template exported from a Windows instance is successfully imported into Linux instance, a rare failure to create the Essbase cube from the InputData content in the template may occur. This rare situation is generally discovered when accessing the missing cube. To resolve the issue, follow these steps:
  1. Use Manage Database > Essbase Deploy to create the calculation cube.
  2. Use Manage Database Data Load to load the text file found within the template's InputData folder.
35659280

Standard Profitability Applications are no longer supported, and will not be accessible in this patch.

If you installed this patch but are still using Standard applications, you should roll back this patch. Your standard applications will become accessible again after rolling back this patch and then reregistering each application. To reregister:

  1. In the Profitability Applications console, select the Standard application that you want to continue using, then select Re-Register from the Actions menu.
  2. In the Workspace Navigator, select Applications and then, click Refresh. You will now see the reregistered application in the Applications > Profitability list.
36124578 Starting with the 11.2.16 release, the REST Sample Client can only be run on the server where Profitability and Cost Management is installed. See the Oracle Hyperion Profitability and Cost Management REST API Developer’s Guide for details.

See Known Issues: 11.2.0 - 11.2.21 for the list of cumulative known issues starting from Release 11.2.0.

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

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 previous releases by using the Cumulative Feature Overview (CFO) 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 CFO tool is available here:https://apexapps.oracle.com/pls/apex/f?p=20620:1:0

Table 1-14 New Features: 11.2.0 - 11.2.21

Release Link to New Features
New Features: 11.2.18 - 11.2.21 11.2.18 | 11.2.19 | 11.2.20 | 11.2.21
New Features: 11.2.13 - 11.2.17 11.2.13 | 11.2.14 | 11.2.15 | 11.2.16 | 11.2.17
New Features: 11.2.8 - 11.2.12 11.2.8 | 11.2.9 | 11.2.10 | 11.2.11 | 11.2.12

Defects Fixed: 11.2.0 - 11.2.21

This section includes the list of cumulative defects fixed starting from Release 11.2.0.

Table 1-15 Defects Fixed: 11.2.0 - 11.2.20

Release Link to Defects Fixed
Defects Fixed: 11.2.21 11.2.21
Defects Fixed: 11.2.16 - 11.2.20 11.2.16 | 11.2.17 | 11.2.18 | 11.2.19 | 11.2.20
Defects Fixed: 11.2.11 - 11.2.15 11.2.11 | 11.2.12 | 11.2.13 | 11.2.14 | 11.2.15
Defects Fixed: 11.2.6 - 11.2.10 11.2.6 | 11.2.7 | 11.2.8 | 11.2.9 | 11.2.10
Defects Fixed: 11.2.0 - 11.2.5 11.2.0 (NA) | 11.2.1 | 11.2.2 | 11.2.3 | 11.2.4 | 11.2.5

Known Issues: 11.2.0 - 11.2.21

This section includes the list of cumulative known issues starting from Release 11.2.0.

Table 1-16 Known Issues: 11.2.0 - 11.2.21

Release Link to Known Issues
Known Issues: 11.2.21 11.2.21
Known Issues: 11.2.16 - 11.2.20 11.2.16 | 11.2.17 | 11.2.18 | 11.2.19 | 11.2.20
Known Issues: 11.2.11 - 11.2.15 11.2.11 | 11.2.12 | 11.2.13 | 11.2.14 | 11.2.15
Known Issues: 11.2.6 - 11.2.10 11.2.6 | 11.2.7 | 11.2.8 | 11.2.9 (NA) | 11.2.10
Known Issues: 11.2.0 through 11.2.5 11.2.0 | 11.2.1 | 11.2.2 | 11.2.3 | 11.2.4 | 11.2.5