My Oracle Support Banner

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

Last updated on APRIL 07, 2019

Applies to:

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


On : 9.2 version, Billing Workflow 9.2 DEMO Image 15

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.

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.


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

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