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.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms