Sourcing Bidders From Release 9.1 Who Have List Profile Question Are Getting SQL Error In PUM #24
Last updated on FEBRUARY 16, 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, Other Setup
Sourcing Maintain Bidder is receiving SQL error when trying to pull up bidder
Receiving a fatal PeopleCode SQL error when trying to pull up a bidder under Maintain Bidder for Question Type 'List'. We've just applied PUM 24 to our test environment. During our smoke testing we discovered that new PUM 24 code in AUC_BIDDER.GBL.AUG_REG_BF_RESP.RowInit Component PeopleCode is where the SQL error is coming from. Please see attachment for a breakdown of our replication steps and research analysis.
A Fatal PeopleCode SQL error occurred. Please consult your system log for details.
The issue can be reproduced at will with the following steps:
1-I updated the bidder registration template profile question tab with a required question of List type.
2- Registered a new Bidder and answered the list question and submitted it for approval
3- Approved the newly registered bidder.
4- Navigated to maintain bidders and I was able to pull the bidder.
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