My Oracle Support Banner

ETL8.9/9.x: ISSUES WITH TIME ADMINISTRATION PARALLEL PROCESSING (Doc ID 984872.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms


Comments
--------
In time and labor version 9.0 production environment, when the time administration processes are run in parallel the following issues occur...
Actual behavior:
---------------------
Symptom 1: Exception based unique constrain errors.
Symptom 2: Duplicate payable time entries
Symptom 3: No offsets for duplicate entries when reprocessed time administration.
Symptom 4: Deadlock on attendance tracking tables.

EXPECTED BEHAVIOR
-----------------------
When the time administration processes are running in parallel :
1) the process should not generate duplicate entries? in exception table for same exception on same day for same employee - this behavior causes unique constraint errors and time administration process abends.
2) Duplicate payable time is generated for the time reported causing in over payment to employees, duplicate should not be generated for any reported time.
3) When reprocessed the employees by changing the earliest changed date to the period begin date and rerunning time administration it should recognize the duplicates in payable time and create offsets to correct the payable time
4) During the parallel processing the dead locks should not occur on the attendance tracking tables.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Having run two or more time administration processes at the same time.
2. observe the above mentioned criteria for the results.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, causes discrepancies in calculating and paying the employees.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.