Forms And Approval Builder - Preview Approval Button Throwing A PeopleCode Error Message

(Doc ID 2412206.1)

Last updated on JUNE 18, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

When attempting to save an online form users get peoplecode error.

Forms convert manual procedures to paperless processes that include workflow-based approvals



ERROR
-----------------------
2 errors received received

1. Preview Approval button error message:

Error Message: Think-time PeopleCode event (EvalDoModalPopup), but a SQL update has occurred in the commit interval.
EOFM_FL.Controller.FormController.OnExecute Name:FormApprWrk_PreviewPB_FieldChange PCPC:18583 Statement:329
Called from:EOFM_FORM_FL.GBL.FORM_APPR_WK.EOAW_PREVIEW.FieldChange Statement:1
Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in
the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked
A unit of work cannot contain both think-time events and update type SQL.

2. Field does not exist -- EOAW_MON_WRK.HTMLAREA.
EOFM_FL.Controller.FormController.OnExecute Name:FormApprMap_PageActivate PCPC:22889 Statement:389
Called from:EOFM_FM_MON_SCF.Activate Statement:4
A reference to a record.field name was made and the record.field name was not found to exist. Verify that the field exists on the page in which the
PeopleCode program is being executed.
Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.


STEPS
-----------------------
Preview Approval button error message:
The issue can be reproduced at will with the following steps:
Step 1: Click on My Forms tile:
Step 2: Click on Fill out a new Form:
Step 4: Click on Save, to save form data
Step 5: Click on Preview Approval button



BUSINESS IMPACT
-----------------------


The issue has the following business impact:
Users are not able to view approval chain before submit of form. 10000+ users affected as form is assigned to each employee. Users are not able to view approval and may not submit the forms and they will not be able to submnit the payroll forms which needed to pay employees correctly.

Changes

 

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