Skip to main content
Question

Problem while deleting an oracle user?


Forum|alt.badge.img+2

We have this error while trying to delete an oracle user

 

 

This topic has been closed for comments

Nadeesh Herath
Hero (Employee)
Forum|alt.badge.img+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,


dsj
Superhero (Partner)
Forum|alt.badge.img+22
  • Superhero (Partner)
  • August 4, 2021

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


Chamika Dilhani
Hero (Former Employee)
Forum|alt.badge.img+9

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.


Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • August 5, 2021

Thanks all :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings