EPY: CAN: Pension Special Accumulator Not Expected On Rate "Slide" Using Different Tax Method (Doc ID 2926872.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

Normally, when a cheque has a negative pensionable earnings balance, pension deductions are not calculated for the cheque.   A scenario sometimes occurs in our production environment where a pension deduction is calculated based on a negative pensionable earnings balance. This only appears to occur when there are PAY_ONE_TIME refunds for a pension deduction on the same cheque, and then the pensionable earnings balance changes, but stays negative.

It looks like there is a COBOL error where even though the pension accumulator balance is still negative, the system is trying to calculate a pension deduction as if the pension accumulator was positive, and adding it to the current deduction. Once this error appears, it does not seem to go away even if the PAY_ONE_TIME is adjusted afterwards.


The issue can be reproduced with the following steps:

1. Use a Pension Plan and ensure that the rate type was set to "Slide" using Special Accumulator "KC1" and has an EE and ER rate - Set Up HCM>Product Related>Base Benefits>Plans and Providers>Benefit Plan Table 
2. Create a Special Accumulator Code to associate to the earning - Set Up HCM>Product Related>Payroll for North America>Compensation and Earnings>Special Accumulator Table
3. Created earning code that adds to the special accumulator with Amounts Only, Specified on Paysheet, earnings calc sequence "500", Adds to Gross and subject to Canadian taxes - Set Up HCM>Product Related>Payroll for North America>Compensation and Earnings>Earnings Table 
4. Created another earning code that does not add to the special accumulator with Amounts Only, Specified on Paysheet, earnings calc sequence "500", Adds to Gross but is not subject to Canadian taxes
5. Created another earning code that subtracts from the special accumulator with Amounts Only, does not add to gross pay, earnings calc sequence "500", Specified on paysheet and not subject to any Canadian taxes
6. Create a Pension Deduction code that is classified for both Before Tax and Non-Taxable Benefit which is part of the Benefit Program - Set Up HCM>Product Related>Payroll for North America>Deductions>Deduction Table
7. Hired an employee and enrolled him into Pension - Benefits>Enroll in Benefits>Can-Pension Plans
8. Ran a payroll to verify that the pension amount for both Before Tax and Non-Taxable Benefit was calculated on the cheque  
9. Added an off-cycle paysheet on the next pay calendar for the test employee - Payroll for North America>Payroll Processing CAN>Update Paysheets>By Paysheet
10. Entered in the pay other earnings the earning code "A01" with a negative amount of <ie. 300.00> and entered earnings code "40A" with a positive amount of ie 300.00.  Save the paysheet.
11. Ran the payroll calculation and did not get any pension calculated due to the negative special accumulator - Payroll for North America>Payroll Processing CAN>Produce Payroll>Calculate Payroll & Payroll for North America>Payroll Processing CAN>Produce Payroll>Review Paycheque
12. Go back to the off-cycle paysheet and entered an one time refund of ie. 100.00 for both the Pension for the Before Tax and the Non-Taxable Benefit - Payroll for North America>Payroll Processing CAN>Update Paysheets>By Payline
13. Ran the payroll calculation and got the refund amount only of <100.00> for both the before tax and the non-taxable benefit - Payroll for North America>Payroll Processing CAN>Produce Payroll>Calculate Payroll 
14. Went back to the paysheet and inserted a new row for Addl Nbr 1 and entered earning code "Z03" with a negative amount <150.00> - Payroll for North America>Payroll Processing CAN>Update Paysheets>By Payline
15. Ran the payroll calculation process again and got just the refund amount only - Payroll for North America>Payroll Processing CAN>Produce Payroll>Calculate Payroll

Changes

Cause

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