Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: Driver Problem due to ORA-04023
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, during applying the R12.1.1 upgrade driver to my 11.5.10.2 EBS. A number of worker jobs have failed because my APPS.FND_FUNCTION_SECURITY package has errors in it. When I try to compile this package body, it does not recompile. I have traced the problem to the APPS.FND_DATA_GROUPS_STANDARD_VIEW it uses. The view is showing up as valid however when I try to do a select count(*) from this view or I try to recompile it I get the error ORA-04023.A description of this error reveals "Object could not be validated or authorized"Any help greatly appreciated, Sara
Similar issue is reported on otn community, just copying the contents of reply, you can also check on
https://community.oracle.com/message/11116592#11116592
looks as if setting _plsql_optimize_level to 0 is causing the problem. I have seen Oracle notes advising a setting of 0 to speed up the R12.1.1 upgrade driver. Looks as if this advice is not great as it can cause other problems.
thanks