EPY: Single Check is Not Using the EMPLID RCD Job Information That is Tied to the Primary Pay Group on Payroll Options (Doc ID 2966697.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

We are having an issue with several multi-job employees where the wrong job information is displaying on the combined advice.  For all of the affected employees, they have a secondary job as EMPL_RCD 0, and their primary job as EMPL_RCD 1.

We have found that the PS_PAY_CHECK table contains EMPL_RCD 0 for these employees any time they have a combined paycheck, and as a result the job details from their non-primary job print on their advice.

-
The issue can be reproduced with the following steps:
1. Employee RCD 0 is the Secondary job with Department R04115 tied to Pay Group "CCT" - Workforce Administration>Job Information>Job Data

2. Employee RCD 1 is the Primary job with Department R02035 tied to Pay Group "CON"

3. Payroll Options has the Primary Pay Group as "CON" - Payroll for North America>Employee Pay Data USA>Update Payroll Options

4. Create paysheets - Payroll for North America>Payroll Processing USA>Create and Load Paysheets>Create Paysheets

5. Verify on paysheets contains earnings for both EMPL_RCD with the Department values - Payroll for North America>Payroll Processing USA>Update Paysheets>By Payline

6. Run payroll calculation - Payroll for North America>Payroll Processing USA>Produce Payroll>Calculate Payroll

7. Verify PAY_EARNINGS that the Pay Group value CON and DEPTID R02035 are correctly pulled from EMPL_RCD 1 but in the PS_PAY_CHECK table, the check has EMPL_RCD 0 information.

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.