Invalid date in BIP report for some users

User_ZTN0B · Jan 13, 2022 7:52PM

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 · Jan 13, 2022 8:07PM

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 · Jan 13, 2022 8:41PM

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

A.JOSH · Jan 13, 2022 9:50PM

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 · Jan 13, 2022 11:33PM

Thanks @A.JOSH This helps !

Bhaskar Konar · Apr 18, 2022 7:33AM

Thank your very much for sharing. Appreciate your help.

Oracle Transactional Business Intelligence Forum

Categories

Invalid date in BIP report for some users

Answers