My Oracle Support Banner

Rollup Batch Fails With Error ORA-01000: Maximum Open Cursors Exceeded (Doc ID 2806124.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

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

Symptoms

Rollup batch is failing with ORA-01000 error.

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

Steps to Recreate:

  1. Ensure that there are huge number of debit memos which are reversed.
  2. Run reimrollup batch and notice the below error.
    "ORA-01000: maximum open cursors exceeded"

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.