Welcome!

Recurring Revenue Authors: Derek Weeks, Progress Blog, Liz McMillan, John Katrick, Yeshim Deniz

Related Topics: Microservices Expo, Java IoT, Recurring Revenue

Microservices Expo: Article

Tips for Making the Right Decision for Your Organization

Upgrade vs. Reimplementation for Oracle EBS R12

Executing change management and version control for applications like Oracle E-Business Suite can be a daunting challenge, especially when you're talking about upgrading Oracle E-Business 11i to version 12, commonly called "R12." Your choices to achieve this change include a traditional upgrade to EBS R12, or reimplementation, a rip-and-replace of the current version with R12.

Each approach has its own unique set of advantages and disadvantages, and the path you take to R12 also can depend on whether your organization has EBS 11i, or an older version. In the long run, upgrading is less expensive, but carries a higher technical risk. Reimplementation, which rebuilds your existing Oracle E-Business Suite based on existing data, presents lower risk and requires less technical effort by an experienced DBA, but is more expensive. An EBS R12 upgrade can be challenging and complex, but, with knowledge of a few key fundamentals, you will survive, regardless of whether you're perspective is technical or functional.

For some background, Oracle E-Business Suite 12 presents both technical and design upgrades to 11i, and has been out since 2007. Due to the economic climate of the past few years, Oracle has extended support for prior versions, but soon will discontinue support for EBS 11i, offering extended support only until 2013. Caveats to that extended support include the fact that it comes at an expense to the organization, and requires minimum levels of 11i that can cause enough pain that many organizations decide it's time to rip off the band-aid and simply move to R12. The organization also runs the risk of running on an unsupported version that carries such key business functions as finance.  Plus, business users want R12 functionality, both from new products that didn't exist in 11i, and from the 300 new features and bug fixes now found in R12.

As we've already mentioned, once you've decided to move to EBS R12, you have two alternate paths for making the change: upgrade or reimplementation.

  • In an upgrade, you will essentially massage your existing system and data into the new version.
  • In a reimplementation, you will stand up a completely new instance and either insert your old data where possible, or rebuild it in the new instance.

Upgrading can be less costly since you're essentially making do with what you have, and will require less staff time. Reimplementations often are more complex, requiring more care and feeding by staff. These soft costs are what tend to make this path more costly to the organization.

The key advantage of reimplementation, however, is that it generally presents lower technical risk to the system. The effort, in this case, comes from the functional team in rebuilding the application setups, rather than from the technical team in migrating all the data.

Another consideration is your "starting point" in EBS. If you're using a version older than 11.5.9, your business may have changed as dramatically as EBS over the time since your version was released. Couple this with the R12 recommendation that you be on 11.5.10 or newer to upgrade, and you might find yourself facing a lot of patches to 11.5.10 before you even reach the point where you are ready to upgrade. If you are in this group, you should look closely at the reimplementation option. However, if your business has not undergone many major changes since 11i, and your configurations still apply, you should consider an upgrade.

To summarize so far, here are the pros and cons of each approach:

Upgrade (massage existing into new):

  • Less costly
  • Requires more effort by experienced DBA
  • Requires less effort from functional users
  • Carries a high technical risk

Consider this approach if:

o    You are on EBS 11.5.10 R2

o    There have been no major changes to the nature of your business since 11i, and your configurations still apply

o    Your technical effort and financial resources are tighter

Reimplementation (rebuild new based on existing data):

  • More costly
  • Requires less technical effort
  • Requires more functional effort
  • Carries low technical risk

Consider this approach if:

o    You are on an older version of EBS 11i (11.5.9 or older)

o    Your configurations should change to reflect material change in the business since 11i

o    Your technical resources are fewer, but you have more money available

Your most important task before you begin the move to R12 is to assess your organization's need and the impact of the upgrade. What are your functional needs, what are the technical requirements, and from what version are you beginning? Answering these questions will help you both determine whether to upgrade or reimplement, and start defining the change requirements.

