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 04, 2019

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'.  In 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.


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

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