Table of Contents:
This document includes important, late-breaking information about this release of Oracle Hyperion Financial Data Quality Management Enterprise Edition. Review this Readme thoroughly before installing FDMEE.
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.
Documentation files for Release 22.214.171.124 are now available in two mobile formats: MOBI files, available previously, and EPUB files. EPUB documentation files are supported on all Apple Mobile devices (iPad, iPhone, and iPod Touch). EPUB files are supported on many mobile devices; however, they are certified only on Apple Mobile devices. Additional devices will be certified over time.
If you are coming from Release 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:
In Release 220.127.116.11, FDMEE is offered as the full-featured successor to Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications (ERP Integrator) and Oracle Hyperion Financial Data Quality Management (FDM). FDMEE represents the integration of both products. It captures key functionality from Oracle Hyperion Financial Data Quality Management, and preserves the ERP Integrator framework that enables users to load metadata and data, and to drill-through and write-back.
Key benefits for legacy FDM users:
Improved User Experience—Integrated into the Oracle Enterprise Performance Management System. The FDMEE user interface is consistent with the Oracle Hyperion Planning and Oracle Hyperion Financial Management user interfaces.
Improved user interface and data load performance
Oracle Hyperion Shared Services integration—All native Shared Services features are supported (for example, user groups).
Support for multiple browsers—Internet Explorer and Firefox
Support for Oracle Hyperion Enterprise Performance Management System Lifecycle Management—Consistent Lifecycle Management support like other EPM System products.
Support for multiple platforms as defined in the support matrix. If integrating with Financial Management, only the Windows operating system is supported.
Consistent Scaling and Load Balancing—All scale out configuration and load balancing steps are consistent with other EPM System products.
Key feature enhancements for legacy ERP Integrator users:
Improved User Experience—Easy to navigate Oracle Hyperion Enterprise Performance Management Workspace tabs that enables users to switch between Workflow and Setup functions.
Supports FDM Workflow processes:
Import source data
Validate source data against mapping tables
Validate target system data
Review and validate internal financial control
Support for FDM Logic Accounts—Logic accounts are dynamically generated accounts that are used to calculate supplemental values that are not provided in source files.
Support for FDM Check Rules—Create Check rules to enforce data integrity.
Reporting Functionality—FDMEE provides prebuilt reporting tools that capture business critical operations and revenue generating activities within your organization. The new report functionality is implemented using Oracle Business Intelligence Publisher. Key features include:
User-defined report query definitions
Based on RTF templates for easy customization
Output formats include: PDF, Microsoft Word, Microsoft Excel, and HTML.
Existing FDM reports can be migrated to FDMEE.
Scheduling—The new Scheduler enables you to run batches on specific days, times or fixed intervals.
File Based Data Load—Requirement to regenerate ODI scenario eliminated for file based data loads.
Support for Signage in Data Rule—When extracting data from Oracle E-Business Suite/Fusion/Peoplesoft, users can now select the signage for the amount. Three new signage options are available in the data rule section:
Absolute—Naturally negative accounts are reversed from source; naturally positive accounts remain the same as source.
Same as source—No change in signage from source
Reverse from source—Signage is reversed from source.
Data Load Mapping—Enhancements include:
All mapping types from Oracle Hyperion Financial Data Quality Management are now supported in FDMEE.
New “In” type that enables you to map a list of nonsequential source accounts to one target account.
Exporting and importing of mapping rules are now supported.
Mapping rules can now be associated with data load rules.
The data load rules displayed are now based on the Point of View (POV) category.
Data load rules can be scheduled.
Financial Management Adapter Parity—Key support is available for:
Line item detail
Enhanced process logging and error handling
Batch Processing—Support added for all rules types added.
Enhanced System and Security options
Provides eight additional intermediate roles (2-9) that allows an administrator to define access to specific features in FDMEE.
In this release, FDMEE supports a SAP BW (Business Warehouse) data load.
Key features include:
Certified on SAP BW release 7.0
Data extraction is available from any SAP BW Infocube:
User provides cube and package name.
Single button click to import details into FDMEE.
Auto-generates ODI details required for integration.
In this release, when you install and configure FDMEE, Oracle Data Integrator is automatically installed and configured for you. The database for Oracle Data Integrator is in the same database as FDMEE and the Oracle Data Integrator agent deployed to the FDMEE Managed Server.
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.
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):
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:
You can upgrade to EPM System Release 18.104.22.168 from the following releases:
Note: For upgrading instructions, see the Oracle Enterprise Performance Management System Installation and Configuration Guide, “Upgrading EPM System Products.”
Table 1. Supported Paths to this Release
|Upgrade Path From Release ...||To Release 22.214.171.124|
Apply the maintenance release to Release 126.96.36.199.
For Oracle Hyperion Financial Close Management, applying the maintenance release is supported only from Release 188.8.131.52 and 184.108.40.206.
Upgrade to Release 220.127.116.11.
|Release 18.104.22.168.x to 22.214.171.124.x|
Apply the maintenance release to Release 126.96.36.199 and then upgrade to Release 188.8.131.52.
An environment that includes multiple releases, which can include an environment with one instance of Shared Services or an environment with two instances of Oracle Hyperion Shared Services
See "Upgrading from an Environment with Multiple Releases" in the "Upgrading EPM System Products" chapter in the Oracle Enterprise Performance Management System Installation and Configuration Guide.
Note: If you are starting from an earlier release, Oracle recommends that you upgrade to the highest level release that directly supports upgrade from your starting release.
This section includes defects fixed in Release 184.108.40.206.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:
14812909 -- Orphans are imported into EPMA when the ignore option is selected in metadata rules.
14768204 -- Budgets can only be selected against the base language.
14738283 -- When loading data, missing CCIDs occur between an E-Business Suite data source and ERPI.
14695975 -- Unable to run data rule when using the SID (security identifier).
14646037 -- Correlate initialization of source systems to the ODI scenario.
14607083 -- Unable to validate source values in explicit mappings when concatenating two segments in the import format.
14462917 -- System Settings page becomes blank when saving it with single quote (') in the Application Root directory/File Archive directory.
14269722 -- When registering a target application, custom dimensions are set in the wrong order.
14257269 -- The metadata rule for Financial Management fails when a prefix or suffix is not defined.
14247266 -- Some multidimensional maps are not imported correctly.
14247087 -- PROCESS_ID is not ordered in the RAC environment.
14232523 -- Metadata attribute settings are not functioning correctly.
14226555 -- Add “Delete All” button to the Data Load Rule screen to delete data loaded by the rule.
14053934 -- The message: [DRILLDOWNAMIMPL] SCENARIO MISSING is shown on the SYSOUT log.
13776769 -- Drill-down to PeopleSoft fails for an account with no activity in any period.
13587906 -- The default language is always set to American English for the Account Reconciliation Manager.
13438487 -- UNICODE VARCHAR is always used when loading tables in SQL server.
13032082 -- Exporting member mappings fails when using a non-English language.
The following are the noteworthy known issues of this release:
16602782 -- Imported multi-dimension data load mappings are not working in the SQL server environment.
Workaround: Run the following SQL in the FDMEE database to fix the imported maps:
UPDATE TDATAMAP SET WHERECLAUSETYPE = NULL WHERE TDATAMAPTYPE = 'MULTIDIM' AND WHERECLAUSETYPE = ''
16584509 -- In Lifecycle Management, a non-ASCII application name appears as garbled.
16580178 -- An error occurs when running a budget check for an entity that is assigned to multiple budget revisions.
16571720 -- Metadata load does not perform the auto cube refresh for Planning.
Workaround: After loading data to Planning, run the “Refresh Database” feature from the Planning application.
16561574 -- The Export feature fails in the Data Load Workbench when no files are specified in the data rule.
Workaround: Include a valid file name in the data load rule.
16543063 -- The Data Load Rule screen lists all Budget Revisions irrespective of the decision package.
Workaround: none. Carefully select the required budget revision because they are not filtered by the selected decision package.
16524431 -- Specific schema entry for SQL Server defaults to “DBO.”
Workaround: Log in to ODI Studio and connect to the FDMEE database. Navigate to the Account Reconciliation Manager server and FDMEE server topology under Microsoft SQL Server, and then change the schema from “dbo” to epm. Rerun the data load. No restart is needed.
16506321 -- Data is exported to Financial Management files when the user adds lookup dimension for the Financial Management target application.
Workaround: Remove any lookup dimensions from the import format.
16457209 -- Unable to connect to the ODI Agent after running a compact deployment.
Workaround: Add a localhost entry in the host file with the actual IP. For example in Windows, in the c:\windows\system32\drivers\etc\hosts folder, add the 10.111.222.33 localhost.
16456640 -- In Lifecycle Management, artifacts that contain delimited file import formats from Release 220.127.116.11 cannot be exported to FDMEE Release 18.104.22.168.000. This issue will be fixed in a future update.
Workaround: Recreate the import format that specifies delimited file details manually in the target system.
16448061 -- In Release 22.214.171.124.000, write-back load rules from Release 126.96.36.199.000 to Release 188.8.131.52.000 fail.
Workaround: Delete the system generated maps, and redo them as needed. Then rerun the write-back rule.
16447128 -- In Release 184.108.40.206.000, the Lifecycle Management import and export of security settings do not consider the Security by Location feature.
Workaround: Recreate security by location details in the target system.
16388740 -- Fusion source system initialization process fails when a duplicate tree code exists in the source system.
Workaround: Rerun the initialization process a second time.
16371283 -- The Entity dimension does not show on the Metadata screen for a mapping when the type is “Country.”
Workaround: Do not use the dimension class of “country” in Oracle Essbase.
16371129 -- In Release 220.127.116.11.000, the Oracle Hyperion Enterprise Performance Management System Lifecycle Management Import feature fails for source period mappings.
Workaround: Create period mappings in the target system manually.
16324913 -- The Validation tab shows unclear error messages when a Lookup dimension exists.
16267246 -- The Check report is blank when an account dimension is not specified.
Workaround: Include the account dimension in the Check Report.
16263348 -- In Release 18.104.22.168.000 FDMEE runs out of Weblogic data source connections.
Workaround: Manually increase the connection pool size for the data source aif_datasource using the Web Logic Admin Console.
16237177 -- In Release 22.214.171.124.000 parent and entity records are not returned in the Check Entity Group.
16220846 -- Application folders are not created when write permission is not assigned to the “Everyone” user in the FDMEE Application Share folder.
Workaround: Update permissions on the file server to allow creation of folders.
16165610 -- Unmapped currency results in load failure, and no user message is shown.
Workaround: When a data load failure occurs, confirm that the currency is mapped properly.
16027311 -- Notification messages are gabled in the HTML report generated using the Log Analysis Utility.
Workaround: Access messages in English.
15954013 -- Metadata loads to Classic Hyperion Financial Management shut down the FDMEE service.
Workaround: Use the ODI Standalone Agent instead of the J2EE Agent.
To install the ODI Standalone Agent:
Unzip the file MIDDLEWARE_HOME/odi/setup/manual/oracledi-agent\oracledi-agent-standalone.zip to MIDDLEWARE_HOME/odi
Rename the appropriate HFM Driver DLL under oracledi.sdk\lib.
If you are on 64 bit, rename HFMDriver64_126.96.36.199.dll to HFMDriver.dll.
If you are on 32 bit, rename HFMDriver32_188.8.131.52.dll to HFMDriver.dll.
Add oracledi.sdk\lib to the path in the Windows system.
Define a new agent in the ODI Master Repository.
Edit MIDDLEWARE_HOME/odi/oracledi/agent/bin/odiparams.bat and update the following master repository connection information: SUPERVISOR password information and ODI_JAVA_HOME.
Start the standalone agent.
Update the ODI URL in the FDMEE System Settings page.
15844671 -- FDMEE fails to load data to Essbase when duplicate members exist across dimensions.
Workaround: Remove duplicate dimension member names. This issue results when the same dimension member name exists in more than one dimension.
15833920 -- Reports are opened in the same pane from which they are run and do not provide a way to return to the previous screen.
Workaround: Select an output type other than HTML.
14342028 -- The Query Data tab is not available.
Workaround: Use reports to query data.
13831793 -- Number format should be locale sensitive for the amount.
13775349 -- Essbase applications should be fully functional after upgrade.
Workaround: Refresh metadata for each Essbase application after the upgrade.
13743427 -- The target account is not displayed for data load mappings in Edit mode.
Workaround: You can change the target member by clicking Edit next to the source, and then updating the target on the Multi-Dimension screen.
13623601/16232449 -- When you run a data rule after upgrading from release 184.108.40.206 to 220.127.116.11.00, an additional drill-down link is created.
Workaround: Manually delete the duplicate drill region directly in the Essbase Administration Services console (EAS). This should only be done when duplicate drill regions are shown for a cell in a Planning application. The obsolete drill region that needs to be removed is in the form of:
"Year" : "Scenario" : "Version"
For example, you might remove: "FY10" : "Current" : "BU Version_1"
The drill region that remains should be in the form: "Year" : "Scenario"
For example, the following drill region would be kept: "FY10" : "Current"
13558551 -- Unable to select an accounting entity when FDMEE is deployed on the WebSphere Application Server.
Workaround: Create an accounting entity group for the source system. After creating the accounting entity group, select the accounting entity in the Entity tab.
13104202 -- Write-back fails for an EPMA deployed ASO Essbase application.
Workaround: Write-back for an EPMA deployed ASO is not supported. Use the classic Oracle Essbase ASO.
Upgrade customers must perform the following FDMEE configuration steps manually:
Set up the Data Server is required for customers upgrading from all versions.
Regenerate the ODI Scenarios is required for customers upgrading from 18.104.22.168.50X or 22.214.171.124.
Create period mapping applicable for customers upgrading from 126.96.36.199.
You need to set up the appropriate data servers based on the ERP source system used to source metadata and/or data.
When importing from ERP sources (EBS/PeopleSoft/Fusion/JD Edwards/SAP), set up the applicable data servers listed below:
EBS_DATA_SERVER—For Oracle E-Business Suite General Ledger
PSFT_FMS_DATA_SERVER—For PeopleSoft General Ledger and Commitment Control
PSFT_HCM_DATA_SERVER—For PeopleSoft Human Capital Management (HCM)
FUSION_DATA_SERVER—For Fusion General Ledger
JDE_DATA_SERVER—JD Edwards Enterprise (JDE) General Ledger
When loading metadata to EPM system setup the following data servers:
HFM_DATA_SERVER—For loading metadata to Oracle Hyperion Financial Management
HPL_DATA_SERVER—For loading metadata to Oracle Hyperion Planning
To update server connections information:
For example, select EBS_DATA_SERVER or PSFT_FMS_DATA_SERVER.
For example, enter oracle.jdbc.OracleDriver
For example, enter jdbc:oracle:thin:@<host>:<port>:<sid>
When you use an Open Interface adapter, JD Edwards adapter, or SAP adapter, regenerate the ODI Scenario in the import format. Normally regenerating the ODI scenario is executed after loading the source data.
To regenerate the ODI scenario in the import format:
This step generates the ODI Scenario based on the import format mappings.
When you have target applications with a data load method not based on FDMEE, create period mappings before running any data loads. Due to a difference in structure of period mappings, they are not upgraded from Release 188.8.131.52 to Release 184.108.40.206.
To update period mappings:
When you install and configure FDMEE, Oracle Data Integrator is automatically installed and configured for you. The database for Oracle Data Integrator is in the same database as FDMEE and the Oracle Data Integrator agent deployed to the FDMEE Managed Server. Optionally, you can install ODI Studio using the ODI_Studio_11123.zip.
To install ODI Studio from a zip file:
For example, if you unzipped to: C:\Temp\odi and the platform is Windows 64 bit, then go to: C:\Temp\odi\Disk1\install\
If you get a warning message, for example, “File Not Found C:/Temp/odi/....../DataFiles/filegroup.jar,” press “Continue” to complete the install.
The ODI Master Repository is installed in the FDMEE schema/database. When you are prompted for the ODI Master Repository name, provide the Oracle Hyperion Financial Data Quality Management Enterprise Edition connection information. The name of the work repository is “FDMEE.”
If you plan to use the SAP ERP Financials or SAP BW integration, you must download the ERPI-SAP Adapter from the Oracle partner Bristlecone’s website. Please register at the website http://www.bristleconelabs.com/edel/edel_login.asp to obtain login information. In addition, refer to the documentation provided by Bristlecone for details regarding the SAP Adapter configuration.
The most recent version of each EPM System product guide is available for downloading or viewing from the EPM System Documentation area of the OTN website (http://www.oracle.com/technology/documentation/epm.html). You can also use the EPM System Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html), which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.
Deployment-related documentation is also available from the Oracle Software Delivery Cloud website (http://edelivery.oracle.com/EPD/WelcomePage/get_form).
Individual product guides are available for download on the Oracle Technology Network website only.
When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid. Workaround: Cut and paste from the HTML version of the document.
In Release 220.127.116.11, the name of the Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications Administrator's Guide has been changed to Oracle Hyperion Financial Data Quality Management Enterprise Edition Administrator's Guide. The name was changed to reflect the new Oracle Hyperion Financial Data Quality Management Enterprise Edition product name.
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.