EPY: CAN: Garnishment Processing is Not Including the CP2 (Additional CPP) in DE Taxes (Doc ID 3037776.1)

Last updated on JULY 26, 2024

Applies to:

Symptoms

Garnishment deduction calculation is not including the the CP2 in the process for DE Taxes.

Correct Calculation:
Earnings: 3,217.04
Taxes = CIT 543.05 + CP2 128.87 = 671.92

Garnishment Calculation : 3,217.04 - 671.92 = 2545.12
  2545.12 * 20% = 509.02

But Actual Calculation:
Earnings: 3,217.04
Taxes = CIT 543.05

Garnishment Calculation : 3,217.04 - 543.05 = 2673.99
  2673.99 * 20% = 534.8
 
The CP2 (Additional CPP) amount should be included in the DE Taxes since it is employee paid.


The issue can be reproduced with the following steps:
1. Ensure the Canadian employee is enrolled into Garnishment on General Deduction Data - Payroll for North America>Employee Pay Data CAN>Deductions>Create General Deduction
2. Ensure the Canadian employee is enrolled into Garnishment Processing using Rule ID "GENERAL" - Payroll for North America>Employee Pay Data CAN>Deductions>Create Garnishments
3. Create Paysheets - Payroll for North America>Payroll Processing CAN>Create and Load Paysheets>Create Paysheets
4. Run payroll calculation - Payroll for North America>Payroll Processing CAN>Produce Payroll>Calculate Payroll
5. Verify that the CP2 was calculated for the additional CPP on Review Paycheque Taxes - Payroll for North America>Payroll Processing CAN>Produce Payroll>Review Paycheque
6. Click on Review Paycheque Deductions and verify in the Garnishment section that the DE Taxes is not including the employee Additional CPP amount

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.