We have this error while trying to delete an oracle user
This topic has been closed for comments
Userlevel 6
+9
Hi DavidSaad
Are there invalid objects in the database? you could check it as shown below by logging into the database through PLSQL Developer,
If there are no invalid objects in the database, i would recommend a dictionary cache refresh by logging into the application and navigating to the Cache window and checking Dictionary as follows,
Please refresh security and reference if they have not being refreshed that often too.
Regards,
Userlevel 7
+20
Hi
C_SCADA_MIGRATE_TAB seems like a part of a customization code so more investigation would be needed to identify the cause of the error.
Open the debug console (ctrl +shift+D) and try to delete the user while the debug console is open. Then you can see the console line with the error highlighted in red and the error stack in Server Trace tab. It would be helpful to troubleshoot further.
Cheers!
Damith
Userlevel 6
+7
Hi,
It seems C_SCADA_MIGRATE_TAB have been introduced from a customization. Are you trying to remove the oracle user from that customized window? You can get this confirmed by clicking on the System Info at the bottom of the page. Check if view name is something related to ‘C_SCADA_MIGRATE’…
If you are trying to remove the user from our standard window, try deleting the same oracle user from the window related to C_SCADA_MIGRATE_TAB (I don’t know the corresponding window as this is a customized tab.) first.
Thanks all :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.