ETL9.2: Submit Timesheet Error: "A fatal PeopleCode SQL error occurred. Please consult your system log for details" (Doc ID 2086475.1)

Last updated on DECEMBER 08, 2015

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


While testing PUM 14, when trying to submit timesheet, the following error occurs:


ERROR

'A fatal PeopleCode SQL error occurred. Please consult your system log for details '

The log shows following error


  Error Position: 0

  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'DTL'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could n

  Statement: UPDATE PS_EOAW_SUMM_DTL DTL SET DTL.EOAWUSTEP_STATUS = (SELECT USTEP.EOAWSTEP_STATUS FROM PS_EOAW_STEP_VW USTEP WHERE USTEP.EOAWUSTEP_INST_ID = (SELECT MAX(U.EOAWUSTEP_INST_ID) FROM PS_EOAW_STEPINST S, PS_EOAW_USERINST U WHERE S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND S.EOAWPRCS_ID = :1 AND S.EOAWTHREAD_ID = DTL.EOAWTHREAD_ID AND U.OPRID = DTL.EOAWAPPROVER_OPRID AND S.EOAWSTEP_STATUS <> 'B')) WHERE DTL.EOAWPRCS_ID = :2 AND DTL.EOAWTHREAD_ID IN (738733,738734,738735) AND DTL.EOAWAPPROVER_OPRID IN (SELECT USTEP.OPRID FROM PS_EOAW_STEP_VW USTEP WHERE USTEP.EOAWUSTEP_INST_ID = (SELECT MAX(U.EOAWUSTEP_INST_ID) FROM PS_EOAW_STEPINST S, PS_EOAW_USERINST U WHERE S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND S.EOAWPRCS_ID = :3 AND S.EOAWTHREAD_ID = DTL.EOAWTHREAD_ID AND U.OPRID = DTL.EOAWAPPROVER_OPRID AND S.EOAWSTEP_STATUS <> 'B'))


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