FDMEE extracts EBS GL data from the apps schema using custom ODI data flows and then pushes the data into EPM target applications after performing any required transformations.
More details can be found in the FDMEE admin guide http://docs.oracle.com/cd/E40248_01/epm.1112/erpi_admin_11123200.pdf
You can see the 'Architecture' section for a conceptual overview of data flows and 'Source System Tables Used by FDMEE' for details on access that is required to the EBS GL schema if using the apps user is not possible.
1. Which Hyperion production are you using - Essbase, Hyperion Planning or Hyperion Financial Management
2. Is your requirement to seamlessly integrate with EBS system or is your requirement is to only load actuals data into your Hyperion essbase or Planning cubes ?
3. Did your company already invested money in FDM and ERPi ( i.e FDMEE)
Based on your answers, we will be able be guide you better
Sandeep Reddy Enti