- Need Help? Talk to an Expert 888-664-4794
09 Nov
Oracle On-Premises EPM Patch Version - 11.2.27.0
Whether you are new to Oracle Hyperion EPM or an experienced administrator, this blog will provide valuable insights to help you keep your system running smoothly and securely. Staying up to date with the latest patches is crucial for maintaining the security, performance, and functionality of your Oracle On-Premises EPM environment. In this post, we will explore the latest updates to Oracle On-Premises EPM version 11.2.27 and the defects that have been fixed.
Release 11.2.27.0 includes the following new features
| Component | Version |
| Java | Java 8 Update 503 |
| Essbase | 21.8.3 |
| WebLogic | Patch Set Update 12.2.1.4.260703 |
| Application Development Framework (ADF) | Bundle Patch 12.2.1.4.260622 |
Patch Update To enhance EPM application accessibility in alignment with the latest Oracle Accessibility Guidelines (OAG). The ADF patch 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.260624 Database Release Update 19.30.0.0.0 For FMW Database Client. |
| Oracle Data Integrator (ODI) | No patches in this release |
| Features | Descriptions |
|---|---|
| Microsoft Active Directory |
Microsoft Active Directory 2025 is now supported |
| Financial Management Features |
Add Submitted by and Submitted On to Journal Reports Enhance Journal Reports to make Submitted By and Submitted On available as selectable report columns. For each journal, the report must display the user who performed the most recent Submit action and the corresponding submission timestamps. These fields must be independent of the existing Approved By/Approved Time and Posted By/Posted Time fields, since submission, approval, and posting can be performed by different users under segregation-of-duties controls Include Journal Label in the Description Column of Data Audit Enhance Data Audit to display the journal label in the Description column for each journal-related audit entry. When a journal is processed, the Description column displays the business-entered journal label, enabling auditors, Console users, and control teams to quickly identify, filter, and select journal vouchers for review without opening the underlying journal. |
Financial Management Schema Upgrade
This release introduces schema changes for the above new features. To run the existing application successfully, you need to run the schema upgrade tool from the configuration on any one Financial Management server only.
When you import any application from older version after the first time running the schema upgrade. You need to run schema upgrade for the newly imported application only.
To upgrade one application, the schema upgrade must be run from a command prompt:
- Windows:
- Open a command prompt in
%EPM_ORACLE_HOME%\products\FinancialManagement\Server - Execute the appropriate command below for the database type:
- SQL Server:
ofmssu -dbname=<dbname> -dbtype=MS_SQL_SERVER -dbuser=<dbuser> -dbpassword=<dbpassword> -dbserver=<dbserver> -dbport=<dbport> -eoi=<EPM Oracle Instance folder> -applist=<appname>
- Oracle:
ofmssu -dbname=<sn or sid> -dbtype=ORACLE -dbuser=<dbschema> -dbpassword=<dbpassword> -dbserver=<dbserver> -dbport=<dbport> -eoi=<EPM Oracle Instance folder> -applist=<appname>
- Linux:
- Open a terminal in
$EPM_ORACLE_HOME/products/FinancialManagement/Server - Execute the appropriate command below for the database type:
- SQL Server:
./ofmssu -dbname=<dbname> -dbtype=MS_SQL_SERVER -dbuser=<dbuser> -dbpassword=<dbpassword> -dbserver=<dbserver> -dbport=<dbport> -eoi=<EPM Oracle Instance folder> -applist=<appname>
- Oracle:
./ofmssu -dbname=<sn or sid> -dbtype=ORACLE -dbuser=<dbschema> -dbpassword=<dbpassword> -dbserver=<dbserver> -dbport=<dbport> -eoi=<EPM Oracle Instance folder> -applist=<appname>
DEFECTS FIXED IN VERSION 11.2.27.0
| Oracle Hyperion Financial Management | |
| 36765310 | You can search for and select entities reliably in Financial Management web forms, including entities near the end of large member lists. |
| 38140016 | Applications created through import can now be opened successfully in Financial Management. |
| 38442944 | Financial Management improves memory handling when retrieving member properties through the MetadataOM API, supporting more stable processing for workloads that use this API. |
| 38560711 | Financial Management improves journal creation when currency validation is encountered, reducing interruptions caused by an invalid-currency message. |
| 39275337 | Financial Management Tax improves Calculate and Consolidate processing after an upgrade to 11.2.24. |
| 39465933 | Financial Management improves Lifecycle Management artifact processing when the current service is temporarily unavailable. |
| 39575793 | Financial Management improves application stability during consolidation processing in 11.2.23. |
| 39581983 | The Native Script Engine now provides versioning information for use in scripts and related automation. |
| 39583447 | Financial Management improves stability for applications that could previously stop unexpectedly during consolidation. |
| 39704688 | The MetadataOM “GetMemberPropertiesUsingMembers“ API preserves parent-member information in Financial Management 11.2.21 and later releases. |
| 39717003 | Financial Management improves Native Script Engine processing so that consolidation does not abort unexpectedly. |
| 39725922 | Custom Documents now honor the configured security class in Financial Management. |
| 39767954 | Financial Management improves consolidation processing after an application is switched to the BSL application type. |
| 39768497 | Financial Management improves member-list file processing after an application is switched to the BSL application type. |
| 39858686 | You can assign Access Control in Financial Management 11.2.26 when external SSL offloading is configured. |
| Oracle Hyperion Profitability and Cost Management | |
| 39954435 | Calculation Enhancement: The custom calculation rule formula has been enhanced to support the NONEMPTYTUPLE directive, which you can use to avoid calculating empty result sets. This can lead to a significant performance increase for rules that operate on sparse data. For more information, see the Skipping Empty Tuples to Optimize Custom Calculations section. |
| 39854964 | Allocation rules now apply parent-member filters to all corresponding |
| Oracle Hyperion Planning | |
| 39508750 | When metadata or data load using Outline Load utility with relational database as source is executed, the number of records processed statistics may be displayed incorrectly. |
| Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE) | |
| 38797590 | Oracle E-Business Suite (EBS) source-system initialization now completes correctly in Data Management instead of submitting a job that hangs without creating the expected ODI process. |
| Oracle Hyperion Financial Close Management | |
| 39672439 | Activity-summary email links now open Close Manager correctly instead of displaying a blank page and causing navigation errors until the session is reopened. |
| Oracle Hyperion Financial Reporting | |
| 39804864 | Financial Reporting books now continue to work after an issue is fixed where a data source heading value is de-serialized as a number. |
| Oracle Hyperion Enterprise Performance Management Workspace | |
| 36606419 | 508: Open document popup dialog options expanded state incorrectly read by jaws. |
| 39638054 | Manage favorites menu item disabled when no favorites exist. |
Important Announcements
– Beginning with the EPM 11.2.27 Release, SSO Backward Compatibility is no longer supported.
– FDMEE Redeployment is Required After Upgrading to Release 11.2.26 or Later
Essbase Administration Services Lite (EAS Lite) is deprecated as of Essbase 21c and will not be available in Essbase 26.x or later releases. All administrative functionality is now provided through the Essbase Web Platform UI.For more information, see the latest Statement of Direction for Essbase Administration Services Lite (Doc ID 2501038.1)
Please view the official 11.2.27.0 readme here for more details about the important information above: Oracle Enterprise Performance Management System Readme
Reminder: Oracle Hyperion EPM Version Update Schedule
Just a quick reminder for all our Oracle Hyperion EPM users: Version updates for on-prem installations are typically released in the last week of January, April, July, and October. Be sure to check back with us for the latest version updates as soon as Oracle rolls out their new releases. We’ll keep you informed with all the details you need to stay up-to-date and make the most out of your EPM system.
Stay tuned for our future blog post on EPM 11.2.28.0, which will be tentatively released January 2027!
For the latest Hyperion Certification Matrix click here: https://www.oracle.com/a/tech/docs/epm-11-2-x-cert-matrix.xlsx
