FA OTBI/BIP - Dates Does Not Match with Fusion UI; BIP And Analysis Reports Are Showing offset by a day
(Doc ID 2065995.1)
Last updated on JUNE 28, 2022
Applies to:
Oracle Fusion CX Sales Cloud Service - Version 11.1.9.2.0 and laterOracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Information in this document applies to any platform.
Goal
Customer description:
From Sales Cloud domain: Contact birthday using the column 'Date of Birth' and ' Actual Close Date'
OR From ERP/Finance domain: Dates like "Invoice Date" and "Payment Date"
The issue is that with all the contacts, the report day of birth is wrong, it is a day before the correct day
For example:
The contact date of birth is 31 Oct 2001, the BI report returns 30 Oct 2001.
How to fix this issue and made the report shows the dates correctly?
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 |