My Oracle Support Banner

Supplier Portal: Maintain Supplier Information > User Profiles Search errors - A SQL Error occurred. Please check your system log for details (Doc ID 2586648.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM eSupplier Connection - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Supplier Portal: Maintain Supplier Information > User Profiles search does not work

Steps to Reproduce the Issue
1) Log in to Supplier Portal
2) Navigate to Main Menu > Maintain Supplier Information > User Profiles
3) Click Search shows results as expected
4) Specify User ID in the Search field and click Search error


Error Message:
A SQL Error occurred. Please check your system log for details.

What works
Worked in PUM# 19, encountered this problem on PUM#30.
Clicking on Find Existing user without specifying the User ID works



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!


In this Document
Symptoms
Changes
Cause
Solution
References


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