My Oracle Support Banner

Fatal PeopleCode SQL Error Message (SQL error in Exec. (2,280) EOAW_CRITERIA.DEFINITION.CriteriaRec.OnExecute Name:evaluateSQL) when Saving a Form using Approval Workflow (Doc ID 1528211.1)

Last updated on JUNE 12, 2018

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
Information in this document applies to any platform.

Goal

Receiving error message when using the workflow and then submitting a form.

Error:

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

SQL error in Exec. (2,280) EOAW_CRITERIA.DEFINITION.CriteriaRec.OnExecute  Name:evaluateSQL  PCPC:13559  Statement:285
Called from:EOAW_CRITERIA.DEFINITION.CriteriaRec.OnExecute  Name:checkwithbinds  Statement:182
Called from:EOAW_CRITERIA.DEFINITION.CriteriaEntered.OnExecute  Name:CheckwithBinds  Statement:64
Called from:EOAW_CORE.ENGINE.DefPathInst.OnExecute  Name:InstantiateSteps  Statement:41
Called from:EOAW_CORE.ENGINE.DefPathInst.OnExecute  Name:Instantiate  Statement:27
Called from:EOAW_CORE.EN

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



Steps to reproduce the issue:

1) Create a Generic Approval framework in Approval Process Definition

2) User is mapped to Form Admin, Form user and Form Designer

3) Take an Existing Form say Department - Check the Approver User List Enterprise component -Forms - Design a Form

4) Reactivate the Form to test the Workflow - Click on Activate the Form

5) Test the Form - Enterprise Components - Forms-Search/Fill a Form - Add a New Value

6) Fill the details - Click on Save - Click on Submit. A fatal PeopleCode SQL error occurres

7) Click on OK and error message appears

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.