ETL9.0 Time Admin Is Failing With A Unique Constraint Error On step TL_TA000700.ABSENCE.LOAD
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.
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.
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_IPT14) violated
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms