Upgrade 11i to 12.2

Here is a enterance level document to be used to have a general picture before the EBS 11i to 12.2 upgrade.

It covers the navigation for the documents that are used in the upgrade process, as well as the general steps that should be performed for upgrading EBS 11i to EBS 12.2.

Note that: This document is just a compliation of Oracle documents, but I believe it will save you time as reading it , you will not have to go back and forth among all the related documents for determining the required upgrade tasks.

Main Document :Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)

->Section 3: Instructions for Upgrade Customers :"Oracle E-Business Suite Upgrade Guide, Release 11i to 12.2 or Oracle E-Business Suite Upgrade Guide: Release 12.0 and 12.1 to 12.2 guides"

Direct Document:

https://docs.oracle.com/cd/E26401_01/doc.122/e48834/toc.htm (Oracle E-Business Suite Upgrade Guide Release 11i to 12.2 Part Number E48834-15)

----

Upgrade Path:

11.5.10 CU2 -> Minimum Patch Requirements for Sustaining Support for 11.5.10 -> Release 12.2

------

Steps:

Before starting the process, it is important to note that it is required to have a new application tier for placing the EBS 12.2's apps tier. This is required as EBS 11i 's Apps Tier is not supported to run on Linux x86-64 bit and EBS 12.2's Apps and DB tiers are delivered as 64 bit.

So at least for Linux installations, there is a need to have a supported Linux OS for placing the EBS 12.2 's Apps Tier.

1)

Upgrading to Oracle E-Business Suite Release 12.2 requires your database to be at the minimum version 11.2.0.4.

To complete the upgrade to Release 12.2, you must upgrade your database to 11.2.0.4 or higher.

Follow the instructions in Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2 Upgrade (Doc ID: 1349240.1).

2)

INFO:Completing this upgrade brings your system to the 12.2.0 release.

You must apply the 12.2.5 Release Update Pack (RUP3) or later(12.2.5) to your existing Release 12.2 system for production use.

3)

Do the sizing CPU,Memory,Disk Space, IO subsystem.

4)

Know that IDO 10g and OSSO 10g will be desupported. Think about implementing OAM and Oracle Access Gate.

5)

Apply 11i.AD.I.7 (conditional) -- if you are not on AD.I.7

6)

Run TUMS utility and reviw: Download and apply AD TUMS patch

Download patch 18342870 and apply it to the administration server node on your Release 11i APPL_TOP.

It supplies you with the script (adtums.sql) you need to generate the TUMS report (tumsr12.html).

Generate the TUMS report->

$ cd $AD_TOP/patch/115/sql

$ sqlplus <APPS username> @adtums.sql <DIRECTORY>

7)

Backup the database and apps tier including customizations (cold backup preferred)

Note that: Customization is not handled during the upgrade, so the customization should be reapplied when the upgrade is done.

8)

Prepare yourself for the customizations.

You may have customized your system for business use. Take note of these important considerations before upgrading custom database objects:

The Oracle E-Business Suite Developer's Guide contains extensive instructions about naming standards and issues related to upgrading custom database objects. Familiarize yourself with this information before you begin the upgrade.

Run several test upgrades and track their impact on your custom database objects.

Rename any custom database objects with Applications prefixes that you have created so that they do not conflict with Oracle object names.

Note: Failure to test the impact on custom database objects before the upgrade can result in a loss of functionality.

At your discretion, and depending on the customizations in your system, you should also perform the following tasks:

Preserve the CUSTOM library by making a backup copy of CUSTOM.pll. You can use this copy later in the upgrade process to migrate your CUSTOM library to Release 12.2.

If you have customized forms with Oracle Forms 6i, then upgrade them to Oracle Forms 10g after the upgrade.

9)

Convert to Multiple Organizations architecture (required).

Converting to Multiple Organizations does not require the use of multiple operating units or sets of books - it does enable you to use this functionality at any time in the future.

If you are converting from a Single Organization architecture to a Multiple Organization architecture, complete the following steps:

Create an operating unit.

Assign the operating unit you created to the profile option MO:Operating Unit.

Note: See the following documentation references: Use of Multiple Organizations in Release 12 in Use of Multiple Organizations (Multi-Org) in Release 11i (Doc ID: 210193.1), and MOAC in Oracle Purchasing (Doc ID: 404800.1). HRMS users should also see Setting Up Multiple Organizations for Oracle HRMS (Doc ID: 259546.1).

10)

Drop event alert triggers in custom schemas (conditional).

