5 Replies Latest reply on Sep 26, 2019 12:24 PM by Beauty_and_dBest

    How to check if patch is already applied - EBS 12.2.5

    Beauty_and_dBest

      EBS 12.2.5

      12c Db

      OL6

       

      Hi ALL,

       

      I am applying patch 29498976: ATG CONSOLIDATED PATCH FOR ECC V3 SUPPORT IN 12.2.5

       

      But its readme has list lots of pre-requisites below:

       

      I know some of the pre-reqs are already applied,

      How do I check them?

      Please share scripts on how to query applied patches in 12.2.

       

       

       

      Kind regards,

      jc

        • 1. Re: How to check if patch is already applied - EBS 12.2.5
          mdtaylor

          Hi jc,

           

          12.2.5 required AD/TXK Delta 7, so you should only be missing AD/TXK Delta 11.

           

          You need to determine the actual patch numbers for them, then query ad_bugs to determine if they are applied.

           

          Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

           

           

          select * from ad_bugs where bug_number = '26834480'  --AD.C.Delta.11

          select * from ad_bugs where bug_number = '28840822';  --TXK.C.Delta.11

           

          You can also type those numbers in Oracle Applications Manager in Dashboard->Site Map->Maintenance->Applied Patches:

          Screen Shot 2019-09-25 at 8.22.43 AM.png

          Regards,

          Michael

          • 2. Re: How to check if patch is already applied - EBS 12.2.5
            Beauty_and_dBest

            Thanks Michael,

             

            But I think there is a new query,  ( I read something like)  not all patches written in ad_bugs where successfully applied?

            Some maybe aborted or rolled back or cancelled?

            Please share the updated query

             

             

            Kind regards,

            • 3. Re: How to check if patch is already applied - EBS 12.2.5
              mdtaylor

              Hi jc,

               

              Aborted patches will not appear in ad_bugs.  You can also use the following query to see what has been applied to 12.2 instances:

               

              select distinct ap.patch_name, to_date(to_char(ap.creation_date,'DD-MON-YYYY')) date_applied,

              NVL(ad.patch_abstract,DECODE(ad_pa_validate_criteriaset.get_concat_mergepatches(ad.patch_driver_id ),NULL,'',

                       ad_pa_validate_criteriaset.get_concat_mergepatches(ad.patch_driver_id ))) patch_description

              from ad_applied_patches ap,

              (select patch_abstract, replace(replace(driver_file_name,'.drv',''),'u','') patch_name,

              patch_driver_id, applied_patch_id from ad_patch_drivers) ad

              where ap.creation_date > sysdate -2000

                and ap.applied_patch_id = ad.applied_patch_id order by 2 desc, 1 desc;

               

              Regards,

              Michael

              • 4. Re: How to check if patch is already applied - EBS 12.2.5
                Maaz Khan

                Hi Jc,

                 

                Adding a few more using which you can check for 12.2 instance -

                 

                set lines 1000
                col APPLIED_FILE_SYSTEM_BASE for a40
                SELECT b.bug_number, asp.adop_session_id, asp.bug_number patch#,
                       asp.session_type, asp.applied_file_system_base,
                       asp.start_date, asp.end_date
                FROM ad_bugs b, ad_patch_run_bugs prb, ad_patch_runs pr,
                     ad_patch_drivers pd, ad_adop_session_patches asp
                WHERE b.bug_id = prb.bug_id
                  AND prb.patch_run_id = pr.patch_run_id
                AND pr.patch_driver_id = pd.patch_driver_id
                  AND pr.patch_run_id = asp.patchrun_id
                  AND prb.applied_flag = 'Y'
                  AND b.bug_number = '&bug_num';


                SELECT adb.bug_number,ad_patch.is_patch_applied('122', 1045, adb.bug_number)
                FROM ad_bugs adb
                WHERE adb.bug_number in (29781255);

                 

                 

                 

                select ad_patch.is_patch_applied('R12',-1,29781255) from dual;

                 

                 

                Regards,

                Maaz