7 Replies Latest reply: Nov 18, 2011 11:16 AM by mybro62 RSS

    11i-R12 upgrade: "Perform the Upgrade" patch order?

    user99472
      I am doing the 11.5.10.2->R12.1.1 upgrade on a Linux x86 system using Maint Wizard v2.19.

      I have entered Category "Upg to Rel 12.1.1" ProdFam "Perform the Upgrade".

      I cannot figure out the order for what is to be done for these tasks since they seem to overlap.

      -------------------------------------------------------------------
      1) Task - Apply Preinstall Patches
      - Step - 1 - Check for critical pre-upgrade patches for Financials
      --- Action - Follow MOS note 954704.1 to apply pre-upgrade patches
      ----- Sub-action #1 - apply patch 7303029
      ----- Sub-action #2 - follow MOS note 1127593.1 and apply individual pre-installation patches
      -------- Sub-sub-action #1 (from MOS 1127593.1) - apply 25 financials pre-upgrade patches

      2) Task - Perform the Upgrade

      - Steps
      --- 9 - Apply DBA CUP and related patches
      ----- Action - apply AD patches 9179588:R12.AD.B, 9477107:R12.AD.B, 7461070:R12.AD.B.1

      --- 9.1 - apply patch 7303029
      -------------------------------------------------------------------

      Patch 7303029 is described in both tasks.
      And the MW steps do not directly mention the "25 financials pre-upgrade patches" from MOS 1127593.

      Please clarify the order of these patches:

      - patch 7303029
      - AD patches 9179588:R12.AD.B, 9477107:R12.AD.B, 7461070:R12.AD.B.1
      - 25 financials pre-upgrade patches from MOS 1127593

      Thanks, Chaz
        • 2. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
          user99472
          Sorry, but this is not a duplicate post.

          In the post you referred to I was trying to understand the Maint Wizard steps and MOS note 954704.1 (recommended R12 patches). I finally realized that only a "section" of that note was involved.

          The MW then moves on to the upgrade steps which I have outlined in this thread (Financials Pre-Upgrade Patches).

          This post has to do specifically with the MW since the steps are vague and overlap and it seems to me the the MW folks are interested in finding these types of issues so that they can be corrected and/or improved.

          Please have someone answer my question since the answer will probably indicate that at least one of the MW steps will need to be modified.

          Thanks
          • 3. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
            mybro62
            We have setup the Maintenance Wizard tasks and steps to be as exact as possible and I would agree that this TASK is the most difficult to follow as the directions in each patch vary. What we have laid out is the following:

            Task: Apply Preinstall Patches      
            1-Check for critical pre-upgrade patches for Financials (Required)

            Apply these patches first in preinstall mode so that they get staged in the $APPL_TOP/admin/$TWO_TASK/preinstall directory. Most likely this directory will not exist and you will need to create it. If it already exists it should be empty at this point in the upgrade process.

            Do not apply patch 7303029 until the step occurs in the maintenance wizard even though referenced in the financials note. The first part of the step for 7303029 downloads the patch 7303029 and verifies that the u67780700.drv driver is in the correct location and ready to be merged. The execute part is a manual step the merges all the 25 financials pre-upgrade patches with 7303029 and the u67780700.drv driver to create a new merged driver with all the fixes.


            So the order is -

            - 25 financials pre-upgrade patches from MOS 1127593

            - AD patches 9179588:R12.AD.B, 9477107:R12.AD.B, 7461070:R12.AD.B.1 0
            This does not effect the pre-install patches from the 25 financials nor the next step for 7303029. We put the step where we did to call out the note so it did not get overlooked or confused with the upgrade task outlined in the upgrade document.

            - patch 7303029

            Basically - follow the maintenance wizard steps as they are laid out in the exact order of execution based on our upgrade documentation.

            I will log an enhancement request to change the text in the Check for critical pre-upgrade patches for Financials step to be more specific on what part of the document to follow.

            Thanks for your feedback and keep it coming please !!!
            • 4. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
              user99472
              Thanks for the clarification. This is really helpful.

              Regarding the 25 pre-upgrade patches.

              1) Can I merge them in the normal fashion, "admrgpch -s SRC -d DEST -merge_name PRE_UPG_MERGE"

              2) Then apply the merge patch using "adpatch -preinstall" using the "u_PRE_UPG_MERGE.drv" file?

              Thanks
              • 5. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
                mybro62
                Yes absolutely - I would recommend that you do.
                • 6. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
                  user99472
                  Super, thanks.

                  After applying the merged AD patches (9179588:R12.AD.B, 9477107:R12.AD.B, 7461070:R12.AD.B.1) I had these invalid objects (and errors):

                  APPS.AD_PA_INSERT_PACKAGE.PACKAGE BODY
                  186 PL/SQL: ORA-02289: sequence does not exist
                  149 PL/SQL: SQL Statement ignored

                  APPS.AD_PA_SUBMIT_REQUEST.PACKAGE BODY
                  674 PLS-00302: component 'SET_AGGREGATE_LIST' must be declared
                  674 PL/SQL: Statement ignored

                  Here's the file header info:

                  /* $Header: adpaipb.pls 120.2 2006/03/27 08:07:14 msailoz noship $ */

                  /* $Header: adpasrb.pls 120.3 2006/09/08 16:14:20 ababkuma noship $ */

                  I found no hits anywhere on either of these. Do I need to open an SR?

                  Thanks
                  • 7. Re: 11i-R12 upgrade: "Perform the Upgrade" patch order?
                    mybro62
                    These are for patchwizard and should not interfere with your upgrade - after the upgrade this should be valid based on the post install patchwizard patches