custom Quarterly report - Not pulling balances details for all employees
SummaryQuarterly report - Not pulling balances details for all employees
We gone live with Payroll in January 2020. We developed a custom interface to get quarterly balances and send to state.
Until yesterday morning, we are able to balance the amounts and everything worked perfectly. Mean while payroll confirmed for 2021. But from after noon onwards, report is not working. Could you please advise me what I am missing. I didn't modify any code. Now no rows are returning through this SQL.
select /*+ ordered first_rows */ distinct
, REPLACE(pni.national_identifier_number, '-', '') SSN