What's new in Customer Journeys?

Connect and learn more! ×
Oracle BIP Report -> Timezone Issues (displays +5 hrs) — Cloud Customer Connect
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

Oracle BIP Report -> Timezone Issues (displays +5 hrs)

Accepted answer
edited Mar 3, 2021 6:18PM in Reporting and Analytics for HCM 8 comments


timezone offset



Can anyone please help me?

I have a learning activity with a start time of 08:00 am and with timezone of EST. When it is included in the report (thru RTF or default layout), it is showing as 01:00 pm, which is +5 hrs of UCT.

1) data-model has has the converted timestamp using TO_CHAR

2) set 'JVM' for 'Report Timezone' at both admin and user-level report.

I dont want to convert the time to display based on User's preferred timezone, instead it should display from the server.  When I check the database (raw xml format), it's showing as 01:00 pm whereas it is 08:00 am in the learning UI.


Howdy, Stranger!

Log In

To view full details, sign in.


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