My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

Applies to:

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


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)

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


"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é."




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

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