EBI9.2: Preview Approval Error When an Approver Reviews a Bill (Doc ID 2110124.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 9.2 version, Billing Workflow 9.2 DEMO Image 15

ERROR
-----------------------
Invalid SQLExec update for this type of PeopleCode program. (2,146) EOAW_CORE.NotificationEventHandler.OnExecute Name:updateSummaryDetails PCPC:232359 Statement:2508
Called from:EOAW_CORE.NotificationEventHandler.OnExecute Name:ProcessNotifications Statement:1424
Called from:EOAW_CORE.ENGINE.PathInst.OnExecute Name:InsertAdhocAfter Statement:408
Called from:EOAW_CORE.ENGINE.DefPathInst.OnExecute Name:AddAdminOnError Statement:87
Called from:EOAW_CORE.ENGINE.AuthPathInst.OnExecute Name:InstantiateSteps Statement:107
Called from:EOAW_CORE.ENGINE.DefPathInst.On

SQL Exec Commands with Update, Insert, or Delete statements are only allowed in SavePreChange,SavePostChange and Workflow type peoplecode programs.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login as VP2 (Approver) and select any Invoice pending approval (If there is none, create a new invoice and submit for approval)
2.Click on Approvals link
3.Provide comments and Deny the Invoice
4.Pop up message
5.Click on Approvals on the Main page again and then click on Preview Approvals. Will get the error.

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