Intended Audience

Welcome to Release 12.0 and 12.1 to 12.2 of the Oracle E-Business Suite Upgrade Guide.

This book provides instructions for upgrading existing Oracle E-Business Suite Release 12.0 and 12.1 instances to Oracle E-Business Suite Release 12.2. This book also provides instructions for upgrading an existing Oracle E-Business Suite Release 12.1.3 instance to Oracle E-Business Suite Release 12.2 on Oracle Cloud infrastructure. This delivers the unified driver that you use to upgrade the technology stack and products to Release 12.2.

This book is intended as a guide for the database administrator and the application specialists who are responsible for upgrading to Release 12.2 of Oracle E-Business Suite.

See Related Information Sources for more Oracle Applications product information.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.


1  Overview of the Upgrade
2  Understanding Upgrade Impact and Changes
3  Planning and Performing Pre-Upgrade Tasks
4  Performing the Upgrade
5  Performing Post-Upgrade Tasks
A  Managing Concurrent Processes

Related Information Sources

This book was current as of the time it was initially published. It is included in the Oracle E-Business Suite Document Library, which is supplied in the Release 12.2 software bundle. Later versions of this and other documents that have changed sufficiently between releases to warrant re-publishing are made available at the following URL:

A full list of documentation resources is also published on My Oracle Support. See Oracle E-Business Suite Documentation Resources, Release 12.2. You should be familiar with a basic subset of references before you upgrade. Related Information Sources include:

Oracle E-Business Suite User's Guide

This guide explains how to navigate, enter and query data, and run concurrent requests using the user interface (UI) of Oracle E-Business Suite. It includes information on setting preferences and customizing the UI. In addition, this guide describes accessibility features and keyboard shortcuts for Oracle E-Business Suite.

If you are looking for information about... Refer to these documents...
System setup and procedures Oracle E-Business Suite Concepts
Oracle E-Business Suite Setup Guide
Oracle E-Business Suite Maintenance Guide
Oracle E-Business Suite Security Guide
Oracle Workflow Administrator's Guide
Oracle XML Gateway User's Guide
Installation and upgrade Oracle E-Business Suite Installation Guide: Using Rapid Install
Oracle E-Business Suite Upgrade Guide: Release 11i to Release 12.2
Oracle E-Business Suite Installation and Upgrade Notes*
Oracle E-Business Suite Release Notes*
Oracle E-Business Suite NLS Release Notes*
Oracle Applications Release Maintenance Pack Installation Instructions (Doc ID: 316365.1)
Patch Requirements for Sustaining Support for Oracle E-Business Suite Release 11.5.10 (Doc ID: 883202.1)
Product-specific features Electronic Technical Reference Manual (eTRM)*
Release Content Documents (RCDs)*
Product-specific implementation and upgrade guides
DB Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2 Upgrade (Doc ID: 1349240.1
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID: 1594274.1)
Interoperability Notes: Oracle E-Business Suite Release 12 with Oracle Database 11g Release 2 (11.2.0) (Doc ID: 1058763.1)
Interoperability Notes: Oracle E-Business Suite Release 12.0 or 12.1 with Oracle Database 12c Release 1 (12.1.0) (Doc ID: 1524398.1)
Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID: 2580629.1)
Installing Database Patch Updates for Oracle E-Business Suite on Single Instance VM DB System in Oracle Cloud Infrastructure (Doc ID: 2360215.1)
Installing Database Patch Updates for Oracle E-Business Suite on Oracle RAC VM DB Systems in Oracle Cloud Infrastructure (Doc ID: 2476292.1)
Installing Database Patch Updates for Oracle E-Business Suite on Oracle Cloud Infrastructure Exadata Cloud Services and Oracle Exadata Cloud@Customer (Doc ID: 2368508.1)

* Available only on My Oracle Support.

Patch readme files may also contain information about additional recommended documentation.

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.