How are the dates stored in FAW for reporting, is it fixed to UTC or are shown in local timezone?
For example the Order date in Fusion is shown as per the user's timezone setting, but it is stored in UTC in the database or PVO.
How is it processed in FAW, is it bought in UTC timezone or any other changes done to it?
Excerpt from Oracle standard documentation:
"
The times visible in the Console are in local time zone. However, Oracle Fusion Data Intelligence stores the values for the Warehouse Refresh Date Time and Scheduled Date in the Coordinated Universal Time (UTC) in the autonomous data warehouse.
"
Configure Oracle Fusion Data Intelligence Data
Thanks.
@Jahnavi-Oracle - Adding to the above comment, please refer the below document:
What Is The Default Timezone In FAW and How Can It Be Changed? (Doc ID 2952288.1)
Hope it helps!
Thank you @MandeepGupta , @Sumanth V -Oracle
