Hi @Silvio Garber-Oracle Thanks for your reply! We have created SR and Devops team force published the Sandbox. After that it started working. RCA is yet to identify. Thanks, Keerthana

Hi, I'm able to achieve this by creating a dataset with two separate logics and joined with person number,Date,Action code, Reason code. Below is the query i used for it. select "HCM - Workforce Gains and Losses"."Time"."Date", "HCM - Workforce Gains and Losses"."Basic Information"."Person Number", "HCM - Workforce Gains…

Hi @Raghavendra Raghunath-Oracle , Thanks for your reply. But we want to track based on person level irrespective of assignments.

Hi @Raghavendra Raghunath-Oracle, Please find the result for one of the employee (data is hidden for privacy purpose). We need basically one row for one employee to track the global transfer cases. https://us.v-cdn.net/6037859/uploads/JC9R72MUAWRL/testdata.xlsx @Ayoub Afrass_1 - Please feel free to add your comments for…

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.