OBIEE 11g: 12/31/9999 Turned Out 1/1/1970 in Exported EXCEL 2007 (Doc ID 2115047.1)

Last updated on OCTOBER 19, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]
Microsoft Windows x64 (64-bit) - Version: 2008 R2

Symptoms

- Platform: Microsoft Windows 64
- Product Version: 11.1.1.9.0

The issue has been identified on Windows 64 port and not on the linux 64 port.

Date "9999/12/31" can be seen as "9999/12/31" on Analytics, but when exported to Excel 2007, it turned out to be "1/1/1970".

Tried to export "CAST('9999/12/31' AS DATE )" to Excel 2007, the date turned out to "1/1/1970" or "12/31/1969".
When you export "9999/12/31" to CSV, the date "9999/12/31" is as is. 

Applied the patch#20912569 but the issue did not solve.

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