In BI report, a custom DATE field returned dates off by 1 day
Last updated on APRIL 19, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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?
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