Posting Batch Aborts With 'Maximum Open Cursors Exceeded' Error

(Doc ID 2392723.1)

Last updated on MAY 11, 2018

Applies to:

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

Goal

Reimposting batch fails with the below error when more than 1000 invoices fail with accounting or balancing validation.

ERROR
-----------------------
ORA-01000: maximum open cursors exceeded
 

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