SQL Error On Clicking Expand Icon Next To"Other Supplier" Under Item Description On Requisition (Doc ID 1997812.1)

Last updated on AUGUST 05, 2016

Applies to:

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

Symptoms


Users get a SQL error when clicking on the expand icon next "Other Supplier" under Item Description subpage in Requisition Component.


ERROR
-----------------------
SQL error. Function:  Rowset.Fill
  Error Position:  0
  Return:  8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'ITM_VNDR_PRIORITY'.
  Statement:  SELECT FILL.SETID,FILL.INV_ITEM_ID,FILL.VENDOR_SETID,FILL.VENDOR_ID,FILL.VNDR_LOC,FILL.VNDR_UOM,FILL.ITM_ID_VNDR,FILL.CURR_CD,FILL.PRICE_VNDR,FILL.CURRENCY_CD_VNDR,FILL.CONVERSION_RATE FROM PS_PV_ITM_VND_VW FILL  WHERE SETID = :1 AND INV_ITEM_ID = :2 AND (ITM_VNDR_PRIORITY = 1 OR VENDOR_ID IS NULL)
  Original Statement:  %SelectAll(:3 FILL) WHERE SETID = :1 AND INV_ITEM_ID = :2 AND (ITM_VNDR_PRIORITY = 1 OR VENDOR_ID IS NULL)  

 
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.


Fatal SQL error occurred. (2,125) PV_ITM_DESCR_WK.PV_EXPAND_SECT.FieldChange in ePro Requisition page


STEPS
-----------------------

 Remove  Role Action VIEW_ALL_SUPPLIERS from All the Roles > Create a requisition
 1: Enter Item ID on search bar on ePro Requisition Component and got the expected search results
 2: Click on item to see the Item description sub page
 3: Click on the "expand" icon next to Other Suppliers section and get the reported SQL error


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