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 SEPTEMBER 04, 2024
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 |