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.20 is a cumulative update that includes all updates from Release 11.2.15. This update can be applied on top of Release 11.2.19.

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

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

Release 11.2.20 (Release 11.2, Update 20) includes the following deliverables:

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

Note:

Release 11.2.20 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.20 includes the following new features:

  • Java 8 Update 431.

  • WebLogic Patch Set Update 12.2.1.4.241008.

  • Application Data Framework (ADF) Bundle Patch 12.2.1.4.240905.

  • Oracle HTTP Server (OHS) 19c Bundle Patch 12.2.1.4.240906.

  • There are no Oracle Data Integrator (ODI) Patches in Release 11.2.20.

  • Support for Keyboard Shortcut Keys in Oracle Enterprise Performance Management System Taskflow.

    - For more details, see Oracle Enterprise Performance Management System Accessibility Guide.

  • Support for Special Characters in Service Account Password.

    - For more details, see Preparing User Accounts.

  • WebLogic Administrator Password Change:

    - Fore more details, see Changing WebLogic Administrator Password.

  • The dependency on Microsoft Visual C++ 2010 has been removed.
    • Starting with Release 11.2.17,Oracle Enterprise Performance Management System will no longer install Visual C++ 2010.
    • Oracle Enterprise Performance Management System will function correctly with or without Visual C++ 2010.
    • If Visual C++ 2010 is already installed, it will not be uninstalled automatically.
    • For details on removing Microsoft Visual C++ 2010 from your machine, see Removing Visual C++ 2010.
  • For all the new features in Release 11.2.8 - 11.2.19, see New Features: 11.2.8 - 11.2.19.

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

  1. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). See Optional: Removing Microsoft Visual C++ 2010 for more details.

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

  3. Apply Update to Release 11.2.20: See Applying Release 11.2.20.

  4. Configure Release 11.2.20: See Configuring EPM System After Applying an Update for more details.

Updating from Release 11.2.x

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

  1. Updating from 11.2.8 to 11.2.20:

    1. Apply Update from Release 11.2.8 to Release 11.2.12 or 11.2.13 or 11.2.14: See Applying an Update to EPM System Products.
    2. Install Update to Release 11.2.15: See Installing EPM System Products Using Apply Update.
    3. Apply Update to Release 11.2.20: See Applying Release 11.2.20.

    4. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). See Optional: Removing Microsoft Visual C++ 2010 for more details. .

      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. 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.20: See Configuring EPM System After Applying an Update for more details.

  2. Updating to Release 11.2.20 from Releases prior to 11.2.8

    1. Install Update to Release 11.2.8: See 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: See Applying an Update to EPM System Products.
    3. Install Update to Release 11.2.15: See Installing EPM System Products Using Apply Update.
    4. Apply Update to Release 11.2.20: See Applying Release 11.2.20.

    5. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). See Optional: Removing Microsoft Visual C++ 2010 for more details.

      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. 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.20: See Configuring EPM System After Applying an Update 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.20.

  1. Upgrade from 11.1.2.x to Release 11.2.8: See Upgrading EPM System. in Oracle Enterprise Performance Management System Installation and Configuration Guide for instructions.

  2. Apply Update from Release 11.2.8 to Release 11.2.12 or 11.2.13 or 11.2.14: See Applying an Update to EPM System Products.

  3. Install Update to Release 11.2.15: See Installing EPM System Products Using Apply Update.

  4. Apply Update to Release 11.2.20: See Applying Release 11.2.20.

  5. Optional: Remove Microsoft Visual C++ 2010 (x86 and x64). See Optional: Removing Microsoft Visual C++ 2010 for more details.

    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.20: See Configuring EPM System After Applying an Update for more details.

Applying and Rolling Back Release 11.2.20

Prerequisites

  1. Disable the anti-virus software before you apply Release 11.2.20 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. 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
  3. 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.

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

  5. 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:
    keytool -import -alias alias_name -keystore <path_to_keystore_file> -file <path_to_certificate_file> -storepass keystore_password -trustcacerts
    Once the keystores are imported, restart all the EPM services for the changes to take effect.

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

  6. 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.20

Release 11.2.20 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.20 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.20 (Release 11.2, Update 20), 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.20 (Release 11.2, Update 20):
    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.20.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.20.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.20.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.20.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.20. 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.20

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

Optional: Applying Individual OPatches

Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.20 product Opatches together, using the ApplyUpdate script. See Applying Release 11.2.20 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.20.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=37210779 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=37210779
    • FCM=37213724
    • FDMEE=37203330
    • FR=37218664
    • HFM=36942612
    • HP=37216408
    • HPCM=37209252
    • HSS=37184034
    • Infra=37184042
    • InfraCommon=36924339
    • TAXPROV=37255142
    • Workspace=37204762
    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-2 OPatch Details

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

