OPERA CLOUD VS OPERA R&A Timing ARE NOT MATCHING

User_TSZUE

Hi team,

My time in Opera is Different from time in R&A for example, if the Reservation time created in opera is 16/01/24 - 4:40 Am in R&A it shows 15/01/24 - 5.40 exactly 11 hrs. behind that exactly matched up with the the time zone difference.

It is correct in Opera cloud so how can i Fix this issue

Renuka Nuguru-Oracle

Hello,

Have you tried cast function and test the dates.

Example: cast(datecolumn as date)

Thanks,

Renuka

User_TSZUE

Hi Renuka,

Thank you for the reply.

i have tried it, but the problem is I have two separate rows Created date and Created time column, if its just the time i can just add up.

As we are 11 hours ahead i don't know how we can just add it unless it pull directly from Opera cloud.

If you see the attached screen shot the date in opera is 01/09/2023 and time is 7:51Am, but in R&A is different.

Harriet Huang-Oracle

Hi @User_TSZUE ,

What's your OBIEE/OAS version?

Here are some documents related to time zone change in OBIEE and OAS. Please check if they are helpful.

How To Globally Change Timezone Settings In OBIEE 12C For BI Publisher (Doc ID 2242862.1)

How To Use The Timezone Functionality In OBIEE 10 / 11g / 12c (Doc ID 953881.1)

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/where-are-time-zone-specifications-stored.html#GUID-F1735A62-CF96-406C-89D6-BA7A6CCB61F3

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/description-time-zone-settings.html#GUID-339DF4A7-9E7C-4052-B4AF-AC5DC270B21A

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/example-configuration-file-settings-specifying-time-zone.html#GUID-70FDF3B1-98FB-4601-9044-162C854A41AD

Agil

Hi @User_TSZUE, Did you find the solution. I am experiencing the same.