EPY: CAN - Quebec Parental Plan Employer Portion Is Not Accurate When Large Amounts Are Being Paid (Doc ID 2735529.1)

Last updated on MAY 17, 2021

Applies to:

Symptoms

The Quebec parental plan employer portion can be off a couple a cents when an employee is paid a large amount in the North American payroll (ie. an employee is paid a bonus of say 50,000 dollars that is eligible for QPIP).

The reason the calculation is off for the employer portion of the QPIP is because the field QPIP-STD-ER-PREM-RT used to store the employer rate is defined with 4 decimal places instead of 5 decimal places like the employee portion. This field is defined in the cobol program PSPCTXRT.cbl.

The government rate for the employer portion of the QPIP is .692. The program divides .692 by 100 and stores the result in the field QPIP-STD-ER-PREM-RT.

Since this field is defined as 4 decimal places the value of .0069 is stored in the field instead of .00692.

In the field QPIP-STD-ER-PREM-RT used to store the employer rate is defined with 4 decimal places, it should be 5 decimal places instead.


The issue can be reproduced with the following steps:
1. Pay a large amount (ie. Bonus) to the employee
2. Run the payroll calculation
3. Review Paycheque Taxes for QPIP Employer

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.