EPY: CAN - After Apply Patch 34851193 the Provincial Tax Rate Not Found Error Was Produced When Running Preliminary Calculation for Canadian Pay Group (Doc ID 2962454.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

We applied the Patch 34851193 and the Provincial Tax Rate Not Found Error was produced when running preliminary calculation for the Canadian Pay Group in TEST and Production environment.

There was an effective dated row for 01/01/2023 in the CAN_TAX_TBL table but there were no related rows in the CAN_TAX_PROV table for the same effective date.

Demo environment had the expected row of 01/01/2023 on the Provincial Tax tab in the Canadian Tax Table when that patch was applied.

The issue can be reproduced with the following steps:
1. Apply the patch 34851193 for the Canadian Tax Table change for effective date of 01/01/2023
2. Create paysheets - Payroll for North America>Payroll Processing CAN>Create and Load Paysheets>Create Paysheets
3. Ran payroll calculation - Payroll for North America>Payroll Processing CAN>Produce Payroll>Calculate Payroll
4. Verify PAY011 - Payroll for North America>Payroll Processing CAN>Review Processing Messages>Review Payroll Error Messages>

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.