If you choose the upgrade option, make sure you're aware of pitfalls that can present stumbling blocks to your project. To avoid them from the start, be sure to account for all your customizations - both documented and undocumented - and know up front which ones you want to keep; make sure you are current on all your patches before you begin the project; take care to upgrade any custom applications as you move to R12; and, most importantly, make sure that you test thoroughly and often.

Choosing the Right Tool
A good application change lifecycle management solution will be your best friend, whether you choose an upgrade or reimplementation. A solution that gives you increased visibility into application change, as well as control over it, will allow your organization to be more responsive to change, saving both time and money during the upgrade.

Besides helping you manage change, your solution should also assist you with establishing and maintaining version control, and ensuring your organization achieves regulatory compliance during the upgrade. It should be able to address:

  • Issue tracking to track and control progress on all application changes
  • Workflow so you can define the processes and ensure they are enforced in a repeatable, consistent manner
  • Full version control functionality with flat files, Developer, AOL, Function setup, and schema objects
  • Migration management and the ability to ‘drag and drop' configuration and code changes when authorized while invoking the appropriate Oracle technology
  • Patching and impact analysis to schedule and automate application patches, as well as protect developers' work and provide pro-active insight into what changes the patch will make
  • Auditing and reporting on the who, what, why, when, and where changes were made

Regardless of the solution you choose to facilitate your change to EBS R12, and whether you choose upgrade or reimplementation, here are a few best practices you should follow to make your project as trouble-free as possible:

1. An Ounce of Prevention is Worth a Pound of Cure

o    Ensure that all stakeholders are on board

o    Make sure management approves the initiative and the staff, and the costs to execute the project

o    Make sure functional leaders are chosen by competency with the module/business process

o    Select a PMO to own the total project and commandeer execution from start to finish

2. Test thoroughly

o    Do a test upgrade followed by an impact study

o    Test, test and more test through a QA environment and UAT before you push to production

o    Specifically test the third party tools that run with modules/applications

3. Train users properly

o    Stand up a "vision" instance early and encourage users to utilize  it to become familiar with R12 in advance of the production implementation

o    Make sure users are aware of the net-new functionality in R12, plus improvements to existing functionality that are very different from 11i

Planning and successfully upgrading to EBS R12 can be challenging, but, armed with the knowledge of the differences between an upgrade and a reimplementation, along with the circumstances that favor one approach over the other, you should be on your way to making the right decision for your organization.

With the combination of an application change lifecycle management solution that offers you control, visibility and automation; plus knowledge of potential pitfalls and a tried and true set of best practices, you should be ready to embark on a successful upgrade with confidence.

More Stories By Fernando Volonte

