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 with 9.2.07 database to R12.1.3 with 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


      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


      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.