My Oracle Support Banner

In BI report, a custom DATE field returned dates off by 1 day (Doc ID 2172797.1)

Last updated on JANUARY 24, 2019

Applies to:

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

Goal

In Application Composer, a custom field is of Type "Date", but in BI, it is returned as a DATETIME, or TIMESTAMP value.

This is causing end user confusion because they are seeing the values returned converted to their timezone, which results in the date values being incorrect.

Is this expected behavior?
How can you show the correct Date values?
 

Solution

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
Goal
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.