Hi All, We have identified that this is due to character limitation issue in the Listagg. Also we observed the same report is working for sysdate and it is not working for specific date ranges. We have handled Overflow truncate in LISTAGG to fix our issue. As expected, the report is working.

Hi Sumanth V -Oracle/ @Raktim_Pal-IBM This issue is happening for one of the BIP Report in PROD. I checked the physical query from lower environment to PROD and there is no change. And we are getting this error in next 1minute. It is not even running longer. Has anybody faced this issue in their projects, kindly comment…

Thank you @Dimple-Nagesh-Support-Oracle , @Bhaskar Konar , @Nathan CCC for your valuable time and providing response on this.

Thanks @Dimple-Nagesh-Support-Oracle . I will check on this and reply back. Thanks for your response.

Hi Nathan, Thanks for your reply. But i'm checking regarding the OTBI reports only. We have built few reports and dashboards on OTBI and those report names are listing down when i use the OTBI- Usage real time subject area. I'm looking for the solution to retrieve all the OTBI analysis/Reports that we used. .

Thanks @gclampitt . But i don't see both of the conditions in the SQL. I'm pasting the SQL for reference. SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Performance - Performance Check-In Real Time"."Check-In Questionnaire"."Worker Question Text" s_1, "Workforce Performance -…

Thank you @Nathan CCC . I will check on this.

Please anybody suggest on how to achieve the above case. Thanks, in advance.

Please anybody suggest on how to achieve the above requirement.