EBI9.2: Preview Approval Error When an Approver Reviews a Bill
(Doc ID 2110124.1)
Last updated on MARCH 09, 2017
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!