SQL Error In Exec. (2,280) PV_PROCURE_REQ.GBL.REQ_VAL_ADJ_P.SavePostChange PCPC:407

(Doc ID 2216122.1)

Last updated on DECEMBER 20, 2016

Applies to:

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


We're encountering a SQL error when two different users press the "save and submit" button at the same time on the Requisition checkout - review and submit page. When we comment out the 'DELETE' statement in SavePostChange peoplecode event on record/view REQ_VAL_ADJ_P, we do not receive an errors. It appears when two different users are attempting to execute the 'DELETE' statement roughly the same time, the first user processes while the second fails.

SQL error in Exec. (2,280) PV_PROCURE_REQ.GBL.REQ_VAL_ADJ_P.SavePostChange PCPC:407 Statement:1

Steps to reproduce the Issue:-
The issue can be reproduced at will with the following steps:
1. Login with VP1.Create a Special Request Requisition.Add To Cart and Checkout
2. Login with VP2.Create a Special Request Requisition.Add To Cart and Checkout
3. Now Submit the Requisition.Both Users should submit the requisition at same time.
4.One User ends with the Error


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