Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
custom Quarterly report - Not pulling balances details for all employees
Summary
Quarterly report - Not pulling balances details for all employeesContent
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
0