My Oracle Support Banner

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

Last updated on JANUARY 04, 2021

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 in Short Vendor Name, then Find



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.