Fernando Volonte is the product manager for Stat for Oracle E-Business and Stat for PeopleSoft at Quest Software. He has more than 13 years of experience with change management and version control for enterprise resource planning (ERP) platforms, and has been working with Stat since its outset. During those 13 years, Fern has done everything from tech support to training in English and Spanish. He is considered a Quest subject matter expert in this space and has spoken at conferences around the country on the subject.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
Recently, REAN Cloud built a digital concierge for a North Carolina hospital that had observed that most patient call button questions were repetitive. In addition, the paper-based process used to measure patient health metrics was laborious, not in real-time and sometimes error-prone. In their session at 21st Cloud Expo, Sean Finnerty, Executive Director, Practice Lead, Health Care & Life Science at REAN Cloud, and Dr. S.P.T. Krishnan, Principal Architect at REAN Cloud, discussed how they built...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, led attendees through the exciting evolution of the cloud. He looked at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering m...
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even coding. Raju Shreewastava is the founder of Big Data Trunk (www.BigDataTrunk.com), a Big Data Training and consulting firm with offices in the United States. He previously led the data warehouse/business intelligence and B...
With tough new regulations coming to Europe on data privacy in May 2018, Calligo will explain why in reality the effect is global and transforms how you consider critical data. EU GDPR fundamentally rewrites the rules for cloud, Big Data and IoT. In his session at 21st Cloud Expo, Adam Ryan, Vice President and General Manager EMEA at Calligo, examined the regulations and provided insight on how it affects technology, challenges the established rules and will usher in new levels of diligence arou...
Nordstrom is transforming the way that they do business and the cloud is the key to enabling speed and hyper personalized customer experiences. In his session at 21st Cloud Expo, Ken Schow, VP of Engineering at Nordstrom, discussed some of the key learnings and common pitfalls of large enterprises moving to the cloud. This includes strategies around choosing a cloud provider(s), architecture, and lessons learned. In addition, he covered some of the best practices for structured team migration an...
The 22nd International Cloud Expo | 1st DXWorld Expo has announced that its Call for Papers is open. Cloud Expo | DXWorld Expo, to be held June 5-7, 2018, at the Javits Center in New York, NY, brings together Cloud Computing, Digital Transformation, Big Data, Internet of Things, DevOps, Machine Learning and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding busin...
No hype cycles or predictions of a gazillion things here. IoT is here. You get it. You know your business and have great ideas for a business transformation strategy. What comes next? Time to make it happen. In his session at @ThingsExpo, Jay Mason, an Associate Partner of Analytics, IoT & Cybersecurity at M&S Consulting, presented a step-by-step plan to develop your technology implementation strategy. He also discussed the evaluation of communication standards and IoT messaging protocols, data...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
22nd International Cloud Expo, taking place June 5-7, 2018, at the Javits Center in New York City, NY, and co-located with the 1st DXWorld Expo will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud ...
22nd International Cloud Expo, taking place June 5-7, 2018, at the Javits Center in New York City, NY, and co-located with the 1st DXWorld Expo will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud ...
DevOps at Cloud Expo – being held June 5-7, 2018, at the Javits Center in New York, NY – announces that its Call for Papers is open. Born out of proven success in agile development, cloud computing, and process automation, DevOps is a macro trend you cannot afford to miss. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's largest enterprises – and delivering real results. Among the proven benefits,...
@DevOpsSummit at Cloud Expo, taking place June 5-7, 2018, at the Javits Center in New York City, NY, is co-located with 22nd Cloud Expo | 1st DXWorld Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait...
Cloud Expo | DXWorld Expo have announced the conference tracks for Cloud Expo 2018. Cloud Expo will be held June 5-7, 2018, at the Javits Center in New York City, and November 6-8, 2018, at the Santa Clara Convention Center, Santa Clara, CA. Digital Transformation (DX) is a major focus with the introduction of DX Expo within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive ov...
SYS-CON Events announced today that T-Mobile exhibited at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. As America's Un-carrier, T-Mobile US, Inc., is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 67.4 million customers who are unwilling to compromise on qua...
SYS-CON Events announced today that Cedexis will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Cedexis is the leader in data-driven enterprise global traffic management. Whether optimizing traffic through datacenters, clouds, CDNs, or any combination, Cedexis solutions drive quality and cost-effectiveness. For more information, please visit https://www.cedexis.com.
SYS-CON Events announced today that Google Cloud has been named “Keynote Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Companies come to Google Cloud to transform their businesses. Google Cloud’s comprehensive portfolio – from infrastructure to apps to devices – helps enterprises innovate faster, scale smarter, stay secure, and do more with data than ever before.
SYS-CON Events announced today that Vivint to exhibit at SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California. As a leading smart home technology provider, Vivint offers home security, energy management, home automation, local cloud storage, and high-speed Internet solutions to more than one million customers throughout the United States and Canada. The end result is a smart home solution that sav...
SYS-CON Events announced today that Opsani will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Opsani is the leading provider of deployment automation systems for running and scaling traditional enterprise applications on container infrastructure.
SYS-CON Events announced today that Nirmata will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Nirmata provides a comprehensive platform, for deploying, operating, and optimizing containerized applications across clouds, powered by Kubernetes. Nirmata empowers enterprise DevOps teams by fully automating the complex operations and management of application containers and its underlying ...
SYS-CON Events announced today that Opsani to exhibit at SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California. Opsani is creating the next generation of automated continuous deployment tools designed specifically for containers. How is continuous deployment different from continuous integration and continuous delivery? CI/CD tools provide build and test. Continuous Deployment is the means by which...