+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: EBS R12.2 Upgrade Center (http://www.oraerp.com/forum-30.html)
+---- Thread: Driver Problem due to ORA-04023 (/thread-70989.html)
Driver Problem due to ORA-04023 - Sara Khan - 07-26-2013
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
RE: Driver Problem due to ORA-04023 - Kashif Manzoor - 08-27-2014
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