Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
My Oracle Support Note: 1147107.1
Updated: April 24, 2013
Oracle Database Patch Set Updates may be safely applied to Oracle E-Business Suite Release 11i and 12 databases. The overlay patch that resolves the conflict will be against the specific sub-patch that is conflicting. Please see below note to help you determine which version of the overlay patch to uptake.
This note summarizes the latest overlay patches required when applying Database Patch Set Updates to Oracle E-Business Suite environments running on the 10gR2, 11gR1, and 11gR2 databases.
For an explanation of prerequisite/overlay patches (including patch conflict resolution), see Document 854428.1 Patch Set Updates for Oracle Products. If you encounter conflicts with other patches, refer to the PSU README for instructions.
You should look through the entire table to pick the overlay patch to apply. The version of the overlay patch should match with the version of the sub-patch with which the one-off conflicts. For example, when opatch reports that patch 13931044 conflicts with the composite patch 16619892 (specifically, sub-patch(es) 14727310), you should apply overlay patch 13931044 version 11.2.0.3.5 which is the same version as 14727310.
However, If multiple sub-patches are reported conflicting with an one-off patch, then you only need to apply the version of the overlay patch that matches with the highest version of the sub-patches listed.
Sections in this Document
1 Database Patch Set Updates and Overlay Patch Lists for EBS R12.2
Table 1 Release 11.2.0.4
Table 2 Release 11.2.0.3
2 Database Patch Set Updates and Overlay Patch Lists for EBS 11i and R12.1
Table 3 Release 12.1.0.1
Table 4 Release 11.2.0.3
Table 5 Release 11.2.0.2
Table 6 Release 11.2.0.1
Table 7 Release 11.1.0.7
Table 8 Release 10.2.0.5
Table 9 Release 10.2.0.4
3 Known Issues
4 References
5 Documentation Accessibility
1 Database Patch Set Updates and Overlay Patch Lists for EBS R12.2
This section lists the available Patch Set Updates for Oracle Database releases, and the list of overlay patches required for each PSU if the database is used by the Oracle E-Business Suite Release 11i or 12.
Table 2 Release 11.2.0.3 PSUs and Patch Lists for EBS r12.2
Please contact support for overlay patches that you would need to fulfill the E-Business Suite 12.2 requirement.
Patches To Be Rollback
The following patches can be safely rollback if you had applied them previously and encounter a conflict with PSU:
14598522 14832335 16819180 15967134 17312755 14649883 16163946 17461865 16702016 14153501 17061955 16615757 16091608 15831148 16601228 17599310 17995125 15860295 16388959 16660077 17082713 18008565 18050488 17032681 16587934 18447575 17502060 18348472 17388238 18049588 18124963
2 Database Patch Set Updates and Overlay Patch Lists for EBS 11i and R12.1
Table 3 Release 12.1.0.1 PSUs and Patch lists for EBS r11i or r12.1
| Patch List | Resolve Conflict With | Required Minimum Version of PSU |
|---|---|---|
| 16707791 | 12.1.0.1.1 | |
| 16913149 | 12.1.0.1.3 | |
| Patch 17267114 | 17429137 | 12.1.0.1.3 |
Table 4 Release 11.2.0.3 PSUs and Patch Lists for EBS r11i or r12.1
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| No conflict resolution overlay patches required. | 11.2.0.3.9 | |
| No conflict resolution overlay patches required. | 11.2.0.3.8 | |
| Patch 13004894 | prior release of 13004894 | 11.2.0.3.7 |
| No conflict resolution overlay patches required. | 11.2.0.3.6 | |
| Patch 13004894 | prior release of 13004894 | 11.2.0.3.5 |
| No conflict resolution overlay patches required. | 11.2.0.3.4 | |
| Patch 13004894 | prior release of 13004894 | 11.2.0.3.3 |
| No conflict resolution overlay patches required. | 11.2.0.3.2 | |
| No conflict resolution overlay patches required. | 11.2.0.3.1 | |
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| No conflict resolution overlay patches required. | 11.2.0.2.1 - 11.2.0.2.9 * |
Table 6 Release 11.2.0.1 PSUs and Patch Lists for EBS r11i or r12.1
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| No conflict resolution overlay patches required. | 11.2.0.1.7 * | |
| No conflict resolution overlay patches required. | 11.2.0.1.6 | |
| Patch 12354121 | Patch 11066602, Patch 10195726, and Patch 9657344 | 11.2.0.1.5 |
| Patch 11064298 | Patch 10195726, Patch 9657344 | 11.2.0.1.4 |
| Patch 11064457 | Patch 10177373, Patch 9756939 | |
| Patch 9318214 | ||
| Patch 8328200 | 9554727 | |
| Patch 10195726 | 9657344 | 11.2.0.1.3 |
| Patch 10177373 | 9756939 | |
| Patch 9318214 | ||
| Patch 8328200 | 9554727 | |
Table 7 Release 11.1.0.7 PSUs and Patch Lists for EBS r11i or r12.1
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| Patch 18486395 | Patch 18032084, Patch 17547328, Patch 16610857, Patch 16100279, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.19 |
| Patch 18032260 | 9304416 | |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 18032084 | Patch 17547328, Patch 16610857, Patch 16100279, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.18 |
| Patch 18032260 | 9304416 | |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 17547328 | Patch 17060085, Patch 16610857, Patch 16100279, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.17 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 17060085 | Patch 16610857, Patch 16610857, Patch 16100279, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.16 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 16610857 | Patch 16100279, Patch 16100279, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.15 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 16100279 | Patch 14768771, Patch 14768771, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.14 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 14768771 | Patch 14251810, Patch 14251810, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.13 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 14251810 | Patch 14044221, Patch 14044221, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.12 |
| Patch 8405205 | ||
| Patch 8357541 | Patch 8405205 together with Patch 8357541 Patch 13929969, Patch 13550617, Patch 13045196, Patch 12736222, Patch 12342073, Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 14044221 | Patch 13547419, Patch 13547419, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.11 |
| Patch 13929969 | Patch 13550617, Patch 13045196 , Patch 12736222 , Patch 12342073 , Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 13547419 | Patch 13080483, Patch 13080483, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.10 |
| Patch 13550617 | Patch 13045196 , Patch 12736222 , Patch 12342073 , Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 13080483 | Patch 12773469, Patch 12773469, Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.9 |
| Patch 13045196 | Patch 12736222, Patch 12342073 , Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 12773469 | Patch 12363299, Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.8 |
| Patch 12736222 | Patch 12342073 , Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 12363299 | Patch 11661368, Patch 10214325, Patch 9902746, and Patch 9743057 | 11.1.0.7.7 |
| Patch 12342073 | Patch 11064257, Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 11661368 | Patch 10214325,Patch 9902746, and Patch 9743057 | 11.1.0.7.6 |
| Patch 11064257 | Patch 10167367, Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 8328200 | Patch 9554727 | |
| Patch 10171643 | Patch 9902746 and Patch 9743057 | 11.1.0.7.5 |
| Patch 10167367 | Patch 9879205, Patch 9557940, and Patch 8940108 | |
| Patch 8328200 | Patch 9554727 | |
| Patch 7295298 | ||
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 9902746 | Patch 9743057 | 11.1.0.7.4 |
| Patch 9879205 | Patch 9557940 and with Patch 8940108 | |
| Patch 8328200 | Patch 9554727 | |
| Patch 7295298 | ||
| Patch 7111245 | ||
| Patch 7000281 | ||
| Patch 9571658 | Patch 9026927 | 11.1.0.7.3 |
| Patch 9557940 | Patch 8940108 | |
| Patch 7295298 | ||
| Patch 7111245 | ||
Table 8 Release 10.2.0.5 PSUs and Patch Lists for EBS r11i or r12.1
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| No conflict resolution overlay patches required. | 10.2.0.5.2 - 10.2.0.5.10 * |
Table 9 Release 10.2.0.4 PSUs and Patch Lists for EBS r11i or r12.1
| Patch List | Resolves Conflict With | Required Minimum Version of PSU |
|---|---|---|
| No conflict resolution overlay patches required. | 10.2.0.4.7 - 10.2.0.4.15 * | |
| Patch 7014646 | 10.2.0.4.4 | |
3 Known Issues
This section describes any known issues and their resolutions or workarounds.
ISSUE 1:
Bug 16809226 - Applying the database bundle patch (16342486) by following My Oracle Support Knowledge Document 1349240.1, Database Preparation Guidelines for an Oracle E-Business Suite 12.2 Upgrade results in conflicts.
Solution: Download the latest version of opatch (available in patch 6880880), and review the steps below for conflict resolution.
There are two possible scenarios here.
Scenario 1 - If you encounter conflicts when applying the PSU following application of the database bundle patch, please follow the steps below (using 11.2.0.3.9 PSU as an example):
- Rollback 13146719, 13040331 , 13004894 ,13259364 , 14649883, and 16040940 which are all under 16342486
- Apply the PSU patch (which is 11.2.0.3.9 PSU in this example)
- Apply these overlay patches:
13146719 version 11.2.0.3.8 (to obtain the fixes from 13146719)
13040331 version 11.2.0.3.8 (to obtain the fixes from 13040331 )
13004894 version 11.2.0.3.9 (to obtain the fixes from 13004894 )
13259364 version 11.2.0.3.7 (to obtain the fixes from 13259364 )
17991432 version 11.2.0.3.9 (to obtain the fixes from 16040940)
18092402 version 11.2.0.3.9 (to obtain the fixes from 14649883)
Scenario 2 - If you have previously applied a PSU and encounter conflicts when applying the database bundle patch, follow the steps below (using 11.2.0.3.9 PSU as an example):
- Run %opatch napply –id 12965899,13023632,12949905,12985184,13366268,12949919,13477790,13388104,13495307,13808632,13258936,4247037,14005749,14013094,12955701,14237793,14296972,14698700,12951696
- Apply overlay patches below:
13146719 version 11.2.0.3.8 (to obtain the fixes from 13146719)
13040331 version 11.2.0.3.8 (to obtain the fixes from 13040331 )
13004894 version 11.2.0.3.9 (to obtain the fixes from 13004894 )
13259364 version 11.2.0.3.7 (to obtain the fixes from 13259364 )
18092402 version 11.2.0.3.9 (to obtain the fixes from 14649883)
17991432 version 11.2.0.3.9 (to obtain the fixes from 16040940)
ISSUE 2:
BUG 13800125 - Running the opatch CheckConflictAgainstOHWithDetail command does not return which sub-patch of a Composite Patch is associated to the conflict. For example, 11840910 is installed and conflicts with sub-patch 13343438:
Following patches have conflicts. Please contact Oracle Support and get the
merged patch of the patches :
11840910, 13696216
Following patches will be rolled back from Oracle Home on application of the
patches in the given list :
11840910
Conflicts/Supersets for each patch are:
Patch : 13696216
Conflict with 11840910
Conflict details:
<ORACLE_HOME>/lib/libserver11.a:/kta.o
5 Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/us/corporate/accessibility/index.html.
Access to Oracle Support
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.
Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
Copyright © 2006, 2013, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark licensed through X/Open Company, Ltd.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
扫一扫
1572
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
