3 Replies Latest reply on Aug 12, 2015 5:56 PM by Venkatesh Viswanathan

    Error While recreating grants and synonyms using adadmin

    Venkatesh Viswanathan

      Hello All,

       

      I am in the process of upgrading the environment from 11.5.10.2 with 9.2.07 database to R12.1.3 with 11.2.0.4 database. I have completed the database upgrade and R12 file system. After applying the R12 AD patch while recreating the grants and synonyms to apps schema using adadmin I got below error.

       

      ERROR at line 1:

      ORA-20000: ORA-01403: no data found

      ORA-01720: grant option does not exist for

      'APPS.JTF_PF_PARAMS_TABLE':create_grants_and_synonyms(1,JTF,APPLSYS,APPS):

      create_base_gs(JTF,APPS): In Grants Loop:create_grant(JTF_PF_REPOSITORY does

      not exist in ): do_apps_ddl(JTF,GRANT ALL ON "JTF_PF_REPOSITORY" TO APPS WITH

      GRANT OPTION):

      ORA-06512: at line 5

       

      To resolve this issue, I have followed the Doc: Recreate Grants And Synonyms Ora-01720 for JTF.JTF_PF_REPOSITORY (Doc ID 362614.1)


      In this solution first step got completed and I got below error while executing the second step;

       

      conn jtf/jtf

      grant all on jtf_pf_repository to apps;


      Error: ORA-01720: grant option does not exist for 'APPS.JTF_PF_PARAMS_TABLE'


      Kindly help me on this issue.


      Regards,

      Venkatesh