Follow this process to extract general ledger metadata and data and push into target EPM applications:
Register source systems in FDMEE by adding details for Oracle Data Integrator and FDMEE, which are specific to the source system.
Register target applications for use with FDMEE.
Select the Source Accounting Entities.
Define import formats and locations.
Create metadata rules.
Create period mappings for Year and Period dimensions.
Create category mappings.
Create the member mappings and data load rules.
Run the metadata rules to import metadata into Financial Management, Planning applications, and Profitability and Cost Management.
If you use Performance Management Architect, you also deploy or redeploy the applications.
Run data rules to extract data from the source system and push into target applications. Data and/or metadata is 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 Essbase). In addition, you can also use the sourced data to drill through from web forms in the applications or Smart View and Financial Reporting.