EAP: SQL error at VENDOR.VENDOR_ID.RowInit when trying to display Vendor in another language

(Doc ID 1394175.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version: 9.1 to 9.1 - Release: 9 to 9
Information in this document applies to any platform.

Symptoms

When trying to display a Vendor on the Vendor > Find An Existing Value page, an error occurs if logged into the system under a different language.

ERROR
SQL error in DescribeCol.(2,279) VENDOR.VENDOR_ID.RowInit PCPC:2671 Statement:26

STEPS
1. On the Log in screen, select the Spanish language
2. Sign into the system
3. Navigate to Set Up Financials/Supply Chain > Product Related > Procurement Options > Vendors > Set Controls - Vendor
4.  Under Vendor Name History, verify that the box for "Vendor Name History" is checked
5.  Navigate to Vendors > Vendor Information > Add/Update > Vendor
6.  On the Find An Existing Value page, search for any Vendor
7.  Try to display the Vendor
8.  Above error will occur

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