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.

Symptoms

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

Error:

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.



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