My Oracle Support Banner

"Fatal Peoplecode SQL Error" and "Error while updating Response records with new Version key" Occurs When the user Atempts to Approve an Event With More than One Version (Doc ID 2804466.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

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

Symptoms

Fatal Peoplecode SQL Error Occurs when the user tries to Approve an Event with more than one version from Approval tile.

 

Steps to reproduce the issue:

1. Navigate : Sourcing > Create Events > Event Details
   - Create an Event
   - Enter Line Item
   - Invite Public Bidders
   - Click Post
   - Event Status : Pending Post Approval
2. Login as Approver
   - Select the Event
   - Click Approve
   - There are no errors
3. Login back to the source creator
   - Navigate : Sourcing > Maintain Events > Event Workbench
   - Select the Event
   - Create new version
   - Select Yes
   - Update Event Name
   - Click Post
   - Event Status : Pending Post Approval
4. Login as Approver again and go to Approver tile
   - Select the event
   - Click Approve
   - Receive  below Error

Error:

 






Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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