Posting Batch Aborts With an Error "sql query returned more than 1000 rows"
(Doc ID 2546995.1)
Last updated on JULY 15, 2020
Applies to:Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.
Posting batch aborts with following error:
Steps to Recreate:
- Run Posting batch with more than 1000 matched invoices.
- Check server log file, ReIMPosting is aborting with an error StuckThreadMaxTime or “oracle.retail.apps.framework.jdbc.JdbcTemplate$TooManyRowsException:SQLquery returned more than 1000”.
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