ETL9.1: PSPLDTL1 Loading Same Payable Time To Multiple Pay Sheets. (Doc ID 1501829.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, NA Payroll Integration/TL Load

Payable time for Saturday and Sunday (4/7 & 4/8) is loaded to both the old paygroup and the new paygroup paysheets. This happens when employee transferred to new paygroup within the current period of the new paygroup, and the old paygroup period begins prior to the current paygroups start date, and both paygroups are included in the same payrun.

Expect the payable time being loaded to the new paygroup which includes loading the prior period time should set payable status to TP for 4/7 & 4/8 and not also load it to the old paygroups paysheet too.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have two weekly paygroups TR1 & TR3 set up (Main Menu>Setup HRMS>Product Related>Payroll for North America>Payroll Processing Controls>Paygroup Table)
2. current pay calendar for TR1 paygroup is Monday to Sunday 4/9 to 4/15 (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Create and Load Paysheets>Review Pay Calendars)
3. current pay calendar for TR3 paygroup is Saturday to Friday 4/7 to 4/12 (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Create and Load Paysheets>Review Pay Calendars)
4. assign both paygroups calendars to the same payrun (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Create and Load Paysheets>Review Pay Calendars)
5. Time and Labor installation setting specifies to load prior paygroup time to current paygroup (Main Menu>Setup HRMS>Install>Product and Country Specific>Time and Labor Installation)
6. report time for employee from 4/7 to 4/12 (Manager Self Service>Time Management>Report Time>Timesheet)
7. Run Time Admin to create payable time for the employee (Main Menu>Time and Labor>Process Time>Request Time Administration)
8. Approve the payable time if needed (Main Menu>Manager Self Service>Time Management>Approve Time and Exceptions>Payable Time)
9. Transfer employee to paygroup TR1 from TR3 as of 4/9/12 (Main Menu>Workforce Administration>Job Information>Job Data)
10. Run the TL Load process for the payrun assigned to both paygroups pay calendars (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Update Paysheets>By Payline)
11. Observe that TR1 paygroup has payable time loaded to it for 4/7 thru 4/12 on the paysheet (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Update Paysheets>By Payline)
12. Check paysheet for paygroup TR3 to see if it also had payable time from 4/7 to 4/8 loaded to it. (Main Menu>Main Menu >Payroll for North America>Payroll Processing USA>Update Paysheets>By Payline)


Transferred employee can be overpaid, and when the pull cost process is run it abends with a unique constraint as the payable time is entered twice in the PS_TL_XREF_TBL

UPDATE 4/17/2013:

Another customer with a slightly different scenario has also encountered the issue.  In their scenario they have multiple paygroups that use the same pay period begin and end dates, and run all the paygroups in one payrun id.  In their case if the employee has prior period adjustments; transfers to a new paygroup mid period, the TL Installation settings say to load prior period time to current, the prior period time will be loaded to both paysheets due to set processing logic.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms