My Oracle Support Banner

Sourcing Bidders From Release 9.1 Who Have List Profile Question Are Getting SQL Error In PUM #24 (Doc ID 2339060.1)

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.

Symptoms

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.

ERROR
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.



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!


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