E1: 07: Pay Period End Date (PPED) on Interim Check Payment History F06156 does not Match the F0618 Pay Period Ending Date (Doc ID 2980534.1)

Last updated on OCTOBER 16, 2023

Applies to:

Symptoms

After UN7 upgrade, when an Interim is processed and merged into the Payroll workbench, the PPED in F0618, Timecard History, is correct but the PPED in F06156, Paycheck History, is not. This is causing significant compliance reporting issues. The F06156 table is using the Payroll Workbench Header PPED instead of the Interim Workbench Header PPED.

Steps to duplicate:
1. From P07210I, Interim Entry, add an Interim ID with Pay Period set as followd: PPED = 10/4/23, CKDT (check date) = 10/6/23, EFTB (beginning effective date) = 9/28/23
2. Add an Interim check and save, taking note of the dates.  
3. Review Payment  shows correct ending dates.
4. From P07210, Payroll Workbench, Merge Interims into Payroll ID sett as follows: PPED = 10/25/23, EFTB = 10/19/23, CKDT = 10/27/23, EFTE (ending effective date) = 10/25/23
5. Submit PrePayroll and Payment review shows Interim has been merged into the workbench, notice the dates have not been changed.
6. Run the other workbench steps and FINAL update.
7. From P070601 review Payment History after final update, notice the PPED is now 10/25/2023 which is incorrect and causes reporting issues.
8. From Databrowser review the F0618 Table to see the PPED for this CKCN the PPED date is correct in the F0618. The F06156 shows the Wrong PPED Date.
This causes inconsistent data across multiple tables and has a HIGH impact on reporting for Certified Payrolls and other compliance items.

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.