My Oracle Support Banner

EPY: CAN - SQL Error On Review Paycheque CAN Page With Unknown EMPL_RCD 8224 In Record PS_PAY_SPCL_EARNS (Doc ID 2860894.1)

Last updated on APRIL 06, 2022

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

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 SQL error on the Review Paycheque (CAN) page and an unknown EMPL_RCD 8224 row is inserted into the table PAY_SPCL_EARNS.

ERROR
-----------------------
"An error has occurred that has stopped this transaction from continuing"



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 your 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. You are able to see the 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. You get an error message "An error has occurred that has stopped this transaction from continuing"
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


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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