Please note the below solution is applicable for version 22.214.171.124
When attempting to export data in the data load workbench to Excel within FDMEE the Excel is returned with a message saying the extension doesn’t match the file type and then then excel file was blank, except header.
This issue is caused by a software defect and it has been logged as bugs 18665000 and 18638754. ADF version that is installed with the EPM Patch 126.96.36.199.510 is not exporting the data to Excel correctly.
•Directly query the FDMEE Database table TDATASEG by LOADID. This is only available if direct access to the DB is available and should only be done by the DBA or FDMEE Admin.
•Run the Base Trial Balance Report in FDMEE to view the GL Data.
Patch 19586149 on My Oracle Support fixes this issue. To apply, please follow these steps:
1. copy p19586149_111171_Generic.zip to c:\Oracle\Middleware\oracle_common\OPatch
2. CD c:\Oracle\Middleware\oracle_common\OPatch
3. unzip p19586149_111171_Generic.zip
4. opatch apply c:\Oracle\Middleware\oracle_common\OPatch\19586149\oui -oh C:\Oracle\Middleware\oracle_common -jdk c:\Oracle\Middleware\jdk160_35