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
31
Views
7
Comments
edited Jan 20, 2021 12:32PM in Payroll and Global Payroll Interface (GPI) 7 comments

Summary

Quarterly report - Not pulling balances details for all employees

Content

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,

Satya

 

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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