Extracting General Ledger Data

Follow this process to extract general ledger metadata and data and push into target EPM applications:

1. Register source systems in Oracle Hyperion Financial Data Quality Management, Enterprise Edition by adding details for Oracle Data Integrator and FDMEE, which are specific to the source system.

2. Register target applications for use with FDMEE.

3. Select the Source Accounting Entities.

4. Define import formats and locations.

5. Create metadata rules.

6. Create period mappings for Year and Period dimensions.

7. Create category mappings.

8. Create the member mappings and data load rules.

9. Run the metadata rules to import metadata into Oracle Hyperion Financial Management, Oracle Hyperion Planning applications, and Oracle Hyperion Profitability and Cost Management.

   If you use Oracle Hyperion EPM Architect, you also deploy or redeploy the applications.

10. Run data rules to extract data from the source system and push it into the target applications. Data and metadata are staged in the FDMEE staging tables, extracted from the source system, and loaded into the target application.

    The data loaded is used for multiple purposes by the respective target applications (Planning, Financial Management, or Oracle Essbase). In addition, you can use the sourced data to drill through from web forms in the applications, or Oracle Smart View for Office and Oracle Hyperion Financial Reporting.