Export To Excel Shows Date as Number

(Doc ID 2293360.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Analytics

Export to Excel does not work properly

After May 2017 update bundle, when customer tries to export reports into excel , date is converted to number format. They did not have any problems with the export function of reports before and the reports have not been modified.

When they try to export a report in excel they receive two error messages. After the two error message Excel is able to open the files. However all fields including a date appear as a number

ERROR (when opening report in Excel)
-----------------------
We found a problem with some content in 'RL_Wins_SM(7).xlsx. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Export report to excel
2. In the exported file, the format of Date columns is changed and shows as number.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see dates properly in exported excel files.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms