SQL Error When Looking For Other Suppliers Of An Eprocurement Requisition Item

(Doc ID 1989000.1)

Last updated on APRIL 10, 2016

Applies to:

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


When adding an item that was found through search in eProcurement > Requisition and when the Other Suppliers expand icon is clicked, a SQL error is returned.

Steps to reproduce the issue:

1) Remove Role Action VIEW_ALL_SUPPLIERS from All the Roles

2) Create a Requisition

3) Click on Item Description and it will take you to Item description page

4) Try to expand Other Suppliers, below error is triggered


Fatal SQL error occurred. (2,125) PV_ITM_DESCR_WK.PV_EXPAND_SECT.FieldChange Name:OtherVndr PCPC:3643 Statement:33
Called from:PV_ITM_DESCR_WK.PV_EXPAND_SECT.FieldChange Statement:92

A SQL error has occurred, review the SQL to determine the cause of the error.

Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.


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