SQL Error On View Events And Place Bids Page on Supplier Portal

(Doc ID 2146334.1)

Last updated on AUGUST 22, 2017

Applies to:

PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



In the SUPPLIER portal, when trying to search for events on View Events and Place Bids page, a SQL error occurred which doesn't allow us to proceed further with the search. The issue is occurring mainly when a bidder having multiple contacts is assigned to an event and selected more than one contact for the bidder. By keeping only one contact for the bidder during the event creation, the search results are showed.

Steps to reproduce the issue:
1. Navigate to Suppliers > Supplier Information > Add/Update > Supplier and check a supplier who have multiple contact information. In the below example, we have 6 contacts for this supplier.
2. Navigate to PeopleTools > Security > User Profiles > User Profiles and open the current user profile and make sure the above supplier ID is attached.
3. Create a new Event.
4. Search for bidders and add bidder who have multiple contacts as shown in first and second screen prints,Click Details and add multiple contacts.
5. Login to SUPPLIER portal and navigate to Manage Events and Place Bids > View Events and Place Bids,Check that a SQL error displays.




Cause

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