EPY: CAN - SQL Error On Review Paycheque CAN Page "An error has occurred that has stopped this transaction from continuing" Due to Unknown EMPL_RCD 8224 In Record PS_PAY_SPCL_EARNS (Doc ID 2860894.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

SQL Error on Review Paycheque (CAN) page and an unknown EMPL_RCD 8224 in record PAY_SPCL_EARNS

When Gross Earnings = zero (using a non-paying earnings code) and there are other deductions (one with deduction priority = 350 and another at priority = 355 linked to special accumulator), upon pay calculations, it causes a SQL error on the Review Paycheque (CAN) page and an unknown EMPL_RCD 8224 row is inserted into the table PAY_SPCL_EARNS.


The issue can be reproduced with the following steps:

1. Setup an earnings code "LON" - LOA No Pay that has "Hours Only", Does Not Add to Gross Pay, Maintain Earnings Balance, Subject to QPIP Earnings Only, and Earnings Calc Sequence is 300. - Set Up HCM>Product Related>Payroll for North America>Compensation and Earnings>Earnings Table
2. Associate the new earning code to the Earnings Program - Set Up HCM>Product Related>Payroll for North America>Compensation and Earnings>Earnings Program
3. Create a new special accumulator code called "WCP" - WCB Advance Recovery - Set Up HCM>Product Related>Payroll for North America>Compensation and Earnings>Special Accumulator Table
4. Create a General Deduction code "WCBRC" with priority 355 and after tax - Set Up HCM>Product Related>Payroll for North America>Deductions>Deduction Table
5. The after tax row is associated to the special accumulator "WCP" that the effect is "Subtracts from Special Balance" and the partial deduction allowed is checked on
6. Verify the Review Special Accumulator "WCP" that shows deduction code "WCBRC"
7. Create a General Deduction Table for deduction code "WCBRC" that indicates a flat amount - Set Up HCM>Product Related>Payroll for North America>Deductions>General Deduction Table
8. Include that newly created deduction code "WCBRC" in the Company General Deduction Table - Set Up HCM>Product Related>Payroll for North America>Deductions>Company General Deductions
9. Ensure that the plan type "31" deduction code has priority "350" - Set Up HCM>Product Related>Payroll for North America>Deductions>Deduction Table
10. Enroll test employee into the benefit for Plan Type "31" - Benefits>Enroll in Benefits>Disability Benefits
11. Enroll the same test employee into the general deduction "WCBRC" with a flat amount of 99.99 - Payroll for North America>Employee Pay Data CAN>Deductions>Create General Deductions
12. Create an online check for the same test employee and say "Yes" for "Do you wish to use paysheet creation process" - Payroll for North America>Payroll Processing CAN>Create Online Cheques
13. Click "No" for "Would you like to process to load to Time and Labor"
14. Zero out Regular earnings and enter the non-paying earnings code "LON" with 80 hours. If there are other rows, take the okay to pay off.
15. Save and calculate
16. Results of the calculated cheque via the online cheque that shows a zero cheque.
17. Navigate to the Review Paycheque (Payroll for North America>Payroll Processing CAN>Produce Payroll>Review Paycheque)
18. Enter the test employee ID.
19. Select the off-cycle that was generated by the online cheque.
20. Error message "An error has occurred that has stopped this transaction from continuing" is generated
21. Query the PAY_SPCL_EARNS and there is a row with EMPL_RCD 8224 (don’t know where it comes from) with 99.99 and EMPL_RCD 0 has as expected.
22. No Payroll Error Messages with that error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.