My Oracle Support Banner

EAP: ERROR ON AP SEARCH PAGE AFTER APPLYING BUG FIX BUG 29631604 (Doc ID 2598668.1)

Last updated on OCTOBER 18, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
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:

ErrorReturn-> 178 - Invalid message while SQL transaction in process: The current criteria will return 381 rows. This exceeds the max rows specified of 300. Continue? (7015,402) (2,178) AP_VCHR_INQ_VW.BUSINESS_UNIT.FieldFormula Name:SearchExeStatement PCPC:46815 Statement:681
Called from:AP_VCHR_INQ.GBL.AP_VCHR_INQ_WRK.SEARCH_BUTTON.FieldChange Statement:228

STEPS:

The issue can be reproduced at will with the following 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 Dept and click Search
3. 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.