Invalid date in BIP report for some users

User_ZTN0B

Hello,

We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are seeing 14-Nov-21 in the report output .. on the other hand, it's shown correctly to the other users. Any pointers on if any date/time settings are needed to fix such problem ?

A.JOSH

It could be that those users might be having different Regional settings than other users .. Can you confirm what are the timezone settings at bip level in BIP as well as in general preferences -

BIP regional settings -

Regional settings in General Preferences -

User_ZTN0B

Thanks. We see various users have different timezone settings as they belong to different regions..

A.JOSH

There could be various causes behind such date transformations.

Usually, all dates are stored at DB level in Coordinated Universal Time (UTC) and are presented to user based on their set timezone settings. We'd come across such situations and the workaround/fix was to format the date in such a way that you don't extract the timezone part of the date (T00:00:00.000+00:00); you can do that by using the good old dat conversion like to_char(DATE_COLUMN,'YYYY-MM-DD'). This solved our issue.

Other possibilities/considerations could be as per these notes -

Doc ID 2168341.1 -https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=82207283713703&id=2168341.1

Doc ID 2256176.1 - https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=82335171609407&id=2256176.1

User_ZTN0B

Thanks @A.JOSH This helps !

Bhaskar Konar

Thank your very much for sharing. Appreciate your help.