ETL92: Error On TL_ABS_GENPT (Doc ID 2650616.1)

Last updated on APRIL 07, 2021

Applies to:

Symptoms

TL_ABS_GENPT process fails with following error:

Error:
File: e:\pt85608c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_TL_ABS_WRK4' with unique index 'PS_TL_ABS_WRK4'. The duplicate key value is (606133, 107234, 0, Jan 31 2020 12:00AM, 10196).
Failed SQL stmt: INSERT INTO PS_TL_ABS_WRK4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR, PIN_TAKE_NUM, SEQ_NBR, TL_QUANTITY, EXCL_HOLIDAYS, EXCL_NON_WORK, TL_EXCLUDE_HOL, HOLIDAY_SCHEDULE, BEGIN_DAY_IND, END_DAY_IND, BEGIN_DAY_HRS, BEGIN_DAY_HALF_IND, END_DAY_HRS, END_DAY_HALF_IND, ALL_DAYS_IND, OFFDAY_IND, TRC, COUNTRY, HOLIDAY_FLAG, PAY_SYSTEM_FLG, MAX_SEQ_NBR) SELECT A.PROCESS_INSTANCE, A.EMPLID, A.EMPL_RCD, TQ.DUR, A.PIN_TAKE_NUM, 0, A.DAY_COUNT_PAID, 'Y', 'Y', PW.TL_EXCLUDE_HOL, PW.HOLIDAY_SCHEDULE , ' ', ' ', 0, 'N', 0, 'N', 'N', ' ', ' ', PW.COUNTRY, 'N', PW.PAY_SYSTEM_FLG, 0 FROM PS_TL_ABS_RS_TAO4 A, PS_TL_PROF_LIST4 PL, PS_TL_PROF_WRK4 PW, PS_TL_TOTAL_QTY4 TQ WHERE PL.PROCESS_INSTANCE = 606133 AND PW.PROCESS_INSTANCE = 606133 AND TQ.PROCESS_INSTANCE = 606133 AND PW.PROCESS_INSTANCE = PL.PROCESS_INSTANCE AND TQ.PROCESS_INSTANCE = PL.PROCESS_INSTANCE AND A.EMPLID = PL.EMPLID AND A.EMPL_RCD = PL.EMPL_RCD AND A.EMPLID = TQ.EMPLID AND A.EMPL_RCD = TQ.EMPL_RCD AND A.EMPLID = PW.EMPLID AND A.EMPL_RCD = PW.EMPL_RCD AND A.ABSENCE_DATE BETWEEN PL.START_DT AND PL.END_DT AND TQ.DUR = A.ABSENCE_DATE AND TQ.DUR BETWEEN PL.START_DT AND PL.END_DT AND TQ.DUR BETWEEN PW.EFFDT AND PW.END_EFFDT

Process 606133 ABENDED at Step TL_ABS_RSLV.GA100.Step03 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 08.41.29 2020-03-17

Steps to Recreate:
1. Run TL_ABS_GENPT process

Changes

Cause

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