Received Fatal Error Message when Trying to Navigate 'Approvals and Alerts' Tab in Service WorkOrder

(Doc ID 2158386.1)

Last updated on JULY 06, 2016

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Received Fatal Error Message when Trying to Navigate 'Approvals and Alerts' Tab in Service WorkOrder

Steps to Reproduce the Issue  
1. Create a Service Workorder
2. Provide all the required information
3. Click on Save
4. go to Approval and Alert Tab
5. You will get fatal PeopleCode Error if User list doesn't have any approvers.


Errors:
146 - Invalid SQLExec update for this type of PeopleCode program. (2,146) EOAW_CORE.NotificationEventHandler.OnExecute  Name:updateSummaryDetails  PCPC:224423  Statement:2513
Called from:EOAW_CORE.NotificationEventHandler.OnExecute  Name:ProcessNotifications  Statement:1421
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.DefPathInst.OnExecute  Name:InstantiateSteps  Statement:74
Called from:EOAW_CORE.ENGINE.DefPathInst.OnEx

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