We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

custom Quarterly report - Not pulling balances details for all employees

Received Response
edited Jan 20, 2021 12:32PM in Payroll and Global Payroll Interface (GPI) 2 comments


Quarterly report - Not pulling balances details for all employees


Hello all,

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.

Please advise.

Thank you,



select /*+ ordered first_rows */ distinct
, REPLACE(pni.national_identifier_number, '-', '') SSN

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!