Paginated Report ORA-01861 Error

I was finally able to get both the dsCurrQuar and dsReportOutput to run successfully in Oracle and produce a good report, however, still the "literal does not match format string" I've confirmed each column's type and the format of each column matches as it should, nothing is casted outside of what it's originally designated as. If this runs with no issue in Oracle and my connection in Power BI Report Builder goes back to Oracle as the source, why is there still a constant issue with the "literal does no match format string"?

updated dsReportOutput:

select 
max(p.personNumber) personNumber, p.dsplyName,
NVL((select max(c.count) from tableC c
where c.year = to_char('2022')
and c.quarter = to_char(quarter)
and c.personNumber = p.personNumber),0) as chkaccts,
NVL((select max(r.count) from table r
where r.year = to_char('2022')
and r.quarter = to_char(quarter)
and r.personNumber = p.personNumber),0) as reods
from table a, table p, table e
where a.personNumber = p.personNumber
and a.personNumber = e.personNumber
and (e.inactivedate is null or e.inactivedate > sysdate - 366)
order by p.personNumber, p.dsplyName;