My Oracle Support Banner

OBIEE 12.2.1.4 - Exported Excel Reports Are Showing Dates One Day Earlier Than What is Displayed in Answers (Doc ID 2428290.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Oracle Exalytics Software - Version 2.0.0.1.0 and later
Business Intelligence Answers Option - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Exported excel reports are showing dates one day earlier than what is displayed in answers

For example, Selecting 'Greater Than Or Equal To' for the filter with a date of 6/1/2017 for results in the following:

OBIEE report starts with 6/1/2017:


Export to Excel 2007+ report starts with 5/31/2017:





The issue can be reproduced at will with the following steps using sample sales rpd:
1. Select Calendar date.
2. Filter using 'Greater than or equal to'.
3. Select a date, such as 6/1/2017.
4. Results tab shows first cell of 6/1/2017.
5. Export to Excel 2007+ and see the first cell of 5/31/2017.



Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.