12 Replies Latest reply on Nov 19, 2016 11:12 AM by Beauty_and_dBest

    Patches applied in EBS R12.1.3

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      11gR2

      OL6

       

       

      The functional consultants encountered many setup and process errors in our EBS.

       

      They ask me if all the required patches are applied

       

      How do I check if the following are existing or have been applied?

       

      R12.OPM_PF.B.delta.6

       

      Can I query it in  APPLSYS.AD_BUGS  or  AD_APPLIED_PATCHES?

       

      Can I also query a database patch in the above tables?

       

      Please help...

       

      Kind regards,

      jc

        • 1. Re: Patches applied in EBS R12.1.3
          Pravin Takpire

          Patch Number -- 20363553 is R12.OPM_PF.B.delta.6.

          Use AD_APPLIED_PATCHES table to check if this patch is applied to your instance or not.

          regards

          Pravin

          • 2. Re: Patches applied in EBS R12.1.3
            Beauty_and_dBest

            Thanks Pravin,

             

             

            There are lots of patches they requested to check if already applied

            The following are not found in AD_APPLIED_PATCHES.

             

            '9701260',

            '10096077',

            '10229047',

            '13717941',

            '13906192',

            '14013094',

            '16016859',

            '20363553'

             

            How do I know which sequence to apply first?

             

            Please help...

             

            Kind regards,

            • 3. Re: Patches applied in EBS R12.1.3
              Shaik

              Hi JC

               

              You need to go through the Read Me of that particular patchso you can identify what is the sequence you need to apply

               

              For example:

              if you want to apply Patch 20363553 is R12.OPM_PF.B.delta.6, you can see two pre-req patches in Read Me as below

               

              Preparation Tasks

              Required Code levels [required]

              This patch requires additional code levels to have been successfully

              applied to your system before it can be applied.  These code levels,

              as at the time that this patch was built, are listed below.  Please check

              'My Oracle Support' to determine if any of these have been superseded

              R12.OPM_PF.B.delta.5

              R12.WMS.B.delta.10

               

               

              Here again you need to go through the Read Me files of this patches to know wether this patches have pre-reqs

               

               

              Regards

              Shaik

              • 4. Re: Patches applied in EBS R12.1.3
                Beauty_and_dBest

                Thanks shaik,

                 

                But the note said, apply only either  or R12.OPM_PF.B.delta.5   or  R12.OPM_PF.B.delta.6 ?

                Did I understand it right?

                Do I need to apply delta.5  then delta.6? 

                 

                 

                Please help...

                 

                Kind regards,

                • 5. Re: Patches applied in EBS R12.1.3
                  Pravin Takpire

                  '9701260',

                  '10096077',

                  '10229047',

                  '13717941',

                  '13906192',

                  '14013094',

                  '16016859',

                  '20363553'

                   

                  -- Check in AD_BUGS for the patches applied or nor. I suggested ad_applied_patches about specific patch.

                   

                  You will have to apply

                   

                  R12.OPM_PF.B.delta.5 (19429224)

                      R12.WMS.B.delta.10 (19447782) ( or above)

                  if not applied already. As per patch readme you should merge all these 3 patches and apply.

                   

                  regards

                  Pravin

                  • 6. Re: Patches applied in EBS R12.1.3
                    Beauty_and_dBest

                    Thanks,

                     

                    I do not like merging because it makes the process complicated

                     

                    So to clarify I will apply first in the following order

                     

                    1. 19429224

                    2. 19447782

                    3. 20363553

                     

                    Kind regards,

                    • 7. Re: Patches applied in EBS R12.1.3
                      Pravin Takpire

                      Replaced by r12.opm_pf.b.delta.6, for customers who haven't applied
                      r12.opm_pf.b.delta.5  should merge r12.opm_pf.b.delta.5 with r12.opm_pf.b.delta.6
                      before applying r12.opm_pf.b.delta.6

                       

                      This is from read me/patch description of delta.5 -- So I don't think so you have choice.

                      In my view merging does not increase complexity, instead saves lot of time.

                      regards

                      Pravin

                      • 8. Re: Patches applied in EBS R12.1.3
                        Pravin Takpire

                        You can try and apply the patches in that order individually, only caveat is that Oracle may not support you if you face difficulty/failure in applying patches. Also take backup before start applying patches, so that you can revert back.

                        regards

                        Pravin

                        • 9. Re: Patches applied in EBS R12.1.3
                          Beauty_and_dBest

                          Thanks Pravin,

                           

                          I have not done merging yet

                          What is the command again? I am afraid my merge will have corrupted output if not done correctly.

                           

                          How about   R12.WMS.B.delta.10 (19447782)  ? Do I need to merger it as well?

                           

                          Is this merge process correct:

                           

                          Step 1. Create two directory "source" and "dest"

                           

                          cd home

                          mkdir source

                          mkdir dest

                           

                          Step 2. Unzip patches (19429224,19447782, 20363553)  into source directory.

                           

                           

                          Step 3: Now, Merge the patch

                           

                          admrgpch -s source -d dest -merge_name ABC_merge

                           

                          Step 4: Check the admrgpch.log logfile for any error

                           

                           

                           

                           

                          Kind regards,

                          • 10. Re: Patches applied in EBS R12.1.3
                            Beauty_and_dBest

                            Hi Pravin, Shaik, and ALL,

                             

                            Sorry my small brain still slow to understand clearly with the notes instructions

                             

                            Please confirm if I need to merge all the three patches or only the last two?

                             

                            R12.WMS.B.delta.10

                            R12.OPM_PF.B.delta.5

                            R12.OPM_PF.B.delta.6

                             

                            I really puzzled by this complicated instructions

                             

                            Note: You may also merge the other prereq patch R12.WMS.B.delta.10 (or above) along with

                            R12.OPM_PF.B.delta.5 and R12.OPM_PF.B.delta.6 if you haven't applied

                            R12.WMS.B.delta.10 (or above).

                             

                            It is mixing up my brain   by adding "or" which can be both true of false.

                             

                            Can you explain it step by step?

                             

                             

                            Kind regards,

                            • 11. Re: Patches applied in EBS R12.1.3
                              Shaik

                              Hi JC

                               

                              Hi

                              Check  whether the patch R12.WMS.B.delta.10 applied in your environent

                               

                              If alredy present ,  then merge R12.OPM_PF.B.delta.5 and R12.OPM_PF.B.delta.6 and apply

                              If Not , then merge all 3 patches  and apply

                               

                               

                              Regards

                              Shaik

                              • 12. Re: Patches applied in EBS R12.1.3
                                Beauty_and_dBest

                                Thanks Shaik

                                 

                                You should replace the Oracle documentation writer

                                 

                                 

                                Kind regards,