Whitepaper Update: Planning Your E-Business Suite 11i Upgrade to R12.1 (Third Edition)

[Editor:  This guest article has been contributed by Anne Carlson]

Premier Support for Oracle E-Business Suite Release 11i ended in November 2010. Extended Support fees for EBS 11i have been waived for all three years, and you should now be using this time to plan your upgrade to EBS 12.1.3. 

I've released the third edition of our popular whitepaper to help you plan your upgrade:

The third edition of this whitepaper still features the latest Release 12 upgrade planning advice from Oracle's Support, Consulting, Development and IT organizations.  In addition to the latest tips and best practices from these organizations, this edition includes new upgrade-related insights from your fellow customers, as well as additional guidance for EBS 12.1.3 and later.

The paper is directed at IT professionals who are planning, managing, or running a Release 12.1 upgrade project.  It provides updated advice on:

  • How to establish your target release
  • How to decide between an upgrade and a reimplementation
  • How to minimize upgrade downtimes
  • Tips on combining your upgrade with a platform migration or footprint expansion
  • Move custom reports to strategic reporting solutions
  • Prepare for Process Manufacturing Inventory Convergence

Your feedback is welcome

To suggest other upgrade planning topics that you would like to see addressed, please leave a comment or send an email to:

Anne Carlson email address

Related Articles


Is there any future possibility to have 12.1.3 stages to be directly downloaded from edelivery other than upgrading the 12.1.1 to 12.1.3 during upgrade?

Because the clients are reluctant to have another test cycle when we go for upgrade again from 12.1.1 to 12.1.3?

Posted by Balaji Srinivasan on February 28, 2012 at 08:52 PM PST #

Hello, Balaji,

I'm afraid that we currently have no plans to offer a Rapid Install for EBS 12.1.3. You must use the EBS 12.1.1 Rapid Install and then apply the 12.1.3 Release Update Pack to get to the latest code level.


Posted by Steven Chan on February 29, 2012 at 12:30 PM PST #


We are mid way through an upgrade from to R12.1.3 and the previous version of this white paper was a good assistant.

However, we are trying to uncover more information about custom objects that have been created (tables/indexes) and the recommended best practice.

The main reason we ask is that we noted that a lot of R12 indexes now have INITRANS set to 11 - we have custom tables and indexes and wondered what the rational behind choosing 11 for INITRANS was and if we should adopt the same for our custom indexes... this then leads on to other "best practices" that we should perhaps also adopt on custom objects.

Any help is much appreciated.


Posted by Brendan Flanagan on March 14, 2012 at 05:14 AM PDT #

Are there any specific recommendations for setting the INITRANS on custom indexes? We are upgrading from R11 to R12 and noticed that a lot of the R12 indexes have an INITRANS value of 11 - but we can't find any backup documentation as to why?

Any help would be appreciated.


Posted by Brendan Flanagan on March 14, 2012 at 08:05 AM PDT #

Hello, Bren,

I ran your question by our Applications Performance team. The responded with this:


This parameter affects the degree of update concurrency within a data block. The initrans specify how many transactions can update rows within a block concurrently, if the value is too low, transactions have to wait until other transactions complete to be able to perform DML on a row in the block.

For high concurrency insert/update tables and indexes they can increase the initrans value.

For most of the tables/indexes, a value of 11 is appropriate.



Posted by Steven Chan on March 15, 2012 at 10:37 AM PDT #

Hi ,

I want to know the budget amount that is needed for the upgrade ,suppose the present 11i instance is working fine with bit of customizaiton .

Also the duration needed for the upgrade to 12.1.3 . Module include SCM,HRMS,CRM and Finance modules .

we have more customizaiton in Order management .

Rajendra .

Posted by guest on April 09, 2013 at 07:41 AM PDT #

Hi, Rajendra,

I think it would be unwise to trust any budget guidance given to you on the basis of two sentences posted to a blog article.

Every customer's 11i-to-R12 upgrade varies, since you need to consider factors such as your own level of DBA expertise, platform migration, data volumes, changes in business process due to new R12 features, and whether existing customizations can be retired.

I would be happy to put you in touch with someone in our R12 Center of Excellence Consulting group. They can help you put together an R12 upgrade plan that takes all of your requirements into account. Please feel free to let me know if you'd like me to do that for you.


Posted by Steven Chan on April 09, 2013 at 08:34 AM PDT #

I have done couple of POC's for my company a year back from to 12.1.1 - 12.1.3, even though we dont have whole lot of data, the 12.1.1 Maintenance Patch, Patch 6678700 took about 20 hours. I would like to know has oracle came up with any solution to minimize the downtime required for upgrade?

Posted by guest on April 12, 2013 at 09:41 AM PDT #

Hello, Ahmed,

Upgrade times vary based upon server performance and other factors (e.g. number of workers). I can put you in touch with our R12 Center of Excellence in Oracle Consulting. They can help optimize your upgrade process. Please feel free to drop me a line if you'd like to me to do that.


Posted by Steven Chan on April 12, 2013 at 10:09 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016