Table of Contents:
This document includes important, late-breaking information about this release of Oracle Hyperion Financial Management. Review this Readme thoroughly before installing Oracle Enterprise Performance Management System.
See the Oracle Hyperion Financial Management New Features. For new features relating to installation, architecture, and deployment changes in this release, see “New Features in this Release” in the Oracle Enterprise Performance Management System Readme.
If you are applying the maintenance release from Release 22.214.171.124, 126.96.36.199, 188.8.131.52, or 184.108.40.206, use the Cumulative Feature Overview tool to review the list of new features added between those releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here:
Late-breaking information about the installation of EPM System products is provided in the Oracle Enterprise Performance Management System Installation and Configuration Readme. Review this information thoroughly before installing EPM System products.
Oracle Smart View for Office is no longer installed with the EPM System installer. To download and install the latest release of Smart View, go to http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html.
If you use Oracle Database Client 10.2.x or 11.1.x for Financial Management, you must set the StmtCacheSize registry setting for Oracle OLE DB to 10 on all Financial Management application servers and Web servers. This is due to a memory issue in Oracle Provider for OLE DB. The registry setting path is: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb. Note that the 11.2.x Oracle Database Client should not be changed.
To resolve the high memory usage, enable Statement Caching. The configured value must not be zero. The recommended value is between and 1 and 10.
Edit the registry value: Hkey_Local_Machine\Software\Oracle\Key_Homename\Oledb Value Name: StmtCacheSize Value (decimal):1, where Key_Homename refers to the appropriate Oracle Home.
Stop and restart the Financial Management application processes.
In addition, if you are using System 11 on a 64-bit operating system with a 10g database, the Oracle OLE provider on all Financial Management servers must be at least 10.2.0.4.21+.
If you are using 32-bit with 10g, the Oracle OLE provider version MUST be at or greater than the database server version. If you are running 32-bit or 64-bit and using 220.127.116.11 or 18.104.22.168 OLE Provider, you must upgrade to Oracle Database Client 22.214.171.124.33+.
Information about system requirements and supported platforms for EPM System products is available in spreadsheet format in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on Oracle Technology Network (OTN):
Note that Financial Management Linux is only supported on Exalytics.
The 32-bit platform and Win32 client is no longer supported by Financial Management.For details, see the Oracle Enterprise Performance Management System Certification Matrix.
Information about supported languages for EPM System products is available in spreadsheet format on the Translation Support tab in the Oracle Enterprise Performance Management System Certification Matrix. This matrix is posted on the Oracle Fusion Middleware Supported System Configurations page on OTN:
This section includes defects fixed in Release 126.96.36.199.000. To review the list of defects fixed between earlier releases, use the Defects Fixed Finder. 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 fixed-defect descriptions with their associated platforms and patch numbers. This tool is available here:
19227372 - When you use filters on Intercompany Transactions, a blank screen is displayed.
19001029 - The Metadata Load audit file contains sections for dimensions that are not loaded in Merge mode.
17300952 - Data form navigation in Release 188.8.131.52 is slow.
17236532 - The Extract Data to Database feature does not work correctly when run from a task flow.
17061383 - When you create an Intercompany report, under Report Options, only 25 security classes are displayed.
17051548 - Running a consolidation and ownership data clearing process in parallel for two different scenarios causes issues.
17031545 - When you load data grid files that you previously extracted, the grids do not display correctly.
17018578 - In Intercompany Matching reports, the override option does not correctly override the POV.
16940396 - An issue exists with the Force Calculate Contribution option when the security is on a parent member.
16940299 - After upgrading, some data grids do not open.
16841386 - After you run multiple Extract Data to Databases, the Running Task logs do not display correctly.
16816412 - After running a consolidation, an error displays: Unknown Error in the HSVDSDATACUBES2 object.
16687835 - A non-administrative user cannot view a journal in a journal report without other security rights.
16230425 - In Smart View, two-way SSL should be supported by the HFM provider.
16211558 - The GetMembersThatHaveDataExtDim API function does not return expected values.
The following are the noteworthy known issues of this release.
If you do not properly shut down Financial Management, temporary files may remain upon reboot. To ensure optimal performance, delete all *.db.* filenames from the Server Working Folder before launching Financial Management.
If you do not allow enough space in the initial creation of the relational database tables, you can create applications, but not open or delete them. To create database tables, refer to your database guide.
To run Calculation logic on the Value dimension Adjustment members, you must enable the AllowAdjs entity attribute. Otherwise, the entity may not change to an OK status.
19887986 - If all the modules are disabled in the module configuration, you will not be able to re-enable them using a module configuration load. Use the Module Configuration screen to enable them.
19481332 - When you attempt to enable Admin Mode during a data load, the data load process stops and returns an error message.
19430958 - If you load a Module configuration file with an incorrect file name, the load process stops and the application does not open.
20006746 - In data forms, the Value dimension member does not display correctly in Cell Information.
19904290 - If you use Internet Explorer 11, and data is already present in a cell, clicking on the cell to edit it will display a small x on the right. This is the expected behavior in IE11.
The following features and utilities are deprecated in Financial Management 184.108.40.206:
HFM Windows and Object SDK
Copy Application utility
Index Update utility
Audit Extract utility
HFM ErrorLog Viewer utility
19323855 - For Oracle databases, ignore the Test Connection button, as it results in an error. You must create an entry in the tnsnames.ora file. Enter the TNS identifier in the Host field. The typical location for TNSNames.ora is under the EOI/../config/dbclient/ directory. If an Oracle database is being used, then a tnsnames.ora file is already created by config tool, and can be edited. If an Oracle database is not used for the main HFM server, you must select a location and set the TNS_ADMIN environment variable to point to the directory in which it exists.
19150085, 19150074 - When you extract data, if you select multiple accounts, the data extract format is incorrect.
Oracle Hyperion Financial Data Quality Management, Enterprise Edition and source ERPs support special characters in member labels, such as "-" and "/". Financial Management does not support these characters for member labels.
Exchange rates are not interfaced directly into Financial Management, and users must manually select them from the AIF_HS_EXCHANGE_RATES table and manually insert them into Financial Management.
19652441 - In Process Intercompany Transactions, the filter does not apply the row filter for some actions, such as UnMatch and Manual Match.
In Organization by Period applications, if you select inactive child-parent combinations, an "invalid parent or child/parent combination" or "invalid entity" error message is displayed.
20024090 - In Oracle Hyperion Enterprise Performance Management System Lifecycle Management, the data export may not successfully complete, and result in an error message that there are pending tasks.
20321669 - Financial Management requires UTF-8 encoding on Linux. The LANG environment variable must be set to UTF-8 encoding, for example: en_US.UTF-8, zh_CN.UTF-8.
20197888 - While extracting Intercompany transactions on Linux, the dates are extracted in dd/mm/yy format.
20160951 - The e-mail alert and drill through transactions are not available from the generated Intercompany reports on Linux.
17572583 - When you load data, the Replace option does not work correctly when you load phased submission data.
19932334 - If Manage Ownership screen is set as the default screen and a user has only Consolidate and Manage Ownership roles with security access rights set to ALL, they may receive errors while working with the Manage Ownership screen. Provision the user for the Review Supervisor role to avoid errors.
The following database settings are recommended when using Oracle databases with Financial Management:
OPEN_CURSORS=5000 - needed to allow for larger transactions (as well as ODBC support)
PROCESSES= (whatever is needed to support the expected number of applications and application servers), based on numbers derived from the Installation guide section titled "Database Connection Pooling".
To improve performance in Oracle, the DBA should run statistics on the ICTTransactions table. There are a variety of utilities and commands available to perform this task. Following is a sample of one of the commands that you can use: ANALYZE TABLE APPNAME_ICT_TRANSACTIONS COMPUTE STATISTICS.
Oracle 11.1.2.x databases use a Deferred_Segment_Creation feature that is enabled by default in all installations. A table is created only after a row of data is inserted. If you use the Export (EXP) utility to back up your database, any table that does not contain rows will not exist in the report (for example, metadata DESC tables) and Financial Management may not start against a restored database due to the tables being missing.
You can disable this feature by logging in to your instance using SYSTEM or SYS and change the setting to force tables to be created automatically. Issue the command:
Alter system set deferred_segment_creation=false;
Any table created after issuing this statement will be created automatically. If you already have an instance with empty tables and want to export the application, you can alter each table individually to force creation and allow the table to be used by the EXP (export) command. Issue the following command for each empty table:
Alter table <table_name> allocate extent;
The Oracle Data Integrator knowledge module (KM) is unavailable for Oracle Hyperion Financial Management in EPM System Release 220.127.116.11 and Oracle Data Integrator Release 12c. Customers are encouraged to use the native features in Financial Management or FDMEE, or to create custom solutions using Oracle Data Integrator, but without the Financial Management knowledge module.
Find the latest EPM 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 EPM tab, and then click the Enterprise Performance Management link.
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). Or you can visit the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html). There, you’ll find links to My Oracle Support, EPM Supported Platform Matrices, and more.
Some tables and text may display incorrectly in online help when using Internet Explorer 9.
Send feedback on product documentation to the following email address:
Follow EPM Information Development on these social media sites:
Twitter - https://twitter.com/HyperionEPMInfo
Our goal is to make Oracle products, services, and supporting documentation accessible to the disabled community. EPM System products support accessibility features, which are described in the product's Accessibility Guide. Find the most up-to-date version of this guide in the Oracle Enterprise Performance Management System Documentation Library on the Oracle Technology Network (http://www.oracle.com/technology/documentation/epm.html).
In addition, this Readme file is accessible in HTML format.