You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Is it possible to change time zone on CURRENT_DATE SQL filter?

edited Jun 4, 2020 10:32PM in Reporting and Analytics for HCM 5 comments

Summary

We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?

Content

Hi HCM Reporting Community!

We are putting together a bunch of report tiles that pull transactions from different subject areas in the past day. We have used the following filter to get these transactions:

Creation Date is greater than or equal to CURRENT_DATE

This filter works well, but it thinks the current date is from 7pm-7pm on any given day, not 12am-12am. I think this is the result of the database counting days based on UTC time. How can we change this so we can accurately capture a given day's values? Is it possible to change the timezone from UTC to local time on a system level for OTBI? Has anyone else run into this issue? To be clear, the values themselves at showing in our correct local time zone, it is just the CURRENT_DATE filter that is pulling the wrong time zone.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!