My Oracle Support Banner

ETL9.2: TL_TR0012900.PARTABS.STEP01 Abend Due To Unique Constraint Violation with Exception TLX01710 . (Doc ID 2751922.1)

Last updated on MARCH 24, 2021

Applies to:

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

Symptoms

Whenever an employee is applying for a half day leave and also has a timesheet entry (IN/OUT Punch), the Time Admin process is failing with the below error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_EXCEPT_WRK5) violated
Failed SQL stmt: INSERT INTO PS_TL_EXCEPT_WRK5 (PROCESS_INSTANCE , VALID_INST_ID , UPDATE_FLAG , EXCEPTION_ID , EMPLID , EMPL_RCD , DUR , SEQ_NBR , EXCEPTION_SOURCE , SEVERITY , RUN_CNTL_ID , EXCEPTION_STATUS , RESOLVED_BY , ACTION_DTTM , START_DT , END_DT , ALLOW_IND , MSG_DATA1 , MSG_DATA2 , MSG_DATA3 , MSG_DATA4 , MSG_DATA5) SELECT 932625 , 1 , 'N' , 'TLX01710' , TQ.EMPLID , TQ.EMPL_RCD , TQ.DUR , 1 , 'SCH' , ' ' , '1234' , 'U' , ' ' , CAST(SYSTIMESTAMP AS TIMESTAMP) , TO_DATE('1900-01-01','YYYY-MM-DD') , TO_DATE('1900-01-01','YYYY-MM-DD') , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_TL_PROF_LIST10 PL , PS_TL_TOTAL_QTY10 TQ , PS_TL_PROF_WRK10 PW WHERE TQ.PROCESS_INSTANCE = 932625 AND PL.PROCESS_INSTANCE = TQ.PROCESS_INSTANCE AND PW.PROCESS_INSTANCE = TQ.PROCESS_INSTANCE AND TQ.EMPLID=PL.EMPLID AND TQ.EMPL_RCD=PL.EMPL_RCD AND TQ.DUR BETWEEN PL.START_DT AND PL.END_DT AND TQ.TL_ABSENCE_QTY > 0 AND TQ.TL_ABSENCE_QTY < TQ.SCHEDULED_QTY AND TQ.PUNCH_TYPE <> '0' AND TQ.EMPLID = PW.EMPLID AND TQ.EMPL_RCD = PW.EMPL_RCD AND TQ.DUR BETWEEN PW.EFFDT AND PW.END_EFFDT
2021-02-10-12.48.19.245802 GetNextStateRecord [68] Exception logged: RC=3.
2021-02-10-12.48.19.245802 ExecuteSql [1360] Exception logged: RC=8.
2021-02-10-12.48.19.245807 ExecuteSql [1479] Exception logged: RC=8.
2021-02-10-12.48.19.245807 DoSqlAction [2882] Exception logged: RC=8.
2021-02-10-12.48.19.245807 DoSqlAction [2931] Exception logged: RC=8.
2021-02-10-12.48.19.245807 DoStepActions [2143] Exception logged: RC=8.

Prozess 932625 wurde in Schritt TL_TR0012900.PARTABS.Step01 (SQL) abgebrochen -- RC = 805. (108,524)

STEPS
-----------------------
.
1. Integrate Absence and T&A, so that leave appears in the timesheet
2. Apply half day Leave for a given date
3. Select a Punch Time reporter employee and enter PUNCH IN/OUT time for the same date where leave was applied.
4. Run the TL_TIMEADMIN process

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.