ETL9.1: Time Admin deletes payable time row from Reversal/Adjustment with the Generate option on in error.

(Doc ID 1497626.1)

Last updated on FEBRUARY 01, 2018

Applies to:

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


On : 9.1 version, NA Payroll Integration/TL Load

If Time Administration is run before newly created offsets from the Reversal/Adjustment with Generate option is loaded to payroll, Time Administration is eliminating the generated payable time rows causing incorrect payments.
1. Employee paid for 8 hours on 5/8 and check generated by payroll
2. Change reported time from 8 to 3 hours
3. Run Time admin results are:
+8 Reg in CL payable status
-8 REG in ES payable status
+3 Reg in ES payable status

4. Reverse and specify to regenerate the original check.
5. results after reversal confirmed:
+8 Reg in RV payable status...this is original payable time row that was CL is now set to RV
+3 Reg in ES payable status
-8 Reg in ES payable status
+8 Reg in ES payable status....this is new generated row from reversal
-8 Reg in RV payable status
net result if loaded to a new paysheet = +3 hrs Reg
However, the payable time was not yet loaded to a new payroll when Time Administration ran again due to some adjustment within the period (not necessarily for this day)

6. Results now after time admin runs:
+8 Reg in RV payable status
-8 Reg in ES payable status
-8 Reg in RV payable status
+3 Reg in ES payable status
net result is -5 Reg will be processed by payroll and employee underpaid

Expect Time Admin to ignore the rows created by the reversal/generate process if they are still in ES status ready to load.

The issue can be reproduced at will with the following steps:
1. Report time for 2 days in period
2. Run Time Admin to create payable time
3. Run TL Load to load time to paysheets
4. Calc and confirm the payroll
5. Make a change in hours to one of the days paid.
6. Run Time Admin which generates the correct offset and new ES row reflecting the change.
7. Do a reversal/adjustment with generate option turn on and confirm reversal
8. At this point the payable time if loaded to paysheets would be correct
9. Report time for another day in the period
10. Run Time Admin which eliminates the generated ES row in error

The issue has the following business impact:
Due to this issue, users cannot employee will be underpaid if processed through to payroll like this.


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