Creditnoteautomatch Batch Fails With an Error When There Are More Than 1000 Rows in IM_MATCH_DOC Table

(Doc ID 2271076.1)

Last updated on JUNE 04, 2017

Applies to:

Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.


Creditnoteautomatch batch fails with below error when there are more than 1000 credit notes to be matched.

Steps to Recreate:
1. Create more than 1000 credit note requests.
2. Create more than 1000 credit notes which are matching with the credit note requests.
3. Run creditnoteautomatch batch and notice the following error:
oracle.retail.apps.framework.jdbc.JdbcTemplate$TooManyRowsException: SQL query returned more than 1000 rows. Use ORJdbcTemplate.setResultSetMax(N) to increase the limit or set it to null to remove the limit. SQL Query : SELECT DISTINCT IMD.SUPPLIER, IMD.SUPPLIER_GROUP FROM IM_MATCH_DOC IMD WHERE IMD.PROCESS_ID = ?




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