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…

Thanks for your answers, i've actually managed to find a solution, it apparently came from a field / juncture. Weird though since it seemed to me that my xml was good...

Hello, I'm not sure I understand everything but I my queries are in different data sets : Ship_stop : select distinct itm.SHIPMENT_GID , itm.STOP_NUM , itm.STOP_ACTIVITY , itm.LOCATION_GID , itm.S_SHIP_UNIT_LINE_NO , substr(LTRIM(itm.LOCATION_GID,itm.DOMAIN_NAME||'.'),13,19) STOP_GATE ,…

But if your link is only to join multiple Data Sets I have already done it. As i've said the stop_address Data Set is within the Ship_stop Data set, they are linked by location_gid.

One location_gid = One address such as below : (There is a juncture on location_gid = stop_add_loc) But in some cases I have carriage return in the address so it duplicates my stop_address and my ship_stop as you can see in my original Post (FYI it's a problem because when the address is doubled, the quantities of my items…

The address in my original post which doubles Data Sets is due to carriage return: STP_ADD_LINE (49 BOULEVARD ESTIENNE D'ORVES) STP_ADD_LINE (ZAC DU POLYGONE) That means that in Location_gid PEI.00096247_00_GG1, the address is written as follows : 49 BOULEVARD ESTIENNE D'ORVES ZAC DU POLYGONE where : * 49 BOULEVARD…

Ok thanks but the thing is I don't want to avoid CR. For example if I have this : 49 BOULEVARD ESTIENNE D'ORVES ZAC DU POLYGONE I want to display it as it is in my report. This means I would most likely have several fields : 49 BOULEVARD ESTIENNE D'ORVES -> STP_ADD_LINE1 (where the clause would be something like (SELECT…

Yes indeed but as I wrote in my OP this "didn't work as (I think) it doesn't know to what la.location_gid corresponds to, so there is no data on the XML corresponding to the address when I put this clause (I would want the field to return data from the location_gid of the ship_stop of the shipment_gid." So I thought, since…

I think I'm not in the good forum actually but if someone know the answer i'm all ears... Fyi both users have BIADMINSITRATOR

I didn't configure (and don't know how to) anything else then their users in OTM this is to say what is below : How can I see if some user has some denials on accessing the catalog or the personal folder?

Yes but I don't see anything like "my account"