My Oracle Support Banner

Web ADI Ends With ORA-01000: Maximum Open Cursors Exceeded When Uploading Second Time or with Large Loads (Doc ID 1506876.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Assets - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When uploading assets using Web ADI after 1 successful upload, the following error occurs on subsequent upload attempts:

ERROR
-----------------------
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1

 

The same error can be seen via BNE log when the data exceeds approximately 600 Records.  




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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.