BI query returning learner activity score returns blank after Redwood implementation

Summary:

We have implemented Redwood 24D release this month. A query that was initially returning scores of employees is now returning blank data

Content (please ensure you mask any confidential information):

Query shared below.

Version (include the version you are using, if applicable):

24D. Query was working before switching to Redwood.

Code Snippet (add any code snippets that support your topic, if applicable):

Query that fetches scores for learners for offerings ending with Selfy Shot and activities with name Selfy Quiz:

Withemp_dtlsas(select distinctpapf.person_number as EmployeeCode,course_li.learning_item_number as CourseNumber,course_li_tl.name as courseName,offering_li_tl.name as OfferingName,'Selfy Shot' as Category,wlf.learning_item_number as OfferingNumber,offering_li.CLS_ATTRIBUTE2 as OfferingType,to_char(warf.CREATION_DATE,'dd-mm-yyyy') as startDate,to_char(warf.COMPLETION_DATE,'dd-mm-yyyy') as enddate,case when warf.status in ('ORA_ASSN_REC_DELETED') then 'Deleted'when warf.status in ('ORA_ASSN_REC_NOTSTARTED') then 'Not Started'when warf.status in ('ORA_ASSN_REC_ACTIVE') then 'Active'when warf.status in ('ORA_ASSN_REC_WITHDRAWN') then 'Withdrawn'when warf.status in ('ORA_ASSN_REC_REQ_APPROVED') then 'Request Approved'when warf.status in ('ORA_ASSN_REC_PENDING_PREREQ') then 'Pending Prerequisite'when warf.status in ('ORA_ASSN_REC_BYPASSCOMPLETE') then 'Bypass Complete'when warf.status in ('ORA_ASSN_REC_PENDING_ACTIVE') then 'Pending Active'when warf.status in ('ORA_ASSN_REC_CONTENT_COMPLETE') then 'Pending Required Evaluation'when warf.status in ('ORA_ASSN_REC_COMPLETE_PENDING') then 'Complete Pending'when warf.status in ('ORA_ASSN_REC_COMPLETE') then 'Completed'when warf.status in ('ORA_ASSN_REC_INPROGRESS') then 'In Progress'when warf.status in ('ORA_ASSN_REC_WAITLISTED') then 'Waitlisted'when warf.status in