Data Export From FDMEE to Excel Returns Blank Spreadsheet


Please note the below solution is applicable for version 11.1.2.3

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 11.1.2.3.510 is not exporting the data to Excel correctly.

Workaround:
•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

Thanks,
~KKT~

Advertisements

One thought on “Data Export From FDMEE to Excel Returns Blank Spreadsheet

  1. Nice tutorial. The FDMEE tutorial was help ful for me. Keep Sharing Tutorials.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s