To drop all event alert database triggers in custom schemas, run the alrdtrig.sql script, located in $ALR_TOP/admin/sql (in your Release 11i system). Re-create the triggers after the upgrade is complete.

11)

Review sizes of old and new tablespaces (required).

Make sure you allocate sufficient tablespace.

For guidelines based on an upgrade of the largest Oracle production system (oraprod), see Applications Release 12 Upgrade Sizing and Best Practices (Doc ID: 399362.1).

12)

Run AD preparation scripts (conditional).

Download and unzip the new patch 13435302. Follow the instructions in the readme for running these scripts:

adgncons.sql

The tablespace model for this release (OATM) is based on database object type rather than product affiliation. The adgncons.sql script prepares adcrtbsp.sql, configures the database to hold the new products to be added during the upgrade, and switches your system to use the new tablespace model.

adcrtbsp.sql

Generated by adgncons.sql, this script creates the new tablespaces, allocates unlimited tablespace to all APPS users, updates fnd_product_installation table with correct data and index tablespace information, assigns default tablespace to all APPS users, and sets the new_ts_mode flag in fnd_product_groups to Y. Be sure to review the locations of the dbf files for each new tablespace listed in adcrtbsp.sql, and change the locations in the script as necessary. Ensure that you have adequate disk space for all the changes and additions that adcrtbsp.sql is going to make.

Note: All the tablespaces created by adcrtbsp.sql are critical and required for 12.2 as they hold critical objects. Therefore, you should not drop any of these tablespaces at any point.

Note: Oracle has tested successfully an extent size of 128 K for small systems (for example, 100 GB database or the Vision database), and, for large multi-terabyte system, an extent size of 4-10 MB has been tested successfully.

adgrants.sql :(adgrants_nt.sql for Windows) Grants SYS privileges needed by Applications, and creates required views in SYS.

13)

Migrate Existing Objects to New Tablespace Model (recommended).

Running the preparation scripts creates tablespaces and prepares the database objects only for new products.

However, it does not automatically migrate your existing objects.

Oracle strongly recommends that you use the Tablespace Migration Utility to perform this migration now.

Note that this utility is not supported for use after you enable Online Patching, so you cannot perform the migration after your environment is upgraded to Release 12.2.

If you choose not to migrate to OATM now, then you must continue to manage your tablespaces separately.

Check the Oracle E-Business Suite Setup Guide, Release 12.2 for mor information.

14)

Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer (conditional)

If you use response processing alerts and you have not already converted Oracle Alert to the Workflow Notification Mailer, convert now by applying Oracle Applications Technology 11i.ATG_PF.H Rollup 6 (patch 5903765) to your Release 11i APPL_TOP. This roll up patch causes Oracle Alert to use the Workflow Notification Mailer for new alerts, but allows you to continue to run the Alert Response Processor for incoming responses sent before the conversion. Continue to run the Response Processor until you have no more outstanding responses of this kind.

Note: See About Oracle Applications Technology 11i.ATG_PF.H Rollup 6 (Doc ID: 444524.1) for more information.

15)

Oracle XML Gateway: In release 12.2, Oracle XML Gateway Web services depend on Oracle E-Business Suite Integrated SOA Gateway which has product dependencies on Oracle SOA Suite and Oracle Fusion Middleware Adapter for Oracle Applications (also called Oracle E-Business Suite Adapter). See Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID: 1311068.1).

16)

Ensure that the GUEST account is valid and active and that the fnd_user USER_ID for the GUEST account is set to a value of '6'.

17)

Do Product specific upgrade tasks documented in : Preparing for the Upgrade secetion of "Oracle E-Business Suite Upgrade Guide Release 11i to 12.2 Part Number E48834-15" - https://docs.oracle.com/cd/E26401_01/doc.122/e48834/T527285T527359.htm

-Customer Relationship Management Tasks

-Financials and Procurement Tasks

-Human Resource Management (HRMS)

-Lease and Finance Management

-Projects tasks

-Public Sector Tasks

-Supply Chain Management Tasks

18)

Gather schema statistics (required)

FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, :parallel_degree, 'NOBACKUP', NULL, 'LASTRUN', 'GATHER AUTO', 10, 'N');

Where: parallel_degree is set to the value of the database initialization (init.ora) parameter parallel_max_servers for your instance.

19)

Install JRE on the database tier (conditional)

If you are planning to run Rapid Install in Upgrade Mode by using the Use Existing ORACLE HOME option, then you must install JRE in the Database ORACLE_HOME/appsutil as follows:

Download the latest JRE 7 Update. For optimum stability, performance, scalability, and OS vendor support, use the latest available update of JRE for the Oracle E-Business Suite database tier. The JRE download location is: http://www.oracle.com/technetwork/java/javase/downloads/index.html

20)

Reset init.ora parameters (required)

Follow the instructions in Database Initialization Parameters for Oracle E-Business Suite Release 12.2 and reset the init.ora parameters as needed.

21)

Run Rapid Install (required)

Use the Rapid Install wizard to lay down the file system and install the new technology stack for your Release 12.2 Oracle E-Business Suite system.

-Start Rapid Install by typing rapidwiz on the command line. The Welcome screen lists the components that are included in, or supported by, this release of Oracle E-Business Suite. Click Next.

-On the Wizard Operation screen, select Upgrade to Oracle E-Business Suite Release 12.2. Click Next.

-On the Select Upgrade Action screen, select Create Upgrade File System.

-In the associated screen flow, enter the parameters required to set up your new environment. Then, run Rapid Install.

-Note: Oracle E-Business Suite Installation Guide: Using Rapid Install contains complete instructions for running Rapid Install for both new installations and upgrades. Chapter 3 contains the information specific to running an upgrade.

22)

Synchronize values of APPLPTMP with UTL_FILE_DIR for PL/SQL based Concurrent Requests (required)

23)

Backup the database and apps tier including customizations (cold backup preferred)

24)

At this point, the database must be 11.2.0.4 or higher. So if not upgraded earlier, upgrade the database.

If you have not already done so, you can upgrade your production database to 11g Release 2 (11.2.0.4) or higher now, before the upgrade downtime. Follow the instructions in Database Preparation Guidelines for an Oracle E-Business Suite Release 12.2 Upgrade (Doc ID: 1349240.1).

Note: If you are upgrading to 11gR2 or 12cR1 from 10g or 9i, then you MUST set the parameter sec_case_sensitive_logon = False in your init.ora file to avoid login issues with sqlplus. For more information on this parameter and other database initialization parameters, refer to Database Initialization Parameters for Oracle Applications Release 12 (Doc ID: 396009.1).

If you are upgrading to a Release 12c database, then ensure that your sqlnet_ifile.ora contains the line: SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

25)

Disable AOL Audit Trail (conditional)

26)

Shut down application tier listeners and concurrent managers (required)

27)

Update init.ora with upgrade parameters (required)

28)

Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema

29)

Disable custom triggers, constraints, and indexes (conditional)

30)

Drop MRC schema (conditional) --it is no longer needed, it can be dropped.

31)

Back up the database (recommended)

32)

Enable maintanence mode

33)

Download and apply the AD Upgrade Patch for 12.2 (patch 10117518)(required) by following the patch read me.

34)

Apply all Consolidated Upgrade Patches (CUPs) (required)

--Apply the Consolidated Upgrade Patches (CUP) and all of the pre-install patches listed in the Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID: 1320300.1)

35)

Run the American English upgrade patch driver (required)

AutoPatch to run the (American English) upgrade patch driver (u10124646.drv) merged with latest Consolidated Upgrade Patch for Oracle E-Businees Suite Release 12.2 . Release 12.2 upgrade patch driver (u10124646.drv) is located under $AU_TOP/patch/115/driver on Run File System.

36)

Disable Maintenance Mode (required)

37)

Follow the instructions in Database Initialization Parameters for Oracle Applications Release 12 (Doc ID: 396009.1) and reset the init.ora parameters as needed.

38)

Backup the database and apps tier

39)

Review the recommended security processes documented in Best Practices for Securing Oracle Applications Release 12 (Doc ID: 403537.1)

40)

Configure Release 12.2 E-Business Suite instance (required)

-create appsutil using admkappsutil.pl

-copy appsutil to database tier.

-install jre on the database tier.

-create EBS/autocofig related directories in the database tier such as $ORACLE_HOME/network/admin/context_name

-create context file in the database tier using adbldxml.pl

-exec fnd_conc_clone.setup_clean to clean the fnd_nodes

-Synchronize values of APPLPTMP with UTL_FILE_DIR for PL/SQL based Concurrent Requests

-run autoconfig on db tier

-Run AutoConfig on the Apps Tier.

-Run Rapid Install to configure Release 12.2 E-Business Suite instance. (second time Rapid install run)

41)

Upgrade Add-on Localization products using note: Add-on Localizations - Upgrade Consideration (Doc ID: 1491965.1)

42)

Integrate custom objects and schemas (conditional).

