ETL9.0 Time Admin Is Failing With A Unique Constraint Error On step TL_TA000700.ABSENCE.LOAD (Doc ID 1098645.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms


Time Admin is failing with a unique constraint error on Step TL_TA000700.ABSENCE.LOAD

Employee had two records in PS_TL_ABS_WRK4 for a given day with different TRC. Two records also existed in PS_TL_RESEQ2_WRK4 for that day/employee. Each record had seq_nbr. A join is reqired on seq_nbr field on the above step.

ERROR
-----------------------
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_IPT14) violated
Step TL_TA000700.ABSENCE.LOAD


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Report multiple absences, including half day absences, full day absences, cancel some previously paid absences and void other ones
2. Run Time Admin
3. It fails with a unique constraint error on Step TL_TA000700.ABSENCE.LOAD

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