OBIEE 12c: When Exporting Date Columns To Excel 2007+ It Showing One Day Behind With Time Stamp
(Doc ID 2455582.1)
Last updated on MAY 09, 2021
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition (OBIEE) 22.214.171.124 version,
- Have done out of place upgrade of OBIEE from 11.1.9 to 126.96.36.199
- Migrated 11g objects to 12c.
- When exported a report with date columns to excel, date columns are going back by 1 day.
For example, Invoice Date in excel= 07/27/2012, then when it exported to excel the date in excel is 07/26/2012.
This issue observed in both On-Premise and OTBI environments whenever there is out-of-place upgrade from OBIEE 188.8.131.52.x to 184.108.40.206
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document