ETL9.2:TL_CALL_VAL: AppEngine Error. (2,653) ORA-00060 on TimeSheet (Doc ID 1943377.1)

Last updated on JUNE 15, 2016

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

Error submitting time on Time sheet. It is sporadic and mostly happens when multiple users are entering time at the same time.

REPLICATION STEPS

1) Navigate to timesheet and enter time.
2) Submit timesheet it and below error is encountered.

Error: CallAppEngine: Application TL_CALL_VAL: AppEngine error. (2,653) FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula  Name:RunValidation  PCPC:6951  Statement:61 Called from:TL_MSS_EE_SRCH_PRD.GBL.SavePostChange  Statement:4

Error. Stmt #: 1623  Error Position: 0  Return: 60 - ORA-00060: deadlock detected while waiting for resource

Failed SQL stmt: UPDATE PS_WRK_ADHOC_TAO2 SET SCHED_HRS = ( SELECT S.SCHED_HRS FROM PS_WRK_SHIFT_TAO2 S WHERE S.PROCESS_INSTANCE = PS_WRK_ADHOC_TAO2.PROCESS_INSTANCE AND S.EMPLID = PS_WRK_ADHOC_TAO2.EMPLID AND S.EMPL_RCD = PS_WRK_ADHOC_TAO2.EMPL_RCD AND S.DUR = PS_WRK_ADHOC_TAO2.DUR AND S.SHIFTNUM = PS_WRK_ADHOC_TAO2.SEQ_NO) WHERE EXISTS ( SELECT 'X' FROM PS_WRK_SHIFT_TAO2 S1 WHERE S1.PROCESS_INSTANCE = PS_WRK_ADHOC_TAO2.PROCESS_INSTANCE AND S1.EMPLID = PS_WRK_ADHOC_TAO2.EMPLID AND S1.EMPL_RCD = PS_WRK_ADHOC_TAO2.EMPL_RCD AND S1.DUR = PS_WRK_ADHOC_TAO2.DUR AND S1.SHIFTNUM = PS_WRK_ADHOC_TAO2.SEQ_NO) AND PS_WRK_ADHOC_TAO2.PUNCH_TYPE='0' AND PS_WRK_ADHOC_TAO2.SHIFT_ID = ' '

PSAPPSRV.6333 (6359) [2014-09-02T09:18:46.437 CallAppEngine: Application TL_CALL_VAL: AppEngine error. (2,653) FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula  Name:RunValidation  PCPC:6951  Statement:61

Called from:TL_MSS_EE_SRCH_PRD.GBL.SavePostChange  Statement:4

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