Oracle Hyperion Financial Close Management (FCM)

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

37213724 NA NA
Oracle Hyperion Financial Management (HFM) 36942612 ADF 37028738
WebLogic 37150572
Oracle Hyperion Financial Reporting (FR) 37218664 NA NA
Oracle Hyperion Planning (HP) 37216408 NA NA
Oracle Hyperion Profitability and Cost Management (HPCM) 37209252 NA NA
Oracle Hyperion Shared Services (HSS) 37184034 Oracle Hyperion Infrastructure (Infra) 37184042
Oracle Hyperion Infrastructure (Infra) 37184042 Oracle Hyperion Shared Services (HSS) 37184034
Oracle Hyperion Infrastructure (Infra) Commons 36924339 NA NA
Oracle Hyperion Tax Provision (TAXPROV) 37255142 NA NA
Oracle Hyperion Enterprise Performance Management Workspace (Workspace) 37204762 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.20 resolves the following defects:

Table 1-3 Defects Fixed in 11.2.20

Defect Number Description
Oracle Hyperion Calculation Manager
37280507 Oracle Hyperion Calculation Manager rules with Java not working after upgrade.
Oracle Hyperion Essbase
36580465 In an SSO (Single Sign-On) environment, EPM 11.2.x with Essbase 21c requires two logins when configuring Smart View with shared connections.
Oracle Hyperion Financial Close Management
36916254 Size add attributes dialog to fit longer attribute names
Oracle Hyperion Financial Management
36947051 User able to save grid with access level of Read Only.
37013175 IC matching reports when opening default with checkboxes ticked.
36119624 User with Non Admin rights was able to load data to a published period in HFM.
36971073 Missing location path when automating the journal report extract using Task Flow.
36557214 HFM 11.2.14 Open Transaction always involving "XFM_PARAMETERS" in SQL DB.
Oracle Hyperion Financial Reporting
36999939 The tool, UTILITY.bat, does not export the hrinstanalfolder and its subcontents.
37263560 Upgrade to Oracle Outside In 8.5.7 to upgrade Microsoft Visual C++ Redistributable 2013 dependency to 2019.
Oracle Hyperion Planning
37280459 If few dimensions are hidden in Planning data form, right click action menus may not work.
37023685 If a business rule is attached to Planning data form with hide prompt option selected, the run time prompt may still be displayed when submitting data form from SmartView.
37022630 Sorting the list of forms based on user access may not work.
36740785 Incorrect HTML headings defined for headers in Planning left accordion UI.
36202411 In certain cases, Planning cube refresh command line utility may fail with connection error.
34868205 In accessibility mode, labels in Planning data form are not announced for read-only cells.
34758330 Row or column headers may not be displayed in Planning data form when suppression options are enabled.
34736817 If the Planning security export file has non-English characters in member names or user names, Planning import security command line utility may not import such records.
33250639 SortMember command line utility does not work.
33179515 Planning data form may not display any rows if it has only one hidden column.
37269363 Improve the logging capability of calculation manager command line launch utility.
37156851 Need an ability to disable data cell description in Planning data form.

Note:

Administrators need to define the below Planning Application Property by navigating to Administration->Application->Properties->Application Properties in Planning web and set the value to "true".
DISABLE_DATA_CELL_DESCRIPTION
37156504 Enhance the page drop down in Planning data form to automatically wrap the member name.
Oracle Hyperion Workspace
37080227 Pdf files are not opening in Firefox
34676549 Permissions dialog control objects missing accessibility labels

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

Known Issues

Release 11.2.20 includes the following known issues.

Table 1-4 Known Issues in 11.2.20

Defect Number Description
Oracle Hyperion Essbase
37361941 In a non-SSO (Single Sign-On) environment, EPM 11.2.x with Essbase 21c requires two logins when configuring Smart View with shared connections.
Oracle Hyperion Financial Management
NA

Note:

Using Unicode UTF-8 for worldwide language support is not recommended for Oracle Hyperion Financial Management.
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.19 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).

New Features: 11.2.8 - 11.2.19

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

Release 11.2.19 New Features

Release 11.2.18 New Features

Release 11.2.17 New Features

Release 11.2.16 New Features

Release 11.2.15 New Features

Release 11.2.14 New Features

Release 11.2.13 New Features

Release 11.2.12 New Features

Release 11.2.11 New Features

Release 11.2.10 New Features

Release 11.2.9 New Features

Release 11.2.8 New Features

Defects Fixed: 11.2.0 - 11.2.19

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

Known Issues: 11.2.0 - 11.2.19

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