Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 20 Vote(s) - 2.45 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Driver Problem due to ORA-04023
#1
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
Reply
Thanks given by:
#2
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
Reply
Thanks given by:




Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!