2 Replies Latest reply on Apr 11, 2019 8:32 AM by Beauty_and_dBest

    EBS R12.0.6 upgrade to 12.2.7 -      Apply the Online Patching Enablement patch

    Beauty_and_dBest

      Hi ALL,

       

      We are now in step >

       

      • Apply the Online Patching Enablement patch

       

       

      Apply Patch # 13543062

       

      $ cd 13543062

      $ adpatch options=hotpatch,forceapply

       

       

      Then I encounter failed worker :

       

      1. Facing issue while applying the 13543062:R12.ADC patch (ADOP enablement patch). The error details as below:-

      FAILED file ADZDPREP.sql on worker 1

       

      sqlplus -s APPS/***** @/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsstats.sql '

      Connected.

       

      PL/SQL procedure successfully completed.

       

      declare

      *

      ERROR at line 1:

      ORA-20000: ORA-20001: APPS.GL_DSC_ACRONYM is an invalid identifier Error while

      executing

      FND_STATS.GATHER_SCHEMA_STATISTICS package.

      ORA-06512: at line 98

       

       

      I have been encountering this APPS.GL_DSC_ACRONYM with almost all of my patches

      I just skip it so I can proceed.

      Please help how to cure this bug? or is this part of ADGRANTS.sql?

       

       

      Kind regards,

      jc