My Oracle Support Banner

EAP: Fatal Peopelcode SQL Errror On The Voucher Inquiry Page When an Account or Dept are Included in The Search (Doc ID 2552481.1)

Last updated on OCTOBER 18, 2021

Applies to:

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

Symptoms

On the Voucher Inquiry page, when an Account or Dept are included in the Search, once the Payment information is viewed, the URL link back to the search gives a SQL error.

ERROR
A fatal Peopelcode SQL errror occurred. Please consult your system log for details.

Invalid SQLExec update for this type of PeopleCode program. (2,146) AP_VCHR_INQ_VW.BUSINESS_UNIT.FieldFormula Name:SearchExeStatement PCPC:43287 Statement:649
Called from:AP_VCHR_INQ.GBL.PostBuild Statement:71

SQLExec commands with UPDATE, INSERT, or DELETE statements are only allowed in SavePreChange, SavePostChange, and Workflow type PeopleCode programs.

STEPS
1. Navigate to: Accounts Payable > Review Accounts Payable Info > Vouchers > Voucher From and To BU defaults to US001 and SetID of SHARE
2. Enter Account 650000 and click Search
3. Find a Voucher with Payment Information in the Actions dropdown (Voucher ID 00000066) and click it
4. Click “Back to Voucher Inquiry”
5. SQL error is generated

Changes

 

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
Changes
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.