Award For Bidder Gives Peoplecode Error When Event Awarded To A Supplier Already On Invitation List
Last updated on MAY 15, 2018
Applies to:PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, PUM 24, PT 8.55.15.,Award Events
Getting error message when Creating a new event with bidder and supplier with location as MAIN, then awarding the event to the supplier:"A fatal PeopleCode SQL Error occurred. Please consult your system log for details. "
A fatal PeopleCode SQL Error occurred. Please consult your system log for details.
Peoplecode Error - SQL error in Exec. (2,280) AUC_AWARD.BIDDER.BidderInfo.OnExecute Name:UpdateBidderInfo PCPC:20951 statement 211
Log file statements -
Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_AUC_DISP_ADDR' with unique index 'PS_AUC_DISP_ADDR'. The duplicate key value is (SC001, 0000000596, 1, 2, SHARE, 0000001988, V, MAIN, 1, 1).
Statement: UPDATE PS_AUC_DISP_ADDR SET BIDDER_SETID = :1, BIDDER_ID = :2, BIDDER_TYPE = :3, BIDDER_LOC = 'MAIN' WHERE BIDDER_ID = :4 AND BIDDER_SETID = :5 AND BIDDER_TYPE = :6 AND BIDDER_LOC = :7
Original Statement: update ps_auc_disp_addr set bidder_setid = :1, bidder_id = :2, bidder_type = :3, bidder_loc = 'MAIN' where bidder_id = :4 and bidder_setid = :5 and bidder_type = :6 and bidder_loc = :7
PSAPPSRV.6700 (167) 1-2 08.00.47 71.529000 SQL error. Function: SQLExec
The issue can be reproduced at will with the following steps:
1. Create a Public event and invite a supplier with location MAIN and any bidder.
2. Complete the event and go to award events page
3. Assign a PO Business unit and the supplier ID of the same supplier that was initially invited to the event with location MAIN
4. Try to post award to get the error listed below.
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