"ORA-01000 Maximum Open Cursors Exceeded" While Trying to Calculate Allocations
Last updated on JUNE 06, 2017
Applies to:Oracle Retail Allocation - Version 13.2 and later
Information in this document applies to any platform.
Allocation calculation fails with the following exception:
Steps to Reproduce:
- Create and calculate Allocations using multiple users.
- Over a period the number of open cursors in database accumulates.
- Once the open cursors reach the maximum open cursor count set, the allocation calculation fails.
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