user timezone is not showing in oracle bi publisher report

Question

Hi ,

I am facing the issue while display the request run time in BIP report and it is not showing the user time zone.

Its showing the JVM or Database time ( ahead of 5 hours whenever run the reports).

Could you please help me to resolve this issue.

Thanks,

Ramesh.A

Ramesh A · Answer

Hi Federico

Thanks for your input.

I am checking on it and update on it.

Thanks

Federico Venturin - Oracle · Answer

Hi @User_R3CQA ,

Which type of report template are you currently using?

When displaying datetime values, BI Publisher takes into consideration the time zone of the user running the report, but the report template must be either RTF or XSL. Moreover, the datetime element in the XML file must include the UTC offset.

In OBIEE/OAS/OAC, the time zone is retrieved from the user's profile settings (My Profile > My Account > Preferences > Time Zone).