ETL9.1 TL LOAD Filters Rejects The Payable Time, When There is Job Data Changes. (Doc ID 1571327.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

ISSUE STATEMENT
===============

TL LOAD filters rejects the payable time.

Time and Labor load to on cycle payroll using filters is rejecting all of the payable time for any employees who had (additional payments (job changes) added in error. The time should have been reloaded upon the refresh for the job change and wasn't. A 5019 message was also given informing me that an employee was terminated and his time that had previously been loaded (time
for dates prior to termination) was rejected in error. No message provided for this employee. No message provided for all the other employees that had time rejected after job change.

REPLICATION STEPS
=================
- Auto Paysheet Update is "turned on"
- Load in Preliminary Calc is "turned off"

1. Enroll all active employees in paygroup GBI/KL8 (monthly) to Time and Labor as of 6/1/2013
2. Create new dynamic group for the workgroup
3. Refresh dynamic group and add to permission list
4. Create new pay run id and add it to pay calendar
5. Terminate KUL904 as of 6/27/2013, Terminate KUL911 as of 6/25/2013
6. Report time for KUOVT for all employees between 6/1 and 6/20/2013
7. Create paysheets and verify they exist for all the employees
8. Run preliminary calc and verify no messages
9. Run time admin thru 6/30/2013 for dynamic group
10. Verify payable time created
11. Approve payable time
12. Run TL Load for payrun id on cycle calendar ppe 6/30 without using any filters
13. verify payable time is all loaded to paysheets as expected and no time rejected
14. Add additional payments for KUL904, KUL905, KUL906, KUL912, KUL913 &
KUL917
15. Make changes to reported time for KUL911
16. Run time admin again and verify appropriate offsets created
17. Run load to payroll using filters set to Employee id KUL911, paygroup GBI/KL8, date range 6/1 thru 6/30 and earnings code OTP (this is how customer
does subsequent loads after changes)
18. Log file displays 6 employees checked for updates and also to check messages
19. Message given for employee KUL904 error #5019 stating employee is terminated and to create paysheet or use adjust paid time (paysheet was already created and time previously loaded prior to term date is now rejected in error)
20. All the employees with additional payments added now have rejected time and no other error messages provided, the paysheets were refreshed and now include the additional payments that were added

ENVIRONMENT INFORMATION
=======================
PeopleSoft HCM 9.1 Bundle 12

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.