Upgrading Oracle EBS to Release 12.2 ? Here is what you should keep in mind !
We all know 11i versions of E-business suite are De-supported at all levels and R12.1 De-support dates are near. In this scenario there is a huge requirement of Upgrade to the latest versions (R12.2). Oracle, no doubt adopted latest technology and moves to give the best in industry and so on the Oracle Application side. Latest version on Oracle application is 12.2 (Specific 12.2.5) and it comes with latest technology stack.
The blow points gives the high-level overview of upgrade to R12.2 from the lower versions. Let’s start with Tech stack versions
| TECHNOLOGY COMPONENT | 11.5.10.2 | R12.0.4 | R12.1 | R12.2/R12.2.5 |
| Database | 9.2.0.6 | 10.2.0.3 | 11.2.0.1 | 11.2.0.3/11.2.0.4 |
| Forms/Reports | 6.0.8.25 | 10.1.2.2 | 10.1.2.3 | 10.1.2.3 |
| Application Server | 1.0.2.2.2 | 10.1.3.0 | 10.1.3.4 | 11.1.1.6/11.1.1.6.7 |
| Webtier | – | – | – | 11.1.1.6/11.1.1.9 |
Any upgrade to R12.2 goes through below phases
- Plan for Upgrade – Better plan is surety of success most of the time. We need to plan and also document all the issues reported so that during the Final-Production upgrade downtime can be minimal. We need to plan and check all the intermediate version are supported if not operational. That is the key point during the planning. Follow the best practices for minimizing the upgrade downtime suggested by Oracle and also as per the client and DBA experiences.
- Prepare for Upgrade– This phase starts after the planning phase and includes Database and Application preparation for upgrade activity. This is the main upgrade phase where we perform all the upgrade activities
- Database Upgrade – Select the latest version for database. If 11g database, consider for 11.2.0.4 version or you can plan for 12c versions too. Also apply the latest Consolidate patches as per the database versions. On the application side we need to be on the Minimum base line patches as per the Oracle recommendations.
- File System Lay down- As we know R12.2 comes with latest technology and file-system, so we need to lay down the R12.2 file-system using the latest startCD. Currently StartCD 50 is available.
- Upgrade to 12.2.0- We need to first upgrade to 12.2.0 and need to apply AD and TXK patches on the 12.2 filesystem. As this is the intermediate stage we need to perform it as pre-install activity. At this stage Application will not be operational.
- Enable Online Patching- As you know new feature of R12.2 is online patching so we need to enable our old instance for the same. This is bit time consuming activity and we need to follow the Online Patching Readiness document 1531121.1 from MOS. This phase fixes
- Any Coding Violation
- Enable edition of Application and or any custom schema.
- Generate edition views and column
7. Upgrade further to 12.2.X- We are at 12.2 with latest database now. Now on the application side we can come to the latest version (12.2.5 Currently). We need to apply the latest technology patches (Delta 7 till now) and EBS RUP patches after that.
- Middle Tier patches -> 1594274.
- AD-TXK RUP patches -> 1617461.1
- EBS R12.2.X Document -> 12.2.4 or 12.2.5
- All the post upgrade patches and steps
8. Translations– In case multiple languages are there then we need to take care of Translation patches as well. 12.2 and then 12.2.X translated patches and also we need to apply TSP (Translation Sync Patches).
9. Customization– Once standard/seeded code is at R12.2.X level we need to take care of the customization’s in our old versions. For R12.2 we have new development standards and need to follow the same to get the custom code compliant with our applications.
References
- Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12 (1406960.1)
- Best Practices for Minimizing Oracle E-Business Suite Release 12 Upgrade Downtime (1581549.1)
- Check the (157766.1) document for Developing and Deploying customization’s
- 15 Documents every Apps DBA must read before upgrading to EBS 12.2
All this will be covered in our EBS 12.2 Upgrade Training and more than a training it’s a Workshop where you will be performing the upgrade (Yes, you will do iteration of upgrade actually on system) and learn for Experienced Trainer. If you want to learn more about Oracle EBS Upgrade 12.2 (Architecture, Overview of R12.2 & Major features in Upgrading to R12.2, Different upgrade paths available to R12.2, Best practises for R12.2 Upgrade, How to minimize down time for R12.2 Upgrade, Difficulties/Issues while upgrading to R12.2) then have a look at our Oracle Upgrade 12.2 .
Note: We are so confident on our workshops that we provide 100% Money back guarantee, in unlikely case of you being not happy after 2 sessions, just drop us a mail before third session and We’ll refund FULL money (or ask us from our 100s of happy trainees in our private Facebook Group)
Stay Tuned for more Information on Oracle Apps 12.2 Upgrade!!