Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications

Release FIN-E


Purpose. 1

Overview.. 1

Installation Information. 1

Configuration. 2

Using the Adapter. 3

Tips and Troubleshooting. 3

Known Issues. 4

Notes: 4



This document includes important, late-breaking information about this release of Oracle Financial Data Quality Management ERP Integration for Oracle Applications. Review this Readme thoroughly before installing Oracle Financial Data Quality Management ERP Integration for Oracle Applications.


The FDM ERP Integration Adapter is a component of FDM that allows users to do the following:

Execute ERPI Data Rules that have been defined in ERPI.

Drill through from the EPM target application and view data in the ERP source system.

Date Created:     02/10/12

Adapter Version:  ERPI-FIN-E.xml


Compatibility:      See the FDM Readme for FDM and ERP Integrator compatibility information

Installation Information

Late-breaking information about 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.

This section includes important information about installing this release of the ERP adapter.

Note: Oracle Data Integrator (ODI) must be installed before adding the FDM ERP Integrator adapter. ODI is downloaded from Oracle E-Delivery, and is installed separately from EPM. See the ERPI Administrator’s Guide for ODI configuration information.

To add the Pull adapter to an FDM application:

1.    From FDM Workbench, open an FDM application.

2.    Select the Adapters tab.

3.    Select File and then Import.

The Open Metadata Import File dialog box is displayed.

4.    Browse to find the file ERPI-FIN-E.xml and click Open.

5.    Select the ERPI-FIN-E adapter from the list and then click OK.

The FDM ERP Integrator adapter is displayed in the list of target adapters.

6.    Select File and then Register Adapter.

The Register Adapter dialog box is displayed.

7.    Browse to find the file named fdmERPI.dll and click Open.

8.    Click OK.



To configure the adapter:

1.    In FDM Workbench, from the Adapters tab, select the adapter.

2.    Right-click and select Options.

The Adapter Options dialog box is displayed. The Options menu enables you to select any of the options for the selected adapter and change the option settings.

3.    Set the adapter options per the guidelines in the following table:


Option Name

Information Required

ERPI Data Rule Name

The name of the ERPI data rule to be executed.

ERPI Execution Mode

Execute the ERPI Data Rule using SNAPSHOT or FULLREFRESH.

Enable Drill Through

On/Off switch used to allow drill through to the source system.

Generate data file for audit trail

On/Off switch used to generate a data file. The data being pulled from ERPI is occurring at the database level; that is., insert data from ERPI database into FDM database directly. Use this option when a data file is required for audit purposes, for example.

System Key

Internal use. Do not modify.

File Prompt

Internal use. Do not modify.


Using the Adapter

Using the ERP Integrator adapter involves the following three steps:

4.    Update all of the required adapter options.

5.    Set up an adapter type import format that executes the ERPI adapter being configured.

6.    Assign the import format to a location.


Note: Use the FDM Web Client to perform the following procedure.

Step 1: Update all of the required adapter options.

Note: Adapter options must be set per the guidelines outlined in the section titled “Configuration.”


Step 2: Set up an adapter type import format that executes the ERPI adapter being configured:

a.    Select Metadata,and then Import Formats.

The Metadata screen is displayed.

b.    Add a new import group by selecting Add in the upper grid and set the File Type to “Adapter.”

c.    Click Update Grid.

d.    In the lower grid, add a source adapter by selecting Add.

e.    Click Select Source Adapter.

The Select Source Adapter dialog box is displayed.

f.     From the Select Source Adapter dropdown list, select (ERPI-FIN-E) ERPI Integrator, and click OK.

g.    Click Update Grid.


Step 3: Assign the import format to a location:

a.    Select Metadata > Locations.

b.    Select the location that will use the Import Format created in Step 2.

c.    Select the Workflow Behaviors tab.

d.    In the Import Format field, select the import format created in Step 2 and click Save.

Tips and Troubleshooting

Adapter Logging

Enable adapter logging by modifying the Connect action in the adapter.

7.    Log in to FDM Workbench.

8.    Click the Adapters tab.

9.    Locate the ERPI adapter under Source System Adapters.

10. Expand the ERPI adapter, and then expand Actions.

11. Double-click the Connect action and find the following text:

12. objERPI.GenerateErrorLog = RES.FDMFalse

13. If logging is desired, change RES.FDMFalse to RES.FDMTrue and then click Save.

14. The log file will be generated in the Outbox\Logs directory of your FDM application. The name of the file will be <Name of Adapter>.log.

Attribute Required for Drill Through

ATTR14 of the target system adapter (Essbase and Financial Management) is a required field to allow drill through. By default, all ATTR values are enabled upon installation. Do not disable ATTR14 in the Essbase or Financial Management target adapters.


Known Issues

Setup Requirement to Enable Drill Through

Problem: When using Integration Option 1 to store Data Rule Name (from the Locations screen) the named entered will be converted to upper case and stored that way.

Solution: In ERPI, use all upper case characters when typing in the Rule Name.

Problem: A copy of the ERPI Adapter doesn’t support drill-through.

Solution: Do not make copies of the ERPI adapter. Import the adapter and use Integration Option 1 to specify the rule names.


·         The use of "-" in any database object is not supported. This applies to schema names and database server names.

·         Data is transferred from ERPI to FDM using a database link. In order for the link to properly execute (from the database server) matching TNS entries (Oracle only) must exist on both the database server and the FDM application server.

·         ERPI and FDM must be running on the same database platform (SQL-to-SQL or Oracle-to-Oracle) for the integration to function correctly

·         The data from ERPI has sign conversion automatically performed for the Equity, Liability, and Revenue account types.

·         When upgrading to FDM Release from FDM release Schema Updater will move the value in the Integration Option 1 field to the Integration Option 3 field for all locations. This will retain drill through to ERPI functionality for data that was loaded using FDM Release From FDM Release and later, Integration Option 1 will be used to hold the override ERPI data rule name for the location.

·         This release of the adapter supports additional languages. See the Oracle Hyperion Enterprise Performance Management System Certification Matrix ( for information about localization for this adapter.


Extensive problems can occur if you switch the ERP system connection information for the Physical Schema in the Oracle Data Integrator Topology Manager after you have completed initial configuration. For example, extensive problems can occur if you start using one physical schema (ERPTEST) pointing to ERP Test Instance1 in the Oracle Data Integrator Topology Manager and then change to a connection information in this physical schema to point to ERP Test Instance2 without first creating a new context in Oracle Data Integrator. The correct procedure is to create two physical schemas (ERPTEST1 and ERPTEST2) each pointing to a different ERP instance. Then, create two contexts and associate the appropriate physical schema to the logical schema in the context.

See the FDM Readme and the Oracle Financial Data Quality Management ERP Integration Adapter for Oracle Applications Administrator’s Guide for additional information.