2 Replies Latest reply on Oct 1, 2018 1:03 PM by Beauty_and_dBest

    Error - Online Patching Enablement patch: 13543062:R12.AD.C

    Beauty_and_dBest

      Upgrade EBS 12.0.6  to 12.2.7

       

      Oracle® E-Business Suite

      Upgrade Guide

      Release 12.0 and 12.1 to 12.2

      Part No. E73540-04

      July 2018

       

       

      Hi ALL,

       

      In page 124, section 4-62 Oracle E-Business Suite Upgrade Guide, mentioned below requirement.

       

      While applying the patch, I got worker error below: 

       

      begin

      *

      ERROR at line 1:

      ORA-04063: package body "APPS.AD_ZD_PREP" has errors

      ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"

      ORA-06512: at line 4

       

       

       

      Please help how to resolve this issue.

       

       

       

      Kind regards,

      jc

        • 1. Re: Error - Online Patching Enablement patch: 13543062:R12.AD.C
          Beauty_and_dBest

          Hi ALL,

           

          Do I need to apply first this patch, before applying above patch?

          Run adgrants.sql from patch 22200487 (EBUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT)

           

          Why do I have two enablement patches?

           

          SQL> select bug_number from ad_bugs where bug_number in('22200487','26086707');

           

          BUG_NUMBER

          ------------------------------

          22200487

          26086707

           

           

          ==============================================================================

          E-BUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT

          ==============================================================================

           

          Update   - 26086707

          Product  - Oracle Applications DBA

          Release  - R12

          Platform - Generic Platform

          Built    - SEP-08-2017 05:21:57

           

          Instructions For Applying This Patch

          ==============================================================================

           

           

          ==============================================================================

          E-BUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT

          ==============================================================================

           

          Update   - 22200487

          Product  - Oracle Applications DBA

          Release  - R12

          Platform - Generic Platform

          Built    - SEP-14-2016 23:04:50

           

          Instructions For Applying This Patch

          ==============================================================================

           

           

          Kind regards,
           

          • 2. Re: Error - Online Patching Enablement patch: 13543062:R12.AD.C
            Beauty_and_dBest

            Hi I got this from blog

             

             

            Solution:

             

             


            cd $ORACLE_HOME
            sqlplus / as sysdba

            alter session set current_schema=SYS;
            @?/rdbms/admin/dbmsobj.sql
            @?/rdbms/admin/dbmsxdbschmig.sql
            @?/rdbms/admin/prvtxdbschmig.plb


            Run adgrants.sql from patch 22200487 (EBUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT)
             
            Copy adgrants.sql from patch directory to $ORACLE_HOME/appsutil/admin


            $ sqlplus /nolog

             

            SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

             
            Try to compile the package again.

            SQL> alter package apps.AD_ZD_PREP compile body;

            Package body altered.
             
            SQL> show error
            No errors.