Skip to main content

We have this error while trying to delete an oracle user

 

 

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,


Hi @DavidSaad,

 

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


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 :)