R12 - MAX ROWS EXCEEDED - PPR Does Not Accept Over 500 Payments (Doc ID 1146844.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Goal

After creating payment process request, then ordering the payments by the payee column error message is received.

ERROR:
=======
Query is over 500 rows. Potentially there are more rows, please reduce your query.

Error captured on FND debug log
--------------------------------------------
Exception: Query has exceeded 500 rows. Potentially more rows exists, please restrict your query.


Solution

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