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

Session Timezone in BI Publisher

edited Apr 3, 2019 4:04PM in Reporting and Analytics for HCM 2 comments

Summary

BI publisher not using the timezone from the Account screen

Content

I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the user account.

Using a simple data model, I've queried CURRENT_DATE, SYSDATE, SESSIONTIMEZONE and DBTIMEZONE. They all show UPT despite my user preferences showing Central Time.

Is this normal? Is there some setting that needs to be set for this? Do I need to submit an SR?

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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