1 2 Previous Next 17 Replies Latest reply on Mar 7, 2019 4:56 AM by VishnuVinnakota

    How to analyze ETCC patch (DB) missing bug fixes?

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      Everytime I run ETCC, it shows missing bug fixes. But when you applied those missing bug fixes you can not because of conflicts.

      Can you guide me how to resolve those conflicts?

       

      I now run our ETCC database has below missing bug fixes:

       

      Some required one-off bugfixes are missing from the Database ORACLE_HOME.

      The missing bugfixes are:

      19509982

      23604553

      25099339

      25139545

      25305405

      25906117

      25971286

      26336977

      26654363

      26742604

      26911000

      28507324

      28729169

       

      But if you apply them, the can not be applied.

       

       

      For example, the first patch 19509982 has conflict

       

      Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
      19509982, 26041567, 26609783

       

      Whole composite patch Conflicts/Supersets are:

       

      Patch : 19509982

       

      Conflict with Composite Patch 26609783

       

       

       

       

      Please help how to analyze and apply this patch

       

       

       

      Kind  regards,

      jc

        • 1. Re: How to analyze ETCC patch (DB) missing bug fixes?
          lmu

          Open an SR with the Oracle Ebusiness technology stack team choose , database or rac if it's rac.

          They told me that shouldn't happen. I'd love to hear what they have to say about it.

           

          Service Request tab -> Create SR ->

          Product -> Oracle E-Business Suite Technology Stack

          Problem Type: EBS Upgrade Issues  -> No Instance affected

          Select upgrade issue ->  ETCC

          • 2. Re: How to analyze ETCC patch (DB) missing bug fixes?
            Beauty_and_dBest

            Hi ALL,

             

            Someone has solution below:

             

            Please perform the following:

             

            1 - Rollback Patches 20204035,, 26041567, 25128602, 22338374, 24568754

             

            2 - Apply Patch 28729169

             

            3 - Apply the following:

             

            Patch 25906117 - version 12.1.0.2.0

            Patch 29171320 - version 12.1.0.2.190115

            Patch 27720266 - version 12.1.0.2.180417

            Patch 29171350 - version 12.1.0.2.190115

            Patch 25099339 - version 12.1.0.2.180417

            Patch 25305405 - version 12.1.0.2.160119

            Patch 28682351 - version 12.1.0.2.5

            Patch 20123899 - version 12.1.0.2.5

            Patch 28790654 - version 12.1.0.2.0

             

             

             

            Can you help how to arrive at this conclusion? What docs notes do I need to map the patches?

             

             

             

            Kind regards,

            jc

            • 3. Re: How to analyze ETCC patch (DB) missing bug fixes?
              Beauty_and_dBest

              Hi Imu,

               

               

              I want to learn it myself because I have lots of instance CRP, UAT, DEV, PROD, TEST that has lots of missing bug fixes and all have conflicts.

              Do I need to raise SR for each instance?

               

               

              Kind regards,

              • 4. Re: How to analyze ETCC patch (DB) missing bug fixes?
                lmu

                I would say , yes do it yourself, if it was a core database, and  not an E-Business Suite database.  You can't go by the regular database notes for EBS db's. 

                 

                I was lectured by Sylvie Berube, EBS ATG ARE, RAC SME, BDE the other day because I wanted to use the recent Bundle patch but it was not yet listed in the ETCC nor the note below so she said I couldn't. 

                 

                First, you have to go by the ETCC.  Then look in this note for the missing patches and or how to resolve conflicts of patches in the ETCC.

                 

                You can find a merge patch on your own, but if it is not listed in the note 1594274.1, you have to open an SR with the EBS technology group and ask them I you can apply it or they say this: I do not believe you should have got any conflict when you wanted to apply Jan BP to the ebs db. What I believe is that the patches applied were *not* what is expected to be certified for EBS. Hence you encountered conflicts because the patching does not respond to what EBS can support.

                 

                How to find your own merge patch:

                get out put of opatch lsinventory -details in a file.

                go to Patches & Update tab in oracle support

                 

                Search for the patch you want to apply.

                When the patch comes up click 'Analyze with OPatch -> Add the output of the oracle Inventory,-> Analyze for Conflict.  This will give you the merge patches.   If they are not listed in that note, you have to ask ATG if they are certified with EBS.

                 

                Or so they told me in a big giant lecture.

                 

                 

                 

                 

                 

                 

                • 5. Re: How to analyze ETCC patch (DB) missing bug fixes?
                  Beauty_and_dBest

                  Thanks Imu,

                   

                  Yes, we are using EBS 12.2.7.

                   

                  So? did you understand the lecture? Are the lecturers for EBS?

                  Or did they suggest to better use the SR  to cast your troubles always?

                   

                   

                  Kind regards,

                  • 6. Re: How to analyze ETCC patch (DB) missing bug fixes?
                    Beauty_and_dBest

                    Hi Imu,

                     

                    I followed the steps you provide below:

                     

                    Search for the patch you want to apply.

                    When the patch comes up click 'Analyze with OPatch -> Add the output of the oracle Inventory,-> Analyze for Conflict.  This will give you the merge patches.   If they are not listed in that note, you have to ask ATG if they are certified with EBS.

                     

                    I take patch 19509982  as sample:

                    Then I got below results.

                     

                    Is there hint  above that suggests below action plan?

                     

                    1 - Rollback Patches 20204035,, 26041567, 25128602, 22338374, 24568754

                     

                    2 - Apply Patch 28729169

                     

                    3 - Apply the following:

                     

                    Patch 25906117 - version 12.1.0.2.0

                    Patch 29171320 - version 12.1.0.2.190115

                    Patch 27720266 - version 12.1.0.2.180417

                    Patch 29171350 - version 12.1.0.2.190115

                    Patch 25099339 - version 12.1.0.2.180417

                    Patch 25305405 - version 12.1.0.2.160119

                    Patch 28682351 - version 12.1.0.2.5

                    Patch 20123899 - version 12.1.0.2.5

                    Patch 28790654 - version 12.1.0.2.0

                     

                     

                     

                    Please help.....

                     

                     

                    Kind regards,

                    • 7. Re: How to analyze ETCC patch (DB) missing bug fixes?
                      mdtaylor

                      Hi jc,

                       

                      The real question for EBS customers is to PSU or not to PSU.  Once a PSU is applied, getting ETCC to clear is much more complex.  Once you apply or obtain an EBS instance from the cloud that has an older PSU applied, you will need to upgrade the database to a recent PSU in order to get all of the 12.2 required patches to apply.  Also review the following document which shows the overlay patches required for 12.2 on top of PSUs.

                       

                      Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Doc ID 1147107.1)

                       

                      Regards,

                      Michael

                      • 8. Re: How to analyze ETCC patch (DB) missing bug fixes?
                        lmu

                        Yes, to PSU or not.  It is true, once you do , you have entered a rabbit hole. as soon as you get whatever you applied in test, it's time for a new etcc and a more patches that will not go with what you just applied.

                         

                        That said, are you using the latest ETCC from patch 17537119? It was lasted updated Feb 26, 2019.  The patch you are trying to apply is a few ETCC's back.

                         

                        Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

                         

                         

                        • 9. Re: How to analyze ETCC patch (DB) missing bug fixes?
                          Beauty_and_dBest

                          Thanks Micheal, Imu, and ALL,

                           

                          This ETCC is so confusing now.

                          I do not understand what mess in our database  this ETCC and PSU is bringing out

                          I better not touch our database anymore, and retain it as it is, no matter what ETCC will tell.

                          It is better to apply the patches reactively as you go along when encountering issues.

                           

                           

                          Kind regards,

                          • 10. Re: How to analyze ETCC patch (DB) missing bug fixes?
                            VishnuVinnakota

                            The thumb rule I follow for ETCC is quarterly and also ensure that I check known issues with these patches.

                             

                            Before applying patches always search MOS with the patch number to ensure there are no new issues due to these patches.

                             

                            Unless you are upgrading DB or Applying major RUPs or Applying latest AD/TXK ETCC is not mandatory to be updated.

                             

                            Thanks,

                            Vishnu

                            • 11. Re: How to analyze ETCC patch (DB) missing bug fixes?
                              Beauty_and_dBest

                              Thanks Vishnu, and ALL

                               

                              But I still want to try one more time this ETCC thing, how to apply missing bug fixes in our EBS 12.2.7 (database 12c, with your guidance).

                               

                              Below is the latest ETCC output:

                               

                              ./checkDBpatch.sh

                               

                              +===============================================================+

                              |    Copyright (c) 2005, 2019 Oracle and/or its affiliates.     |

                              |                     All rights reserved.                      |

                              |             Oracle E-Business Suite Release 12.2              |

                              |          Database EBS Technology Codelevel Checker            |

                              +===============================================================+

                               

                              Using context file from currently set database environment:

                              /u03/ora1228p/P1228/12.1.0/appsutil/P1228_testsvr3.xml

                               

                               

                              Starting Database EBS Technology Codelevel Checker, Version 120.70

                              Wed Mar  6 20:34:53 +08 2019

                              Log file for this session : /u01/PATCH/ETCC/log/checkDBpatch_2184.log

                               

                              Identifying database release.

                              Database release set to 12.1.0.2.

                               

                              Connecting to database.

                              Database connection successful.

                               

                              Database P1228 is in READ WRITE mode.

                               

                              Identifying APPS and APPLSYS schema names.

                              - APPS schema : APPS

                              - APPLSYS schema : APPLSYS

                               

                              Checking for DB-ETCC results table.

                              Table to store DB-ETCC results already exists in the database.

                               

                              Checking if InMemory option is enabled.

                              InMemory option is not enabled in the database.

                               

                              Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.45

                              This file will be used for identifying missing bugfixes.

                               

                              Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.20

                              This file will be used for mapping bugfixes to patches.

                               

                              Checking Bugfix XML file for 12.1.0.2_BP

                               

                              Obtained list of bugfixes to be applied and the list to be rolled back.

                              Now checking Database ORACLE_HOME.

                               

                              The opatch utility is version 12.2.0.1.8.

                              DB-ETCC is compatible with this opatch version.

                               

                              Found patch records in the inventory.

                               

                              Checking Mapping XML file for 12.1.0.2.180116ProactiveBP

                               

                              Patch mapping not available.

                              Patch mapping data is not available for 12.1.0.2 ProactiveBP

                              Some required one-off bugfixes are missing from the Database ORACLE_HOME.

                              The missing bugfixes are:

                              26336977

                              26654363

                              26742604

                              28507324

                              28731800

                               

                              ** Refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix. If an overlay patch is needed for any particular patch listed, the footnote for that patch also applies to the overlay patch. **

                               

                              Apply the missing bugfixes and then rerun the script.

                               

                              Stored Technology Codelevel Checker results in the database P1228 successfully.

                               

                              Finished checking fixes for Oracle Database: Wed Mar  6 20:35:15 +08 2019

                               

                              Log file for this session: /u01/PATCH/ETCC/log/checkDBpatch_2184.log

                               

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

                               

                               

                              But if you apply the missing bug fixes above, they can not be applied due to conflicts.

                               

                              Can you guide me how to find which patches to rollback and apply?

                               

                              Below is the analyze  patch 26336977   with Opatch lsinventory:

                               

                               

                               

                              Kind regards,

                              • 12. Re: How to analyze ETCC patch (DB) missing bug fixes?
                                VishnuVinnakota

                                Hi,

                                 

                                Which patches are failing in these?

                                 

                                Several times we have conflicts, so you might need to rollback conflict patches or request oracle to provide a merge patch.

                                 

                                The missing bugfixes are:

                                26336977

                                26654363

                                26742604

                                28507324

                                28731800

                                 

                                Thanks,

                                Vishnu

                                • 13. Re: How to analyze ETCC patch (DB) missing bug fixes?
                                  VishnuVinnakota

                                  Hi,

                                   

                                  Which patches are failing in these?

                                   

                                  Several times we have conflicts, so you might need to rollback conflict patches or request oracle to provide a merge patch.

                                   

                                  The missing bugfixes are:

                                  26336977

                                  26654363

                                  26742604

                                  28507324

                                  28731800

                                   

                                  Thanks,

                                  Vishnu

                                  • 14. Re: How to analyze ETCC patch (DB) missing bug fixes?
                                    Beauty_and_dBest

                                    I tried to ask merge patch before, but it took so very looong time like 2 months? So it is not effective or efficient way if you ask a merge patch.

                                     

                                     

                                    The conficts are:

                                     

                                     

                                    1.)

                                    Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                                    26336977, 26925263, 27322338

                                     

                                    2.)

                                    Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                                    26742604, 27322748

                                     

                                    3.)

                                    Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                                    26654363, 26925263, 27322338

                                     

                                    4.)

                                    Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                                    26925263, 28507324

                                     

                                     

                                    Do I need to rollback all the above conflicts?

                                    What if I rolled back six patches and applied only one?

                                    Is it acceptable?

                                     

                                     

                                    Kind regards,

                                    1 2 Previous Next