ETL9.1: TL_QUANTITY on TL_COMPLEAV_TBL Applied to Incorrect Effective Dated Row (Doc ID 1268052.1)

Last updated on APRIL 28, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
****checked for currency 26-SEP-14****

Symptoms

Issue #1.
TL_QUANTITY on TL_COMPLEAV_TBL not updating Max DUR row and not showing balance from Max row on timesheet.
When the leave accrual runs and tries to reset these balances, it will not be able to because it only updates the max row by offsetting TL_QUANTITY with the taken unprocessed hours on LEAVE_ACCRUAL table. Also, the employee is not shown a real time accurate balance. This is occurring with all employees.

Issue #2:
TL_QUANTITY on TL_COMPLEAV_TBL subtracts double hours when removed from timesheet if EE has a leave plan change in Leave Plan Table. This seems to only occur for employees with leave plan changes.

Changes

N/A

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