SQL Error When Looking For Other Suppliers Of An Eprocurement Requisition Item
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
Million Knowledge Articles and hundreds of Community platforms