EAP: SQL Syntax Error While Submitting Payment Request for Approval - Called from:PR_WRK.SUBMIT_PB.FieldChange

(Doc ID 2086742.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Submitting Payment Request for approval in database other than Oracle, triggers SQL errors.


Replication:

1. Create new Payment Request in database other than Oracle.
2. Click Submit

Following error message is displayed:

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

SQL error in Exec. (2,280) EOAW_CORE.NotificationEventHandler.OnExecute  Name:updateSummaryDetails  PCPC:224423  Statement:2513
Called from:EOAW_CORE.NotificationEventHandler.OnExecute  Name:ProcessNotifications  Statement:1421
Called from:EOAW_CORE.ENGINE.AppInst.OnExecute  Name:Launch  Statement:21
Called from:EOAW_CORE.LaunchManager.OnExecute  Name:DoSubmit  Statement:33
Called from:AP_PR.WizardHandler.ProcessEventHandler.OnExecute  Name:SaveRequest  Statement:364
Called from:PR_WRK.SUBMIT_PB.FieldChange  Statement:166

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

 

Note: In some cases above error messages were not displayed. But reviewing the trace file shows following:

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 (361) 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'))

 Original 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 = :1 and  dtl.eoawthread_id in (361) 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 = :1 and  s.eoawthread_id = dtl.eoawthread_id and u.oprid = dtl.eoawapprover_oprid and s.eoawstep_status <> 'B'))
PSAPPSRV.3636 (6854) 1-478922 08.24.08    0.000000 ErrorReturn-> 280 - SQL error in Exec. (2,280) EOAW_CORE.NotificationEventHandler.OnExecute  Name:updateSummaryDetails  PCPC:224423  Statement:2513

Called from:EOAW_CORE.NotificationEventHandler.OnExecute  Name:ProcessNotifications  Statement:1421

Called from:EOAW_CORE.ENGINE.AppInst.OnExecute  Name:Launch  Statement:21

Called from:EOAW_CORE.LaunchManager.OnExecute  Name:DoSubmit  Statement:33

Called from:AP_PR.WizardHandler.ProcessEventHandler.OnExecute  Name:SaveRequest  Statement:364

Called from:PR_WRK.SUBMIT_PB.FieldChange  Statement:166

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