Invalid Objects

you can check that from the client side via PL/SQL or SQL Developer. go to tools > Compile Invalid Objects.. in order to see what's causing you have to manually go to edit mode on respective package/view to see further.

hope this serves your requirement.

@EntShehaM 

Thank you so much for your reply, I had already tried SQL Developer selecting Invalid view(s) and then RMB Open, the Errors tab displayed no problem.

RMB > Open  then clicking the Errors tab displays no issues:

RMB > Compile and the view compiles without any issues.

This doesn’t explain why this is happening though.

Thanks

John

Any other ideas?

this is strange, please try refreshing dictionary and security cache after compiling invalid object. then refresh the page and see if these views still exist.

Hi John,

If you want tosee what has caused these packages to be invalid you can get the invalid objects window through PLSQL developer as stated above, RMB on the package, and click Edit Package and Body. There once you recompile the package you can see all the erroneous code that is causing this package to be invalid. 

Regards,

Nadeesh