Opening Hierarchies Table Throws Error
When you browse the gross structure hierarchies from say the Well Browse/Edit dialog
you may get an error such as
This is because the default setting for the OPEN_CURSORS parameter in the Oracle database is too low for the Player application. You can get around this by increasing the number of cursors allowed to 1000. For example:
Alter system set open_cursors = 1000 scope=both
This value may have already been increased for other applications but if you get this error, this is your solution. Your Oracle DBAs should be familiar issue with this issue.