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.