Case Study Redux: Oracle's Own Oracle E-Business Suite Release 12 Upgrade (OpenWorld 2008 Recap)

I'll be highlighting OpenWorld 2008 presentations that cover some of the most popular E-Business Suite technology stack topics.  A catalog of all of the Applications Technology track sessions with links to the presentations is available here:

One of the most-popular sessions at OpenWorld every year is our discussion about Oracle's own E-Business Suite implementation. Donna Buhlig and Nigel Cooper, from our Applications IT (AIT) group, have expanded upon previous years' presentations with a bigger and more in-depth look at our internal Global Single Instance deployment:


Donna and Nigel covered the following topics:

  • Overview of E-Business Suite R12 products used within Oracle
  • Current statistics about our Apps R12 database size:


  • Systems metrics, including the number of concurrent database and Forms sessions, and Concurrent Manager jobs
  • Physical architecture for our Global Single Instance (GSI) deployment
  • Application Server configuration -- with comparisons between Release 11i and R12 server configurations


  • Oracle's system monitoring strategy, with focus on Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM), and other ad hoc monitoring tools
  • System change management strategy, showing how patches flow from Test to Production
  • Release 12 Upgrade
    • Strategy and detailed upgrade activities by tier and project phase
    • Use of "Upgrade by Request" to upgrade 8 out of 20 years of SLA data migrated
    • APPL_TOP cleanup of obsolete customizations
    • Conversion of historical reports to XML Publisher
    • Performance testing
    • Upgrade project plan and tasks
    • Init.Oracle parameter changes from Release 11i
    • Number of works used during the upgrade, adpatch ptions
    • Detailed post-upgrade steps
    • A candid look at issues identified during testing
    • Actions taken to reduce the upgrade downtime

Related Articles


Hi Steven

I am now plan to upgrade our system from 11.5.4 to 12.0.6.
First I need upgrade 11.5.4 to
fellow note 316365.1 Oracle Applications Release Maintenance Pack Installation Instructions
this step contain four sections.
Section 1: Pre-Update Tasks
Tasks that must be performed to prepare your system for application of this maintenance pack.
Section 2: Applying the Maintenance Pack
Instructions for applying this Maintenance Pack to a Release 11i system.
Section 3: Post-Update Tasks
Tasks that must be performed after applying the maintenance pack.
Section 4: Product-Specific Tasks

My question is when I complete Section1 to Section3.
Is Section 4: Product-Specific Tasks must be done and for each Application which patch level I must apply to?for example,ATG,there have ATG RUP4,RUP5,RUP6. for upgrade to R12,which level I need to apply to?Is there have some note or doc to explain it?

Best Regards

Posted by Samuel on April 26, 2009 at 07:11 PM PDT #

Hi, Samuel,

All of the product-specific parts Section 4 of Note 316365.1 should be completed to ensure that your data and setups are all in a known-good state prior to your EBS 12.0.6 upgrade. This is extremely important.

There are no ATG-related steps in that section, so you don't have to do anything associated with ATG rollup patchsets.

If you have any specific questions about the steps listed in Section 4, I'd recommend logging a formal Service Request via Metalink. Our Support engineers can help answer any upgrade-related questions that you might have.

Good luck with your upgrade.


If you have specific

Posted by Steven Chan on April 27, 2009 at 03:28 AM PDT #

Hi Steven,

Thank you for your kindly help.

Best Regards

Posted by Samuel on April 29, 2009 at 10:42 AM PDT #

Hi Steve,

Thanks for your help in sharing extremly helpful information. We are planning to begin R12 ugrade by next week from 11i10.2 to 12.1.1. Do you happen to have documentation for pre and post upgrade steps from eBS application prospective for P2P?


Posted by Darshan on September 09, 2009 at 03:08 AM PDT #

Hi, Darshan,

I'd recommend checking out the resources linked in these two articles:

New Whitepaper: Best Practices for Adopting E-Business Suite Release 12 -

Five Key Resources for Upgrading to E-Business Suite Release 12 -

Good luck with your upgrade!


Posted by Steven Chan on September 09, 2009 at 06:47 AM PDT #

Hi Steven,

I know it has been a few years since Oracle went through the process of bring multiple instance into the single global instance. I have a question related to that process. We have 2 Oracle production instances and we want to migrate the data from instance into the primary company instance. Are there tools or defined processes from Oracle on migrating the data from one Apps instance to another? My boss thinks there should be some standard tools available to make this a relatively easy process and that we shouldn't have to create custom scripts for exporting and importing the data. It's all Oracle after all.

Both instances are One is RDBMS Solaris (the system that will be the target for the migration), one is RDBMS on RHEL4.

Thanks in advance for your feedback.


Posted by Steve on May 19, 2010 at 06:25 AM PDT #

Hi, Steve,

EBS Development doesn't have any standard tools or recommended processes for consolidating data from multiple EBS instances. The E-Business Suite was always designed from the ground up to be a global single instance.

Our Oracle Consulting division may have tools or processes that they can apply to your specific consolidation requirements, but I don't have any visibility into that. Your Oracle account manager can research this with Consulting, if you wish.

You may also with to ask your Oracle account manager to arrange a meeting with Will Toms in our Oracle@Oracle group. Will can pull in Oracle Apps IT staff who were involved in our five-year consolidation project; they have lots to tips to share on how they pulled this massive effort off.

Good luck with your project.


Posted by Steven Chan on May 21, 2010 at 06:55 AM PDT #

Hi Steve,

We are planning to begin upgrade from 12.0.1 to 12.1. Do you happen to have documentation for pre and post upgrade steps.


Posted by Milind on July 13, 2010 at 06:21 PM PDT #

Hi, Milind,

See this article for references:

E-Business Suite Release 12.1.1 Now Available


Posted by Steven Chan on July 14, 2010 at 03:52 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016