ETL9.2: Timesheet Error 'A SQL error occurred. Please consult your system log for details." CallAppEngine TL_CALL_VAL:AppEngine Error(2,653) (Doc ID 1645003.1)

Last updated on FEBRUARY 24, 2017

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

For the Employee MRT0023 while submitting the time sheet  "A SQL error occurred. Please consult your system log for details." is popped up, after submitting the timesheet.
 
  
To Replicate:
1) Navigate to Timesheet
2) Open timesheet
3) It give Error :MESSAGE:-Msg: | A SQL error occurred. Please consult your system log for details.
Process 100000824 ABENDED at Step TL_TR0012904.PRIORYR.Step02 (SQL) -- RC = 8603 (108,524)


ERROR
-----------
CallAppEngine 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

PeopleSoft HCM 9.2
PUM 3
PeopleTools 8.53

Due to this issue they are unable to complete PUM 3 upgrade.

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