ETL9.2: ORA-00060 Deadlocks Occuring During Time Admin Processing
Last updated on FEBRUARY 28, 2018
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Having deadlock issues when multiple threads of Time Admin are processing concurrently.
These are deadlock issues
Of the 16 threads, 8 have finished successfully and 8 have abended.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 7 Return: 60 - ORA-00060: deadlock detected while waiting for resource
Failed SQL stmt: UPDATE PS_TL_TR_STATUS SET PROCESS_INSTANCE = 3631779 WHERE PROCESS_INSTANCE NOT IN ( SELECT PRCSINSTANCE FROM PSPRCSRQST WHERE RUNSTATUS IN ('3','4','7','10')) AND PROCESS_INSTANCE NOT IN ( SELECT E.PROCESS_INSTANCE FROM PS_TL_EMPL_DATA E WHERE E.EMPLID=PS_TL_TR_STATUS.EMPLID AND E.EMPL_RCD = PS_TL_TR_STATUS.EMPL_RCD) AND EXISTS ( SELECT 1 FROM PS_TL_TA_TRLIST14 TL WHERE TL.EMPLID = PS_TL_TR_STATUS.EMPLID AND TL.EMPL_RCD = PS_TL_TR_STATUS.EMPL_RCD)
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