Thank you Fernando for taking the time to find the workaround. It works for me too It is strange to see, the same query gets executed in normal run in the database, whereas in BIP we have to say Oracle's sql is a non standard sql Regards, Donald

Please let me know if you come across any solution Good luck!

Please let me know if you come across any solution Good luck!

Hello Ishan Agarwal I am still looking for a solution for this issue. However, I approached writing a data model with one data set whihc has a WITH CLAUSE query. I suupose the other option to the desired output would be instead of using Excel, youcan define the template in MS Word. In the report output option you give the…

Good one, I will remember that, "We have two pieces of software...." Regards, Donald

Hello Fernando, We are working with Oracle Cloud Financials, so creating the function in database is not possible and therefore the use of FUNCTION in the WITH clause. Thank you for spending time on this issue. Would love to hear how to get around it. If I come across any solution,will keep you updated. Regards, Donald

Hello Fernando, Yes I noticed that := assignment was creating the problem, thank you. But in a PL/SQL function you have to assign the values to a variable in that method, whereas BI Publisher doesn't accept it. How to overcome this issue in BIP? Regards, Donald 

Engine Log File 2.txt attachment Regards, Donald

Hello Fernando, Thank you for taking the time to look into the issue and for your reply. The query works fine outside BI Publisher, no problem. I tried to add alias to the columns in the main query, no benefit. I have attached the engine log file for your reference. Also, below change I did, discable statements FOR LOOP…

Thank you Aman for your solution. It was a browser problem. In Chrome I was not able to see the 'Add Column...' whereas in MozillaI was able to create it as per the steps you mentioned. Regards, Donald