SQL Error in Vendor Search with Apostrophe in Short Vendor Name (Doc ID 1969256.1)

Last updated on JUNE 09, 2017

Applies to:

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

Symptoms

System throws a SQL error in Vendor Search with apostrophe in short vendor name while creating a requisition


ERROR
-----------------------

The following error is displayed:
"SQL error in Exec. (2,280) VNDR_PANELS_WRK.FETCH_VENDORS.FieldFormula Name:retrieve_items PCPC:7207 Statement:138
Called from:VNDR_PANELS_WRK.FIRST_ITEM_BUTTON.FieldChange Name:get_first_chunk Statement:9
Called from:VNDR_PANELS_WRK.FIRST_ITEM_BUTTON.FieldChange Statement:25


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Lets take a Vendor with Apostrophe in Vendor Shortname.

2. Navigate to eProcurement > Create Requisition > Define Requisition tab

3. When entering Vendor, click on "Vendor Lookup" magnifying glass icon

4. On "Vendor Search" screen enter "ERNIE'S-001" in Short Vendor Name, then Find



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