EAP: Fatal PeopleCode SQL Error When Adding Voucher on SQL Server Database (Doc ID 1988074.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

When logged in using French language, a Fatal PeopleCode SQL error occurred when prompting on these 3 fields on adding a new voucher page:

- Supplier Name (VCHR_ADDSRCH_VW.NAME1.FieldChange)
- Short Supplier Name (VCHR_ADDSRCH_VW.VENDOR_NAME_SHORT.FieldChange)
- Supplier ID (VCHR_ADDSRCH_VW.VENDOR_ID.FieldChange)

STEPS
1. Login in French
2. Navigate to Accounts Payables > Voucher > Add/Update > Regular Entry, and add a New Value
3. Open the lookup for Supplier Name, Short Supplier , or Supplier ID
4. Select a supplier

ERRORS

"A fatal PeopleCode SQL error occurred. Please consult your system log for details."


"Erreur SQL dans Exec. (2,280) VCHR_ADDSRCH_VW.NAME1.FieldChange  PCPC:295  Statement:3
Une erreur est survenue dans la sous-routine Exec pendant l'exécution SQL. Le message précédent vous a indiqué le détail du SQL exécuté."


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