Welcome to the Oracle Analytics Community

Products Banner

Antoine KAIBER ✭✭✭✭✭

Comments

  • 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"
  • Oh ok but this is directly linked to OTM and not FTI so I already checked, I wanted to see if there was a role in FTI I could change or something like it. I will check again what you tell me but I haven't seen anything corresponding to what I'm looking for, for the moment
  • For information I've added this for-each@section outside the header which seems to work better : The template changes the information in the header but all of the rest of the template is blank :
  • Ok I have deleted a For-each loop and it works fine now, sorry for spamming my thread... :
  • Hello, Do you know what seems to be the problem in my header ? This is what I have in my template
  • Ok sorry for this thread, I should've closed it on friday evening. Problem was fixed but I don't know yet how.
  • Well I posted this : select sum(itm.ITEM_PACKAGE_COUNT) ,sum(coalesce(spu.TRANSPORT_HANDLING_UNIT_GID,'-') TRANSPORT_HANDLING_UNIT_GID) ,coalesce(substr(TRANSPORT_HANDLING_UNIT_GID, instr(TRANSPORT_HANDLING_UNIT_GID,'.', 1)+1, length(TRANSPORT_HANDLING_UNIT_GID)),'-') TRANSPORT_HANDLING_UNIT_XID from SHIP_STOP_ITEM_BOV itm…
  • Weirdly I get "TRANSPORT_HANDLING_UNIT_XID": invalid identifier
  • Well, appart from the ORA number, that was the only error message I got: With your new SQL the Data set can be created (G_1) : But when I run the report it says "report not valid" and I also get this message : ORA-01722: invalid number -- I don't know if it's not coming from the fact that I didnt use links like for other…
  • My internet is very slow atm so if i can avoid downloading SQL Dev it's better. I tried to run SQL plus with a tuto but I get "'sqlplus' is not recognized as an internal or external command," in cmd, do you have an idea why ? Edit: I created a link and I can now launch the report but it doesn't change anything, there is no…
  • What do you call an IDE ? I have an SQL Execution Interface in Oracle where I can try this query but it says : java.rmi.AccessException: [EJB:010160]Security violation: User DBA.CONFIGDBA has insufficient permission to access EJB type=<ejb>, application=GC3App, module=SqlSession.jar, ejb=SqlSessionHome, method=execute,…