FYI, I added the line_sequence field in my Data_Set Ship_Stop and did a juncture between my Data sets Ship_Stop and Stop_Address on the filed '"line_sequence" and I solved the problem of having two "stop_address" blocks in a "Ship_Stop" block. So that's one less problem. But I still have the biggest problem which is that…

Hi Fernando, Thanks for your help, unfortunately this compatibility mode was set to False so it doesn't seem to be the solution. I will see for an SR and if I have an answer I will keep this thread updated, even though i'm not in charge for SR's so it might take some time. Thanks again, Antoine

Hi Fernando, Yes I have disconnected and reconnected but it still doesn't work. I found this link which apparently is about this same issue but on Oracle Sales Cloud : https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=269643864077291&id=2328335.1&_afrWindowMode=0&_adf.ctrl-state=125hed2gci_4 I'm wondering…

Hi Fernando, Ok I tried with JVM as well but it didn't work. I also already tried changing my timezone, directly in OTM (the concerned information system) and BIP but it had no impact unfortunately.

As for the SQL, this is what I have for instance : select distinct shs.attribute_date1 as Arrival_Plan_stop, (utc.get_local_date(shs.ESTIMATED_ARRIVAL,shs.LOCATION_GID)) as Arrival_Estimate_stop, (utc.get_local_date(shs.planned_departure,shs.LOCATION_GID)) as Departure_Plan_stop,…

Hello Fernando, I've used the same parameters as you (except the formatting mask I have is Short_Time and not Medium_Time like you, I don't know what it corresponds to) and still the time doesn't change. I've also changed the format of the field in my report to "date only" to see if it had an impact and, indeed, instead of…

Hello Fernando, Thanks for your help, i've changed the properties of my date fields to "Date and Time" but unfortunately it doesn't change anything. I'll continue searching

Where do you have the "Date format" field ? I only have these fields :

Hello Fernando, I've already tried changing the timezone the "Ignore User Timezone" setting to True in the properties but it doesn't change anything. I haven't seen the Date & Time attribute on the report. Update: the bug seems to occur for every report, on recent shipments only (old shipments aren't concerned by the +1…

Hello Fernando, Thank you for your answer, my timezone in BIP is GMT+1 but even if I change it, this has no effect on my report. When I launch my report with old data (old shipments), the time displayed is correct but apparently for recent shipments this doesn't work. So the problem must not come from BIP but OTM (the…