I think that all E-Business Suite DBAs know that they need to apply a number of interoperability patches when upgrading from one database release to another. These are documented in our Interoperability Upgrade Notes for a given EBS + database combination. For example, if you’re upgrading Oracle E-Business Suite Release 12 to the latest 11gR2 11.2.0.2 database, you’d apply the patches listed here:
However, I don’t think it’s as widely-known that there are two other classes of patches that you might need to apply. These are documented in the following two Notes:
What are E-Business Suite “recommended performance patches”? Oracle E-Business Suite Recommended Performance Patches (Note 244040.1) is written and maintained by our Applications Performance team. I’ve covered this team’s responsibilities previously, but to recap: this team is dedicated to optimizing the performance of the E-Business Suite. They perform all of our E-Business Suite benchmarks and high-volume scalability testing, and they work intensively with our largest E-Business Suite customers in fine-tuning E-Business Suite configurations. They’ve summarized all of their hard-won expertise about performance-related patches in a single document. A major part of this document covers database patches, but that’s not all. It also covers performance-related patches for:
Client tools
Applications Technology products and components
Financials products
Manufacturing and Supply Chain products
Human Resources products
Sales & Marketing products
This should be your first stop after upgrading your database or if you’re trying to nail down a troublesome database performance-related issue. I consider this mandatory reading for all E-Business Suite DBAs. Do you want to apply database Patch Set Updates? Our Server Technologies division began releasing quarterly database Patch Set Updates (PSU) in July 2009. Patch Set Updates include:
Field-tested fixes for critical technical issues that may affect a large number of customers
Critical Patch Update fixes
Database Patch Set Updates are optional for E-Business Suite users. If you choose to use them, database Patch Set Updates may safely be applied to Oracle E-Business Suite Release 11i and 12 environments. Patch Set Updates are fully compatible and supported for use with the E-Business Suite. Depending upon the database version and Oracle E-Business Suite release, one or more overlay patches may be required to address conflicts with a specific Oracle Database Patch Set Update. Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1) 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. If you use PSUs with your EBS database, you should review this Note on a regular basis. Related Articles
Steven leads OCI Multicloud Landing Zones. He is a product manager and solution architect with diverse experience as an Enterprise Architect, Database/Integration Architect and CRM Programme Lead across financial, healthcare and sport industries. He was a Global Cloud Solution Architect in Microsoft before joining Oracle, focusing on digital innovation.
