This post walks you through the preinstall patches that you’ll need to prepare to upgrade to R12.2.0. Here’s a list of important My Oracle Support Notes associated with this post:
■Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes Doc ID 1594274.1
■R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] Doc ID 1448102.2
■Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap Doc ID 1934915.1
■Oracle E-Business Suite Release Notes, Release 12.2 Doc ID 1320300.1
For instructions on applying Oracle E-Business Suite Consolidated Upgrade Patch 6 (CUP6) for Release 12.2 (patch 19796566:12.2.0), refer to step, ‘Apply all Consolidated Upgrade Patches (CUPs)’, in Chapter 3, Section 10 of the Oracle E-Business Suite Upgrade Guide, Release 12.0 and 12.1 to 12.2, Part No. E48839-09. Also refer to My Oracle Support Knowledge Document 1320300.1, for more current details and the README.txt from patch 19796566. All downloads for patch 19796566 – 418, as of Feb 8 2016. When the Upgrade Guide says to apply the Consolidated Upgrade Patch (CUP) for Release 12.2.0 (Patch 18007406:12.2.0) in pre-installation mode on the Run Edition File System, please apply patch 19796566.
In section 3.1 of My Oracle Support Knowledge Document 1320300.1, it says:
“Prerequisite: Apply the AD Upgrade Patch for Release 12.2 (Patch 10117518) by merging it with the latest Consolidated Upgrade Patch (CUP) for AD (Patch 19796564:R12.AD.C).
- The AD Upgrade Patch for Release 12.2 (Patch 10117518) readme contains information about the latest Consolidated Upgrade Patch (CUP) for AD (Patch 19796564:R12.AD.C).
You must follow the Patch 10117518 readme and apply it by merging it with the latest Consolidated Upgrade Patch for AD, along with any other patches mentioned in the Readme, as instructed in the readme and by referring to the Upgrade Guides.
2. Apply the Consolidated Upgrade Patch (CUP) for Release 12.2.0 (Patch 19796566) in pre-installation mode on the Run Edition File System.”
Use adpatch preinstall=y, to apply Patch 19796566.
3. Apply the patches that you need from MOS Note 1448102.2. Below in this post is an example of patches we needed.
Note: Before applying the latest CUP in pre-installation mode: If you have applied any other patch previously in pre-installation mode and do not intend to merge it with 12.2.0 upgrade driver u10124646.drv, clean up the directory <APPL_TOP>/admin/<TWO_TASK>/preinstall on run file system after taking the backup of the current directory.
4. Merge the patch drivers in $APPL_TOP/admin/$TWO_TASK/preinstall directory with the 12.2.0 upgrade driver $AU_TOP/patch/115/driver/u10124646.drv:
All of the patch driver files located under $APPL_TOP/admin/<TWO_TASK>/preinstall are merged with the 12.2.0 upgrade driver <AU_TOP>/patch/115/driver/u10124646.drv. Therefore, carefully evaluate the content of the directory – <APPL_TOP>/admin/<TWO_TASK>/preinstall and retain only those patch drivers including u19796566.drv ; it is intended to be merged with 12.2.0 upgrade driver – u10124646.drv.
Merge the patch drivers in run file system’s <APPL_TOP>/admin/<TWO_TASK>/preinstall with <AU_TOP>/patch/115/driver/u10124646.drv:
- Change directory to <AU_TOP>/patch/115/driver
$ cd $AU_TOP/patch/115/driver
$ admrgpch -d . -preinstall -master u10124646.drv5. Apply the newly merged 12.2.0 upgrade driver (For example, – <AU_TOP>/patch/115/driver/u_merged.drv) with the command:
adpatch options=nocopyportion,nogenerateportion
You don’t need the copy portion or the generate portion because you installed the upgrade file system and this copied all the files and they were all ready generated.
Note:
- If you are upgrading your E-Business Suite environment from Release 12.0.4 or Release 12.0.6, then you must apply the following AD patch as the very last patch on the Application Tier, before upgrading to 12.2.0.
- Patch 11939659:R12.AD.A
- Important: If there are any other patches to be applied on your E-Business Suite Release 12.0.4 or Release 12.0.6 environment, then you must complete those patches and then apply AD patch 11939659:R12.AD.A.
An example of applying the preinstall patches from MOS Note 1448102.2
The upgrade file system for 12.2.0 is created once. When bugs are found, they are fixed by applying pre-install patches to the upgrade file system, including the Consolidated Upgrade Patch, 19796566 and patches from MOS Note 1448102.2.
Preinstall patches, including the CUP, can optionally be merged together in a single patch and driver to ease installation. Oracle Support has provided a wget* shell script, which can be used to download the entire set of preinstall patches, including the latest CUP, directly to your server from My Oracle Support. See the “Downloading Patches Using wget.sh” section of this document.
*Requires the gnu wget utility
Introduction to the 12.2 Oracle E-Business Suite Preinstall Patches Report
Installing the Oracle E-Business Suite Preinstall Patches Report
- Download the appropriate preinstall report for your upgrade to a local folder
- Unzip the file, extracting the entire contents, which creates the “EBS_12.2_Preinstall” folder
- Navigate to the “EBS_12.2_Preinstall” folder, open “index.html” in a browser
- Please note that renaming or modifying any files in the report may break the report
Download the Latest 12.2 Preinstall Patch Report: EBS_R12.2_Preinstall_2015_Dec_21.zip
The following is a summary from the 12.2 Preinstall Patch Report, SUMMARY_EBS.html:
| ATG | Upgrade script failure | Data corruption | Performance issue | Upgrade integrity fix | TOTAL |
|---|---|---|---|---|---|
| FND | 1 | – | – | 1 | 2 |
| TOTAL | 1 | 0 | 0 | 1 | 2 |
| FIN | Upgrade script failure | Data corruption | Performance issue | Upgrade integrity fix | TOTAL |
|---|---|---|---|---|---|
| AP | – | 1 | – | – | 1 |
| JAI | 2 | – | – | – | 2 |
| JE | 2 | 1 | – | – | 3 |
| XLE | 1 | – | – | – | 1 |
| ZX | – | 2 | 1 | – | 3 |
| TOTAL | 5 | 4 | 1 | 0 | 10 |
| CRM | Upgrade script failure | Data corruption | Performance issue | Upgrade integrity fix | TOTAL |
|---|---|---|---|---|---|
| DPP | 1 | – | – | – | 1 |
| OZF | – | 1 | – | – | 1 |
| TOTAL | 1 | 1 | 0 | 0 | 2 |
Apply the pre-upgrade patches that were released after the Consolidated Upgrade Patch 19796566:12.2.0. Refer to My Oracle Support Knowledge Document 1448102.2 for the Oracle E-Business Suite Release 12.2 Pre-install Patches Report; it provides a list of essential patches that you must apply in pre-install mode before upgrading from Release 11i/12.0/12.1 to Release 12.2. Follow the recommendations within My Oracle Support Knowledge Document 1448102.2 and apply the additional pre-install patches.
The following is from the EBS.html file, from the 12.2 Preinstall Patch Report:
| Upgrade script failure – EBS |
|---|
| SL.NO | PRODUCT | PATCH | RELEASED_DATE | PATCH_ABSTRACT | |
| 01 | JAI | 20526934 | 2015-03-13 | QRE1225.3:FIN:JA.SQL:SKIPPED JOB: B17042034_SEC_MAP.SQL ON JAJAI_TDS_SECTION_M | |
| 02 | JAI | 20160778 | 2015-04-02 | FWDPORT:13705714:PATCH 13532321 IS ERRORING OUT | |
| 03 | FND | 21632403 | 2015-08-14 | QRE1225.10:FND:CP: FND_CONC_CLONE.SETUP_CLEAN FAILURE AT 12.2.0 LEVEL | |
| 04 | XLE | 21107018 | 2015-06-24 | 11I2R12 UPG: XLEUPG01.SQL FAILED DURING R12.2.0 UPGRADE | |
| 05 | DPP | 22246031 | 2015-12-14 | QREP1225RP.1:DPP.DPPMOACA.SQL FAILED DURING 11IMBL->12.2.0 UPGRADE | |
| 06 | JE | 22268101 | 2015-12-08 | INVALID JG_ZZ_AUDIT_AP_PKG | |
| 07 | JE | 22007691 | 2015-11-11 | ADZDPCUST.SQL INCORRECT COLUMN NAME FOR JE TABLES |
| Data corruption – EBS |
|---|
| SL.NO | PRODUCT | PATCH | RELEASED_DATE | PATCH_ABSTRACT | |
| 01 | AP | 19971946 | 2015-09-11 | RCA: AP_PAYMENT_HISTORY_ALL.RELATED_EVENT_ID IS NULL FOR 11I UPG PAY CR EVENT | |
| 02 | ZX | 21224981 | 2015-07-01 | TAX RATE DESCRIPTION NOT POPULATED DURING MIGRATION TO 12.2 | |
| 03 | JE | 21183729 | 2015-10-09 | ROOT CAUSE BUG FOR BUG#20912379 TO NULLIFY THE GLOBAL_ATTRIBUTE1 | |
| 04 | ZX | 21512930 | 2015-08-19 | DATA TYPE OF TAX REPORTING TYPE CODE EMEA VAT REPORTING TYPE NOT VISIBLE IN UI | |
| 05 | OZF | 21248593 | 2015-07-29 | Migration scripts creating duplicate data in ozf_object_fund_summary table |
| Performance issue – EBS |
|---|
| SL.NO | PRODUCT | PATCH | RELEASED_DATE | PATCH_ABSTRACT | |
| 01 | ZX | 20971794 | 2015-06-11 | ZXPOTRXMIGUPD.SQL RUNS FOR UP TO 30 HOURS DURING UPGRADE FROM 11I |
| Upgrade integrity fix – EBS |
|---|
| SL.NO | PRODUCT | PATCH | RELEASED_DATE | PATCH_ABSTRACT | |
| 01 | FND | 22227761 | 2015-12-08 | QRE1225RP1225.1:FND: INVALID FND_FLEX_SERVER CAUSING FAILURES (12.1.3RPC4->12.2) |
We used the patches in BOLD.
You don’t need to apply pre-install patches for modules you don’t use or that aren’t set up. The patches you use for your instance will depend on which modules you use.