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

BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTC

edited Jun 7, 2021 3:06PM in Reporting and Analytics for HCM 1 comment

Summary

Trying to display Report Run Time in User TimeZone, but unable to do it

Content

The requirement is to display the Date and Time in user Timezone. I came across few documents which say that the default setting is user Timezone and not the Sever Timezone. But the report always returns UTC time. In Report->Edit->Properties->Formatting, the setting is default as displayed in the screenshot.

https://docs.oracle.com/cd/E92519_02/pt856pbr3/eng/pt/txml/task_UsingTimeZonesinBIPublisherReports-5f7f64.html

https://docs.oracle.com/middleware/12211/bip/BIPUG/GUID-DCC0EB34-F81A-436F-8F36-AA3BFF11E7F1.htm#BIPUG138

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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