Oracle BIP Report -> Timezone Issues (displays +5 hrs)
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.