System Throws Error -"Receiving SQL error when Post award button is clicked.SQL error in Exec. (2,280)" When Posting Sourcing Event Award.
(Doc ID 3046864.1)
Last updated on SEPTEMBER 11, 2024
Applies to:
PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Below Error Message shows up when users try to post sourcing event award.
SQL error in Exec. (2,280) AUC_AWARD.BIDDER.BidderInfo.OnExecute Name:UpdateBidderInfo PCPC:29871 Statement:252
Called from:AUC_AWARD.PostAward.OnExecute Name:UpdateBidderInfo Statement:559
Called from:AUC_AWARD_CMP.GBL.AUC_AWARD_SCROL.SavePostChange Statement:8
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
This issue can be reproduced at will with the following steps:
1. To test this issue consider a bidder and supplier with some common set of category cd's in ps_auc_bid_slf_cat.
2. Create a sourcing event, invite the bidder and post. Navigation : Sourcing > Create Events > Create Event Details.
3. Log in as bidder and submit bids. Navigation : Sourcing > Event Responses > Create Bidder Response.
4. Analyze the events and select a bidder to award the event. Navigation : Sourcing > Maintain Events > Analyze Events.
5. Select a supplier and Post award. Navigation : Sourcing > Maintain Events > Award Events.
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 |
| Cause |
| Solution |
| References |