follow the steps in Oracle E-Business Suite Developer's Guide to reintegrate these customizations with the APPS schema.

43)

Re-enable custom triggers, constraints, and indexes

44)

Enabling Online Patching

45)configure init.ora

The parameters described in this section apply to Oracle E-Business Suite Release 12.2. For details, refer to Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID: 396009.1).

46)

Apply the Latest AD and TXK for Release 12.2

47)

Apply the Latest Oracle E-Business Suite Release Update Pack for Release 12.2 --"12.2.5 at the moment"

48)

Reset ORACLE schema passwords (recommended)

49)

Reset ORACLE schema passwords (recommended)

50)

Verify completion of concurrent programs (recommended)

51)

Drop Obsoleted Product Schema (optional)

Obsolete Product Schemas that can be considered for dropping include:

ABM, AHM, AMF, AMW, BIL, BIV, BIX, BSC, CSS, CUE, CUF, CUI, CUN, CUP, CUS, DDD, EAA, EDWREP, EVM, FEM, FII, FPT,

FTP, GCS, HCC, IBA, IBP, IGF, IGS, IGW, IMT, IPD, ISC, ITA, JTS, ME, MST, OKB, OKI, OKO, OKR, OZP, OZS, PFT, POA,

PSB, RCM, RHX, RLA, VEH, XNC, XNI, XNM, XNS, ZFA, ZPB, ZSA.

52)

Drop dangling synonyms by using "sqlplus APPS/****@DB @$AD_TOP/sql/adzd_drop_synonyms.sql"

53)

Install online help (recommended)

54)

Apply latest product patches (required)

Determine the latest product-specific patches. Then, download the American English patches. You must apply the patches using AD Online Patching (adop).

Note: See Patch Wizard Main Page in Oracle E-Business Suite Maintenance Guide Release 12.2.

55)

Installing NLS upgrade patch driver and NLS Online Help (conditional) by requesting requesting a translation patch,

See Requesting Translation Synchronization Patches (Doc ID: 252422.1)

56)

Update and verify custom responsibilities (conditional)

57)

Grant flexfield value set access to specific users (required) by following: Flexfield Value Set Security chapter in Oracle E-Business Suite Flexfields Guide, Release 12.2 (Part No. E22963-07).

58)

Migrate custom development to new technologies (recommended)

Check for general custom development :Preparing Custom Development for Next Oracle Applications Release (Doc ID: 374398.1)

Check for mod_plsql custom development:Application Framework Developer's Guide (Doc ID: 1315485.1) f

59)

Migrate the CUSTOM library

Place a copy of the new CUSTOM library (CUSTOM.pll) in a safe place. It is located in the $AU_TOP/resource directory (UNIX), or the %AU_TOP%\resource directory (Windows). Then, make a copy of the old Oracle Forms CUSTOM library and place it in the new directory. Upgrade to Oracle Forms Developer 10g by regenerating the library. Or, you can cut and paste the existing custom code into the new library, and then regenerate it.

60)

Copy and re-customize modified scripts or reports (conditional)

Copy custom shell scripts or reports to the custom application directories and re-customize the copy as necessary.

61)

Copy existing custom start scripts (for example if you have customized concurrent manager start script in 11i earlier...)

62)

Review user responsibility assignments

Although user/responsibility assignments are preserved during the upgrade, the effective permissions granted by the seeded responsibilities, menus, functions, and report security groups may have change

63)

Configure applications client software for forms applet (required).

See:Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID: 393931.1)

64)

Associate organization names with custom Alert definitions

65)

Set operating unit mode for customizations (conditional)

66)

Update Status Monitor URLs (required)

67)

Do Product specific post upgrade tasks documented in : Preparing for the Upgrade secetion of "Oracle E-Business Suite Upgrade Guide Release 11i to 12.2 Part Number E48834-15" - https://docs.oracle.com/cd/E26401_01/doc.122/e48834/T527285T527359.htm

-Customer Relationship Management Tasks

-Financials and Procurement Tasks

-Human Resource Management (HRMS)

-Lease and Finance Management

-Projects tasks

-Public Sector Tasks

-Supply Chain Management Tasks

68)

Perform System Maintanence Tasks documented in : "Post-Upgrade Tasks section" of "Oracle E-Business Suite Upgrade Guide Release 11i to 12.2 Part Number E48834-15" - https://docs.oracle.com/cd/E26401_01/doc.122/e48834/T527285T527359.htm

69)

Implement New Product and Country-specific Functionality

70)

Back Up Oracle E-Business Suite