X

The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Recent Posts

EBS 12.2

New OA Framework 12.2.9 Bundle 5 Now Available

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.9 and cannot be applied to any other EBS release. What's available now? The latest OAF update for Oracle E-Business Suite Release 12.2.9 is now available. All Oracle E-Business Suite Release 12.2.9 users should apply this patch. Future OAF patches for EBS Release 12.2.9 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.9 Bundle 5 (Patch 31829822:R12.FWK.C) What's new in this update? As well as all the fixes that were released in previous Release 12.2.9 bundle patches, this latest patch also includes fixes for the following issues: Following creation of an Oracle Web Applications Desktop Integrator document, a script error occurs if the user selects a beveled column heading in a LOV table for sorting. When a submit action is performed on a page with a table that has more than 100 columns, the global header Home link/icon is displayed under the username popup menu. If a user navigates using the Personalize Region link when the Personalization Workbench UI is disabled, the Personalization Workbench button is still displayed on Personalize Region page. You can also refer to the Readme for Patch 31829822 for additional information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) References Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) OA Framework: How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (MOS Note 416708.1) Oracle Application Framework Developer's Guide (MOS Note 1315485.1) Related Articles New OA Framework 12.2.9 Bundle 4 Now Available New OA Framework 12.2.9 Bundle 3 Now Available New OA Framework 12.2.9 Bundle 2 Now Available New OA Framework 12.2.9 Bundle 2 Now Available New OA Framework 12.2.9 Bundle 1 Now Available OA Framework Post-12.2.9 Consolidated Patch Now Available Webcast: Oracle E-Business Suite Modern User Interface with Rich Personalizations (Updated Oct 2019) New JDeveloper Patch for EBS 12.2.9 OA Framework

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Database Tier

Oracle Database 19c Now Certified with EBS 12.2 and 12.1 for Oracle Solaris on x86-64

Oracle E-Business Suite Release 12.2 (12.2.3 and later) and 12.1.3 are now certified with Oracle Database 19c on Oracle on Solaris x86-64 as a database tier only platform. The Database 19c certified operating systems for this platform are Solaris 11.3 and 11.4. What is a Database Tier Only Platform Certification? E-Business Suite certified platforms are platforms for which both the application and database tiers of E-Business Suite are supported and for which EBS provides a release package (i.e., Rapid Install). The term E-Business Suite certified platform is synonymous with fully certified platform or Rapid Install supported platform. A database tier only platform (also known as a split tier configuration) certification is an EBS database certification on a platform for which there is a database release but no corresponding EBS release package. In this case, the application tier runs on a different fully certified platform from the database tier only platform. For a complete list of certified platforms, refer to My Oracle Support's certification tab. References For more information, please review the following documentation: Oracle Database Installation Guide 19c for Solaris Using Oracle E-Business Suite Release 12.2 with a Database Tier Only Platform on Oracle 19c (MOS Note 2615883.1) Using Oracle E-Business Suite Release 12.1 with a Database Tier Only Platform on Oracle 19c (MOS Note 2640496.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Updated: Oracle Database 19c Certified with EBS 12.2 Updated: Oracle Database 19c Certified with EBS 12.1.3 New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Oracle E-Business Suite Technology Blog - Database Tier Announcements

Oracle E-Business Suite Release 12.2 (12.2.3 and later) and 12.1.3 are now certified with Oracle Database 19c on Oracle on Solaris x86-64 as a database tier only platform. The Database 19c certified...

Application Tier

October 2020 Updates to EBS Technology Codelevel Checker (ETCC)

The E-Business Suite Technology Codelevel Checker (ETCC) utility identifies patches that need to be applied to your Oracle E-Business Suite 12.2 technology stack for the application and database tiers. The ETCC tool was designed to be self-documenting; however, you can read about it in the following document: Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (MOS Note 1594274.1) What’s New ETCC has been updated to include bug fixes and patching combinations for the following recommended versions: Database Oracle Database Release Update RU 19.9.0.0.201020 Oracle JavaVM Component Database RU 19.9.0.0.201020 Oracle Database Proactive BP 12.1.0.2.201020 Oracle Database PSU 12.1.0.2.201020 Oracle JavaVM Component Database PSU 12.1.0.2.201020 Oracle Database Patch for Exadata BP 11.2.0.4.201020 Oracle Database PSU 11.2.0.4.201020 Oracle JavaVM Component Database PSU 11.2.0.4.201020 Microsoft Windows Database BP 19.7.0.0.200414 Microsoft Windows Database BP 12.1.0.2.200114 Oracle JavaVM Component 12.1.0.2.200114 on Windows Microsoft Windows Database BP 11.2.0.4.180417 Oracle JavaVM Component 11.2.0.4.180417 on Windows Fusion Middleware WebLogic Patch Set Update 10.3.6.0.201020 Oracle Fusion Middleware 11.1.1.9 Forms and Reports 10.1.2.3.2 Obtaining ETCC We recommend using the latest version of ETCC, as new bugfixes will not be checked by prior versions of the utility. The latest version of the ETCC tool can always be downloaded via Patch 17537119 from My Oracle Support. References Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (MOS Note 1594274.1) Previous Oracle Database 19c Release Update Database Patch Lists for Oracle E-Business Suite (MOS Note 2683670.1) Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (MOS Note 1147107.1) Database Patches Required by Oracle E-Business Suite on Oracle Engineered Systems: Exadata Database Machines and SuperClusters (MOS Note 1392527.1) Related Articles Identifying Missing App Tier and Database Tier Patches for EBS 12.2 ETCC Tool Enhanced for Finding Mandatory EBS 12.2 Patches July 2020 Updates to EBS Technology Codelevel Checker (ETCC)

The E-Business Suite Technology Codelevel Checker (ETCC) utility identifies patches that need to be applied to your Oracle E-Business Suite 12.2 technology stack for the application and database...

Application Tier

Prebuilt EBS 12.1 and 12.2 SOA Integrations Now Certified with Oracle SOA Suite 12.2.1.4

Oracle SOA Suite is a comprehensive software suite from Oracle Fusion Middleware that lets you to build, deploy, and manage integrations using Service Oriented Architecture (SOA). Oracle BPEL Process Manager in Oracle SOA Suite, provides a standards-based solution to assemble a set of discrete services into an end-to-end business process flow. While you can build SOA integrations with Oracle E-Business Suite and other applications, there are a set of prebuilt SOA integrations from Oracle E-Business Suite. For more information about the differences between the custom SOA integrations and prebuilt SOA integrations with EBS, see this previously-published certification announcement. In addition to these prebuilt integrations, Oracle E-Business Suite Integrated SOA Gateway uses Oracle SOA Suite for SOAP based web services in EBS R12.2. This announcement is about prebuilt SOA integrations with EBS. Prebuilt BPEL Business Processes The prebuilt BPEL business processes in Oracle E-Business Suite Release 12.1 and 12.2 include the following: Oracle Price Protection (DPP) Oracle Transportation Management: Oracle Warehouse Management (WMS) Oracle Transportation Management: Oracle Shipping Execution (WSH) Oracle Transportation Management: Oracle Purchasing (PO) Complex Maintenance, Repair & Overhaul (CMRO/AHL)   These prebuilt BPEL processes have now been certified with Oracle BPEL Process Manager in Oracle SOA Suite 12.2.1.4 for Oracle E-Business Suite Release 12.1 and Release 12.2. Getting Support If you need support for the prebuilt EBS BPEL business processes, you can log a Service Request against the Applications Technology Group product family in My Oracle Support. References Integrating Oracle E-Business Suite Release 12.2 with Oracle BPEL in Oracle SOA Suite 12c (MOS Note 1951625.1) Integrating Oracle E-Business Suite Release 12.1.3 with Oracle BPEL in Oracle SOA Suite 12c (MOS Note 2131202.1) Oracle SOA Suite 12c Release 12.2.1 Documentation Related Articles BPEL 12.2.1.3 Certified for Prebuilt EBS 12.1 SOA Integrations BPEL 12.2.1.2 Certified for Prebuilt EBS 12.1 and 12.2 SOA Integrations

Oracle SOA Suite is a comprehensive software suite from Oracle Fusion Middleware that lets you to build, deploy, and manage integrations using Service Oriented Architecture (SOA). Oracle BPEL Process...

Certifications

Data Masking Now Certified for EBS 12.1.3 with DB 12.1.0.2 or 11.2.0.4 and EM 13cR4

We're pleased to announce the certification of the EBS 12.1.3 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4.  The updated template included with this certification contains bug fixes and an optional post-masking script.  The optional post-masking script provides synchronization between FND and HR user data. The updated template is certified with EM 13cR4 and prior releases of EM 13c per the documented guidelines.   You can use the Oracle Data Masking and Subsetting Pack with Oracle Enterprise Manager Cloud Control 13c (EM 13c) to mask sensitive data in cloned (non-production) EBS 12.1.3 environments. To use EM 13c to mask data in a cloned EBS 12.1.3 environment with Database 12.1.0.2 or 11.2.0.4, use the following instructions and template:    Using Oracle E-Business Suite Release 12.1.3 Data Masking Template with Oracle Database 11gR2 or 12cR1 and Oracle Enterprise Manager Cloud Control 13c (MOS Note 2216575.1 ) EBS 12.1.3 DATA MASKING PACK FOR EM 13C - V1.1.13 (Patch 31645549) What does masking do in an EBS environment? Due to data dependencies, scrambling E-Business Suite data is a non-trivial task.  The data needs to be scrubbed in such a way that allows the application to continue to function.   Based upon the Oracle E-Business Suite architecture and sensitive columns, application data masking with the certified EBS Data Masking Template does the following: De-identifies the data:  Scrambles identifiers of individuals, also known as personally identifiable information (PII).  Examples include information such as name, account, and address. Masks sensitive data:  Masks data that, if associated with PII, would cause privacy concerns.  Examples include compensation, health and employment information.   Maintains data validity:  Provides a functional application. References Using Oracle E-Business Suite Release 12.1.3 Data Masking Template with Oracle Database 11gR2 or 12cR1 and Oracle Enterprise Manager Cloud Control 13c (MOS Note 2216575.1 ) Related Articles EBS 12.1 Data Masking Template Certified with EM 13c Updated: Oracle Database 19c Certified with EBS 12.1.3 Data Masking Certified for EBS 12.1.3 and Database 19c with EM 13cR4 Sep 2020 Updates to the EBS 12.2 Data Masking Template for Database 19c with EM 13c Oracle Application Management Pack Release 13.1.1.1.0 Now Certified with Oracle Database 19c Oracle Application Management Pack Release 13.4.1.0.0 is Now Available Oracle Enterprise Manager 13.4 is now available for download Oracle E-Business Suite Technology Blog - Database Masking Announcements

We're pleased to announce the certification of the EBS 12.1.3 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4.  The updated template included with this certification...

Client Tier

JRE 1.7.0_281 Certified with EBS Releases 12.2 and 12.1

The Java Runtime Environment 1.7.0_281 (7u281) on the JRE 7 codeline is now certified with Oracle E-Business Suite Releases 12.2 and 12.1. Note that Oracle strongly recommends that you migrate to JRE 8 using Java Web Start now.  As JRE 7 has reached end of life, this release is not available through the usual public download sites.  This update is available for Oracle E-Business Suite customers during the extended support period of your EBS release from My Oracle Support as Patch 31856327. You should only apply this update if you have a dependency on using JRE 7. This article answers some questions you may have on the subject. Should I apply this JRE 7 update? If you have a client tier that can only run JRE 7,  you must use Java Deployment Technology from JRE 8 to launch JRE 7. This is a requirement because JRE updates since JRE 1.7.0_161 have not included Java Deployment Technology. To stay current with critical fixes provided by the Java team, you should uptake the latest JRE 7 update, as well as the latest JRE 8 update. Additional guidance on such scenarios can be found in our recently published My Oracle Support note, FAQ: Essentials of Java Usage in Oracle E-Business Suite (MOS Note 2510500.1). How do I get support adopting this latest Java CPU? If you are using Java Web Start and require assistance with applying this CPU, you can log a service request for assistance from the Java Support organization. For those of you still in transition to Java Web Start, refer to the following in our recently published My Oracle Support note, FAQ: Essentials of Java Usage in Oracle E-Business Suite (MOS Note 2510500.1): Question 4: My organization is transitioning our Oracle E-Business Suite environments to Java Web Start. What if we encounter any issues with the Java Plug-in during this period? Where are the JRE 7 requirements for EBS documented? Full requirements for using Oracle E-Business Suite Releases 12.2 and 12.1 with JRE 7 are listed in the following documents: Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (MOS Note 393931.1) Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (MOS Note 437878.1) References FAQ: Essentials of Java Usage in Oracle E-Business Suite (MOS Note 2510500.1) Using Java Web Start with Oracle E-Business Suite (MOS Note 2188898.1) Upgrading JRE Plugin with Oracle Applications R12 (MOS Note 393931.1) Recommended Browsers for Oracle Applications 12 (MOS Note 389422.1) Related Articles JRE 1.8.0_271 Certified with EBS 12.2 and 12.1 Important New FAQ for Java Usage in EBS Migrate to Java Web Start from Java Plug-In Now Availability of Multiple EBS Forms Sessions with Java Web Start MS16-104 Security Update for IE Breaks EBS JRE Download

The Java Runtime Environment 1.7.0_281 (7u281) on the JRE 7 codeline is now certified with Oracle E-Business Suite Releases 12.2 and 12.1. Note that Oracle strongly recommends that you migrate to JRE...

Client Tier

JRE 1.8.0_271 Certified with EBS Releases 12.2 and 12.1

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_271 (8u271) on the JRE 8 codeline is now certified with Oracle E-Business Suite Releases 12.1 and 12.2.  This update is available with Patch 31856308.  This article answers some questions you may have on the subject. Is it a requirement to use Java Web Start with this JRE update? While it is not a prerequisite to use Java Web Start for this latest Java CPU, please take another note of our previous guidance about moving to Java Web Start right away, and particularly ahead of September 2020.   You should uptake this latest Java CPU regardless of whether you are currently using Java Web Start or Java Plug-in on your client tier. Note:  September 2020 was an important deadline for you if you are still using the Java Plug-in. Oracle Java team's plans to continue shipping the components required to launch Java applets on Internet Explorer 11 using Java Plug-in, and Oracle E-Business Suite Support team's ability to help customers still using Java Plugin are confirmed only through September 2020. Beyond this date, it will be increasingly complicated to receive any new fixes for Oracle E-Business Suite issues specific to Java Plug-in. How do I get support adopting this latest Java CPU? If you are using Java Web Start and require assistance with applying this CPU, you can log a service request for assistance from the Java Support organization. For those of you still in transition to Java Web Start, refer to the following in our recently published My Oracle Support note, FAQ: Essentials of Java Usage in Oracle E-Business Suite (MOS Note 2510500.1): Question 4: My organization is transitioning our Oracle E-Business Suite environments to Java Web Start. What if we encounter any issues with the Java Plug-in during this period? Where are the JRE 8 requirements for EBS documented? Full requirements for using Oracle E-Business Suite Releases 12.2 and 12.1 with JRE 8 are listed in the following documents: Using Java Web Start with Oracle E-Business Suite (MOS Note 2188898.1) Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (MOS Note 393931.1) Are there special considerations for running JRE 8 on Mac? JRE 8 can be used with Oracle E-Business Suite 12.2 and 12.1 on Mac. To see a list of browsers and JRE versions certified on different macOS versions, refer to: Oracle E-Business Suite Release Notes Release 12 for macOS (OS X) (MOS Note 1533334.1) References FAQ: Essentials of Java Usage in Oracle E-Business Suite (MOS Note 2510500.1) Using Java Web Start with Oracle E-Business Suite (MOS Note 2188898.1) Upgrading JRE Plugin with Oracle Applications R12 (MOS Note 393931.1) Recommended Browsers for Oracle Applications 12 (MOS Note 389422.1) Oracle E-Business Suite Release Notes Release 12 for macOS (OS X) (MOS Note 1533334.1) Related Articles Important New FAQ for Java Usage in EBS Getting Support for Java Plug-In While Transitioning to Java Web Start Migrate to Java Web Start from Java Plug-In Now Availability of Multiple EBS Forms Sessions with Java Web Start MS16-104 Security Update for IE Breaks EBS JRE Download

We are pleased to announce that the Java Runtime Environment (JRE) 1.8.0_271 (8u271) on the JRE 8 codeline is now certified with Oracle E-Business Suite Releases 12.1 and 12.2.  This update...

Application Tier

Critical Patch Update for October 2020 Now Available

The Critical Patch Update (CPU) for October 2020 was released on 20 October 2020. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest available Oracle E-Business Suite CPU document is available in Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12 (MOS Note 2484000.1).  We recommend you bookmark My Oracle Support Knowledge Document 2484000.1 in your favorites list in My Oracle Support.  Oracle CPU Announcements The Critical Patch Update Advisory is the starting point for reviewing all Oracle Critical Patch Update Advisories, Security Alerts and Bulletins. It includes a list of products affected, risk matrices of fixed vulnerabilities, and links to other important documents. It is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches. The next four Critical Patch Update release dates are: 19 January 2021 20 April 2021 20 July 2021 19 October 2021 Additional References Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12 (MOS Note 248400.1) Oracle E-Business Suite Release 12 Critical Patch Update (Oct 2020) (MOS Note 2707309.1) Oracle E-Business Suite Security Guide, Release 12.2 - Secure Configuration Secure Configuration Guide for Oracle E-Business Suite Release 12 (MOS Note 403537.1) FAQ: Oracle E-Business Suite Security (MOS Note 2063486.1) Related Articles Critical Patch Update for October 2020 Now Available Critical Patch Update for April 2020 Now Available Critical Patch Update for January 2020 Now Available Critical Patch Update for October 2019 Now Available Critical Patch Update for July 2019 Now Available Critical Patch Update for April 2019 Now Available

The Critical Patch Update (CPU) for October 2020 was released on 20 October 2020. Oracle strongly recommends applying the CPU patches as soon as possible. MOS Note for EBS CPUs A link to the latest...

Application Tier

OA Framework 12.2.10 Bundle 1 Released

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.10 and cannot be applied to any other release. What's available now? The first OAF update for Oracle E-Business Suite Release 12.2.10 is now available. All Oracle E-Business Suite Release 12.2.10 users should apply this patch. Future OAF patches for EBS Release 12.2.10 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.10 Bundle 1 (Patch 31947046:R12.FWK.C) What's new in this update? This bundle patch includes various enhancements and fixes. You may refer to the Readme for Patch 31947046 for further information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) References Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) OA Framework: How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (MOS Note 416708.1) Oracle Application Framework Developer's Guide: Index (MOS Note 1315485.1) Related Articles New JDeveloper Patch for EBS 12.2.10 OA Framework Oracle E-Business Suite 12.2.10 Now Available Webcast: Oracle E-Business Suite Modern User Interface with Rich Personalizations (Updated Oct 2019)

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Database Tier

Reminder: Error Correction Support for Oracle Database 12.1.0.2

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended July 31, 2018. Oracle Database 12.1.0.2 is covered by Extended Support until July 31, 2022.  For more details, see: Oracle Lifetime Support Policy: Oracle Technology Products Release Schedule of Current Database Releases (MOS Note 742060.1) For all EBS 12.2 and 12.1 users running Oracle Database 12.1.0.2 on-premises, we recommend upgrading to Oracle Database 19c. As of the publication date of this blog article, Oracle Database 19c is covered by Premier Support until April 30, 2024 and covered by Extended Support until August 30, 2027.  References Oracle Lifetime Support Policy: Oracle Technology Products Release Schedule of Current Database Releases (MOS Note 742060.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Updated: Oracle Database 19c Certified with EBS 12.2 Updated: Oracle Database 19c Certified with EBS 12.1.3 New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Oracle E-Business Suite Technology Blog - Database Tier Announcements

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended July 31, 2018. Oracle Database 12.1.0.2 is...

Database Tier

Reminder: End of Error Correction Support for Oracle Database 11.2.0.4

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended January 31, 2015. Oracle Database 11.2.0.4 on-premises is covered by Extended Support until December 31, 2020.  For more details, see: Oracle Lifetime Support Policy: Oracle Technology Products Release Schedule of Current Database Releases (MOS Note 742060.1) For all EBS 12.2 and 12.1 users running Oracle Database 11.2.0.4 on-premises, we recommend upgrading to Oracle Database 19c. As of the publication date of this blog article, Oracle Database 19c is covered by Premier Support until April 30, 2024 and covered by Extended Support until August 30, 2027.  References Oracle Lifetime Support Policy:  Oracle Technology Products Release Schedule of Current Database Releases (MOS Note 742060.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles Updated: Oracle Database 19c Certified with EBS 12.2 Updated: Oracle Database 19c Certified with EBS 12.1.3 New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Oracle E-Business Suite Technology Blog - Database Tier Announcements

E-Business Suite customers should run on a database that is covered by Error Correction Support (ECS). Premier Support for Oracle Database 11.2.0.4 ended January 31, 2015. Oracle Database 11.2.0.4...

Application Tier

Reminder: Upgrade Oracle Internet Directory 11.1.1.x to 12.2.x

Oracle Internet Directory (OID) is part of a suite of products called Oracle Identity and Access Management (IAM). OID 11.1.1.x  is covered by Premier Support until December 2020 and Extended Support until December 2021.  For more details, see: Oracle Lifetime Support Policy: Oracle Fusion Middleware Products Error Correction Support Dates for Oracle Fusion Middleware 11g (MOS Note 1290894.1) For all EBS users running OID 11.1.1.x, we recommend the following: For Oracle E-Business Suite 12.2, you may either upgrade to OID 12c or migrate to Oracle Unified Directory (OUD) 12c. For Oracle E-Business Suite 12.1, you should upgrade to OID 12c As of the publication date of this blog article, OID 12.2.x and OUD 12.2.x are covered by Premier Support until August 2022 and covered by Extended Support until August 2025.  References Oracle Lifetime Support Policy: Oracle Fusion Middleware Products Error Correction Support Dates for Oracle Fusion Middleware 12c (MOS Note 1933372.1) Error Correction Support Dates for Oracle Fusion Middleware 11g (MOS Note 1290894.1) Related Articles OAM 12.2.1.4 and OID 12.2.1.4 Now Certified with EBS 12.2 and 12.1 OUD 12.2.1.4 Now Certified with EBS 12.2 Oracle E-Business Suite Technology Blog - OID Announcements

Oracle Internet Directory (OID) is part of a suite of products called Oracle Identity and Access Management (IAM). OID 11.1.1.x  is covered by Premier Support until December 2020 and Extended Support...

Application Tier

New OA Framework 12.2.4 Bundle 22 Now Available

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.4 and cannot be applied to any other EBS release. What's available now? The latest OAF update for Oracle E-Business Suite Release 12.2.4 is now available. All Oracle E-Business Suite Release 12.2.4 users should apply this patch. Future OAF patches for EBS Release 12.2.4 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.4 Bundle 22 (Patch 30309169:R12.FWK.C) What's new in this update? As well as all the fixes that were released in previous Release 12.2.4 bundle patches, this latest patch also includes fixes for the following issues: The default value of a descriptive flexfield's Extra Information Type (EIT) read-only dependent segment is not updated correctly on the Self-Service Human Resources Update Details page. You can also refer to the Readme for Patch 30309169 for additional information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (Doc ID 1927975.1) Related Articles New OA Framework 12.2.4 Update 21 Now Available New OA Framework 12.2.4 Update 20 Now Available Which JDeveloper Version Works With Your EBS Release? New User Interface Features in Release 12.2.4

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Application Tier

New OA Framework 12.2.6 Bundle 25 Now Available

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.6 and cannot be applied to any other EBS release. What's available now? The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available. All Oracle E-Business Suite Release 12.2.6 users should apply this patch. Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.6 Bundle 25 (Patch 31625670:R12.FWK.C) What's new in this update? As well as all the fixes that were released in previous Release 12.2.6 bundle patches, this latest patch also includes fixes for the following issues: Form validation fails for the last day of the Hijrah calendar. When exporting iProcurement Requisitions table data to a Microsoft Excel spreadsheet, the Total column is missing. You can also refer to the Readme for Patch 31625670 for additional information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) References Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) OA Framework: How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (MOS Note 416708.1) Oracle Application Framework Developer's Guide (MOS Note 1315485.1) Related Articles New OA Framework 12.2.6 Update 24 Now Available Which JDeveloper Version Works With Your EBS Release? New User Interface Features in Release 12.2.4

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Certifications

Data Masking Now Certified for EBS 12.2 with DB 12.1.0.2 or 11.2.0.4 and EM 13cR4

We're pleased to announce the certification of the EBS 12.2 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4.  The updated template included with this certification contains bug fixes and an optional post-masking script.  The optional post-masking script provides synchronization between FND and HR user data. The updated template is certified with EM 13cR4 and prior releases of EM 13c per the documented guidelines.   You can use the Oracle Data Masking and Subsetting Pack with Oracle Enterprise Manager Cloud Control 13c (EM 13c) to mask sensitive data in cloned (non-production) EBS 12.2 environments. To use EM 13c to mask data in a cloned EBS 12.2 environment with Database 12.1.0.2 or 11.2.0.4, use the following instructions and template:    Using Oracle E-Business Suite Release 12.2 Data Masking Template with Oracle Database 11gR2 or 12cR1 and Oracle Enterprise Manager Cloud Control 13c (MOS Note 2076834.1 ) EBS 12.2 DATA MASKING PACK FOR EM 13C - V2.0.7 (Patch 30966900) What does masking do in an EBS environment? Due to data dependencies, scrambling E-Business Suite data is a non-trivial task.  The data needs to be scrubbed in such a way that allows the application to continue to function.   Based upon the Oracle E-Business Suite architecture and sensitive columns, application data masking with the certified EBS Data Masking Template does the following: De-identifies the data:  Scrambles identifiers of individuals, also known as personally identifiable information (PII).  Examples include information such as name, account, and address. Masks sensitive data:  Masks data that, if associated with PII, would cause privacy concerns.  Examples include compensation, health and employment information.   Maintains data validity:  Provides a functional application. References Using Oracle E-Business Suite Release 12.2 Data Masking Template with Oracle Database 11gR2 or 12cR1 and Oracle Enterprise Manager Cloud Control 13c (MOS Note 2076834.1 ) Related Articles Sep 2020 Updates to the EBS 12.2 Data Masking Template for Database 19c with EM 13c Data Masking Certified for EBS 12.1.3 and Database 19c with EM 13cR4 EBS 12.1 Data Masking Template Certified with EM 13c Oracle Application Management Pack Release 13.1.1.1.0 Now Certified with Oracle Database 19c Oracle Application Management Pack Release 13.4.1.0.0 is Now Available Oracle Enterprise Manager 13.4 is now available for download Updated: Oracle Database 19c Certified with EBS 12.2 Oracle E-Business Suite Technology Blog - Database Masking Announcements

We're pleased to announce the certification of the EBS 12.2 Data Masking Template with Oracle Database 12.1.0.2 or 11.2.0.4 and EM 13cR4.  The updated template included with this certification...

Application Tier

New OA Framework 12.2.9 Bundle 4 Now Available

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.9 and cannot be applied to any other EBS release. What's available now? The latest OAF update for Oracle E-Business Suite Release 12.2.9 is now available. All Oracle E-Business Suite Release 12.2.9 users should apply this patch. Future OAF patches for EBS Release 12.2.9 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.9 Bundle 4 (Patch 31466879:R12.FWK.C) What's new in this update? As well as all the fixes that were released in previous Release 12.2.9 bundle patches, this latest patch also includes fixes for the following issues: Creating an Oracle Web Applications Desktop Integrator document in Simplified View gives an error when a KFF LOV is displayed in popup mode. If when on the Purchasing Requisitions page a user selects the 'New Search' option, navigates between tabs, and then returns to the Requisitions tab, a query is needlessly run every time. You can also refer to the Readme for Patch 31466879 for additional information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) References Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) OA Framework: How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (MOS Note 416708.1) Oracle Application Framework Developer's Guide (MOS Note 1315485.1) Related Articles New OA Framework 12.2.9 Bundle 3 Now Available New OA Framework 12.2.9 Bundle 2 Now Available New OA Framework 12.2.9 Bundle 2 Now Available New OA Framework 12.2.9 Bundle 1 Now Available OA Framework Post-12.2.9 Consolidated Patch Now Available Webcast: Oracle E-Business Suite Modern User Interface with Rich Personalizations (Updated Oct 2019) New JDeveloper Patch for EBS 12.2.9 OA Framework

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Application Tier

New OA Framework 12.2.7 Bundle 10 Now Available

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and associated infrastructure. We periodically release OAF updates to fix performance, security, and stability issues. How do updates work? These updates are provided in two formats: cumulative Release Update Packs (RUPs), and cumulative Bundle Patches (BPs) that can be applied on top of the RUPs. In this context, cumulative means that the latest RUP or BP includes all the updates released previously. OAF bundles may be applied to the specified EBS release only, and are not compatible with other EBS releases. For example, the patch listed here is for EBS Release 12.2.7 and cannot be applied to any other EBS release. What's available now? The latest OAF update for Oracle E-Business Suite Release 12.2.7 is now available. All Oracle E-Business Suite Release 12.2.7 users should apply this patch. Future OAF patches for EBS Release 12.2.7 will require this patch as a prerequisite. Oracle Application Framework (FWK) Release 12.2.7 Bundle 10 (Patch 31445005:R12.FWK.C) What's new in this update? As well as all the fixes that were released in previous Release 12.2.7 bundle patches, this latest patch also includes fixes for the following issues: Role Based Access Controls defined in User Management are not honored when the Oracle E-Business Suite Home Page Style is set to 'Framework Simplified'.  Receipt Line attachments are not saved. When creating a Solution in Oracle Knowledge Management, users are unable to remove added Template Groups. For a descriptive flexfield with a dependent LOV segment in a table, LOV lookahead search does not work for a dependent segment. The dependent LOV segment in the Asset Attributes descriptive flexfield does not auto-refresh on a Self Service page. You can also refer to the Readme for Patch 31445005 for additional information. Where is this update documented? Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document: Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) References Oracle E-Business Suite Release 12.2 Upgrade Considerations for OA Framework-based Applications (MOS Note 1927975.1) OA Framework: How to Identify Required Oracle JDeveloper Patches For Oracle E-Business Release 12.x or 11i (MOS Note 416708.1) Oracle Application Framework Developer's Guide (MOS Note 1315485.1) Related Articles New OA Framework 12.2.7 Bundle 9 Now Available New OA Framework 12.2.7 Bundle 8 Now Available New OA Framework 12.2.7 Bundle 7 Now Available New OA Framework 12.2.7 Bundle 6 Now Available New OA Framework 12.2.7 Bundle 5 Now Available New OA Framework 12.2.7 Bundle 4 Now Available New OA Framework 12.2.7 Update 3 Now Available New OA Framework 12.2.7 Update 2 Now Available New OA Framework 12.2.7 Update 1 Now Available Which JDeveloper Version Works With Your EBS Release? New User Interface Features in Release 12.2.4

Web-based content in Oracle E-Business Suite Release 12 is supported by the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and...

Application Tier

September 2020 Update to Integrated SOA Gateway for EBS 12.2

I am pleased to announce availability of consolidated Patch 31764501:R12.OWF.C - ISG Consolidated Patch for 12.2 (20_3_5) for Oracle E-Business Suite Integrated SOA Gateway for Oracle E-Business Suite Release 12.2. Oracle strongly recommends all EBS 12.2 Integrated SOA Gateway customers apply this set of updates. This cumulative update includes all previously released ISG updates for EBS R12.2, plus enhancements and fixes for stability and performance of the product. Key Updates Included with this Patch Business Service Objects as REST Service In earlier releases, you could deploy Business Service Objects as SOAP based web service only. With this patch, you can deploy Business Service Objects as a SOAP and/or REST based web service. REST Service Monitoring and Logging Service monitoring and logging configuration has been enhanced. Now, in addition to the SOAP messages, you can track and monitor inbound REST messages. Managing Grants Using Script Previously, you could manage grants from the Integration Repository UI only. With this patch, you can create and revoke grants for web services using back-end script as well. Delete Custom APIs You asked for this enhancement and now you have an ability to delete custom APIs from the Integration Repository. References Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (MOS Note 1311068.1) Oracle E-Business Suite Integrated SOA Gateway R12.2 Implementation Guide Related Articles July 2020 Update to Integrated SOA Gateway for EBS 12.2     Integrated SOA Gateway (ISG) Now Certified with EBS 12.2 and Database 19c Upgrading Oracle SOA Suite 11g to Oracle SOA Suite 12c in an Existing ISG configuration

I am pleased to announce availability of consolidated Patch 31764501:R12.OWF.C - ISG Consolidated Patch for 12.2 (20_3_5) for Oracle E-Business Suite Integrated SOA Gatewayfor Oracle E-Business Suite...

Application Tier

Oracle E-Business Suite 12.2.10 Now Available

We are pleased to announce that Oracle E-Business Suite 12.2.10 is now available. Many new features and enhancements were requested and voted on by customers using the social media capabilities of the Oracle E-Business Suite Communities on My Oracle Support. Other new features and enhancements reflect continued development of themes introduced in earlier 12.2 releases, including functional innovation, user interface modernization, and increased operational efficiency. For details regarding the EBS 2020 innovations, see: Announcing Oracle E-Business Suite 2020 Innovations (PDF) The EBS 12.2.10 release update pack (RUP) is delivered on My Oracle Support as Patch 30399999.  Instructions for downloading and applying this latest RUP on top of the EBS 12.2 codeline can be found here: Oracle E-Business Suite Release 12.2.10 Readme (MOS Note 2666934.1) What Does Release 12.2.10 Include? As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security. Release 12.2.10 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases. For a complete list of new features, refer to: Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (MOS Note 1302189.1) Common Questions and Answers About Upgrading Q: Is there a direct upgrade path from EBS 12.2.x to 12.2.10? A: Yes. Release 12.2.x customers can apply 12.2.10 directly to their environments. EBS 12.2.10 is an online patch, so it can be applied while an existing Release 12.2.x system is running. Q: Is there a direct upgrade path from Release 12.1 to Release 12.2.10? A: No. Release 12.1 customers must first upgrade to Release 12.2 before applying 12.2.10. Q: Is there a direct upgrade path from Release 12.0 to Release 12.2.10? A: No. Release 12.0 customers must first upgrade to Release 12.2 before applying 12.2.10. Q: Is there a direct upgrade path from EBS 11i to 12.2.10? A: No. Release 11i customers must first upgrade to Release 12.2 before applying 12.2.10. Additional References Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1) Oracle E-Business Suite Release 12.2 Documentation - Web Library (Oracle Technology Network) Oracle E-Business Suite: Innovations in 2020 (Video) [Cliff Godwin’s video announcement] Related Articles Oracle E-Business Suite 12.2.9 Now Available Oracle E-Business Suite 12.2.8 Now Available Oracle E-Business Suite 12.2.7 Now Available Oracle E-Business Suite 12.2.6 Now Available Oracle E-Business Suite 12.2.5 Now Available Oracle E-Business Suite 12.2.4 Now Available Oracle E-Business Suite 12.2.3 Now Available Oracle E-Business Suite 12.2 Now Available

We are pleased to announce that Oracle E-Business Suite 12.2.10 is now available. Many new features and enhancements were requested and voted on by customers using the social media capabilities of the...

Certifications

Data Masking Certified for EBS 12.1.3 and Database 19c with EM 13cR4

We're pleased to announce the certification of the EBS 12.1.3 Data Masking Template with Oracle Database 19c. The new template includes required updates for Database 19c, performance improvements and general enhancements.   You can use the Oracle Data Masking and Subsetting Pack with Oracle Enterprise Manager Cloud Control 13c (EM 13c) to mask sensitive data in cloned (non-production) EBS 12.1.3 environments with Database 19c.  This announcement includes certification with EM 13cR4.  You may also continue to deploy with prior releases of EM 13c per the documented guidelines.   To use EM 13c to mask data in a cloned EBS 12.1.3 environment with Database 19c, use the following instructions and template:    Using Oracle E-Business Suite Release 12.1.3 Data Masking Template with Oracle Database 19c and Oracle Enterprise Manager Cloud Control 13c (MOS Note: 2686202.1 ) EBS 12.1.3 DATA MASKING PACK FOR EM 13C - V1.1.13 (Patch 31645549) What does masking do in an EBS environment? Due to data dependencies, scrambling E-Business Suite data is a non-trivial task.  The data needs to be scrubbed in such a way that allows the application to continue to function.   Based upon the Oracle E-Business Suite architecture and sensitive columns, application data masking with the certified EBS Data Masking Template does the following: De-identifies the data:  Scrambles identifiers of individuals, also known as personally identifiable information (PII).  Examples include information such as name, account, and address. Masks sensitive data:  Masks data that, if associated with PII, would cause privacy concerns.  Examples include compensation, health and employment information.   Maintains data validity:  Provides a functional application. References Using Oracle E-Business Suite Release 12.1.3 Data Masking Template with Oracle Database 19c and Oracle Enterprise Manager Cloud Control 13c (MOS Note: 2686202.1 )) Related Articles EBS 12.1 Data Masking Template Certified with EM 13c Data Masking Certified for EBS 12.2 and Database 19c with EM 13cR4 Oracle Application Management Pack Release 13.4.1.0.0 is Now Available Oracle Enterprise Manager 13.4 is now available for download

We're pleased to announce the certification of the EBS 12.1.3 Data Masking Template with Oracle Database 19c. The new template includes required updates for Database 19c, performance improvements and...

Database Tier

Check Your EBS Database Upgrade with the New EBS Database 19c Upgrade Analyzer

In addition to helping customers resolve issues via Oracle Service Requests, Oracle Support builds free diagnostic tools called analyzers for Oracle E-Business Suite. Oracle Support Analyzers are non-invasive scripts that run health checks on your EBS environments. The analyzers look for common issues and generate standardized reports that provide solutions for known issues and recommendations based on best practices. The following document includes an inventory of all EBS analyzers: Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (MOS Note 1545562.1) Spotlight on the New E-Business Suite Database 19c Upgrade Analyzer Oracle Support recently released a new analyzer that helps with the upgrade to Oracle Database 19c for Oracle E-Business Suite 12.x environments. The Database 19c Upgrade analyzer for EBS 12.x provides guidance and recommendations based upon the documented upgrade process in the following: Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (MOS Note 2552181.1) Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1) The Database 19c Upgrade analyzer for EBS 12.x evaluates your environment before, during  and after the database upgrade.  It performs validation of critical database upgrade steps and checks for known issues.  The results of the analysis are provided in an easy to read HTML report. Troubleshooting issues with the database upgrade is also easier when using this analyzer.  The EBS Database 19c Upgrade Analyzer is available for download from the following document: Oracle Database 19c Upgrade Analyzer for Oracle E-Business Suite (MOS Note 2704990.1) The following are key features of the Database 19c Upgrade for EBS 12.x Analyzer: Runs as a standalone java program Analyzes your E-Business Suite database environment in an easy-to-read HTML report Checks operating system requirements Evaluates system setup and configuration, applied E-Business Suite patches, and critical database patching data Displays potential errors or missed steps based on the progress of your database upgrade Provides recommended actions Collects all log files associated with the upgrade patching References Oracle Database 19c Upgrade Analyzer for Oracle E-Business Suite (MOS Note 2704990.1) Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (MOS Note 1545562.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles Updated: Oracle Database 19c Certified with EBS 12.2 Updated: Oracle Database 19c Certified with EBS 12.1.3 New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier Announcements Check Your EBS 12.x to 12.2 Upgrade with the New EBS Upgrade Analyzer

In addition to helping customers resolve issues via Oracle Service Requests, Oracle Support builds free diagnostic tools called analyzers for Oracle E-Business Suite. Oracle Support Analyzers are...

Data Masking

Sep 2020 Updates to the EBS 12.2 Data Masking Template for Database 19c with EM 13c

As a follow-up to our recent EBS 12.2 data masking with 19c certification announcement, we are pleased to to announce enhancements to the EBS 12.2 Data Masking Template.  The updated template includes bug fixes and an optional post-masking script.  The optional post-masking script provides synchronization between FND and HR user data. You can use the Oracle Data Masking and Subsetting Pack with Oracle Enterprise Manager Cloud Control 13c (EM 13c) to mask sensitive data in cloned (non-production) EBS 12.2 environments with Database 19c.  To use EM 13c to mask data in a cloned EBS 12.2 environment with Database 19c, use the following instructions and updated template:    Using Oracle E-Business Suite Release 12.2 Data Masking Template with Oracle Database 19c and Oracle Enterprise Manager Cloud Control 13c (MOS Note: 2670270.1) EBS 12.2 DATA MASKING PACK FOR EM 13C - V2.0.7 (Patch 30966900) What does masking do in an EBS environment? Due to data dependencies, scrambling E-Business Suite data is a non-trivial task.  The data needs to be scrubbed in such a way that allows the application to continue to function.   Based upon the Oracle E-Business Suite architecture and sensitive columns, application data masking with the certified EBS Data Masking Template does the following: De-identifies the data:  Scrambles identifiers of individuals, also known as personally identifiable information (PII).  Examples include information such as name, account, and address. Masks sensitive data:  Masks data that, if associated with PII, would cause privacy concerns.  Examples include compensation, health and employment information.   Maintains data validity:  Provides a functional application. References Using Oracle E-Business Suite Release 12.2 Data Masking Template with Oracle Database 19c and Oracle Enterprise Manager Cloud Control 13c (MOS Note: 2670270.1) Related Articles Data Masking Certified for EBS 12.2 and Database 19c with EM 13cR4 EBS 12.2 Data Masking Template Certified with EM 13cR3 EBS 12.1 Data Masking Template Certified with EM 13c Oracle Application Management Pack Release 13.4.1.0.0 is Now Available Oracle Enterprise Manager 13.4 is now available for download

As a follow-up to our recent EBS 12.2 data masking with 19c certification announcement, we are pleased to to announce enhancements to the EBS 12.2 Data Masking Template.  The updated template includes...

Application Management Pack

Oracle Application Management Pack Release 13.1.1.1.0 Now Certified with Oracle Database 19c

As a follow-up to a prior announcement, we are pleased to announce that the Oracle Application Management Pack 13.1.1.1.0 is now certified with Oracle Database 19c.  What's New Certification with Oracle E-Business Suite Releases 12.2 and 12.1 using Oracle Database 19c for environments using the following features: Discovery Monitoring Approvals Patch Manager Customization Manager How to Discover a Pluggable Database Refer to the following document for discovering an Oracle E-Business Suite 19c Database: Oracle Application Management Pack for Oracle E-Business Suite Guide References Oracle Application Management Pack for Oracle E-Business Suite Guide Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite, Release 13.1.1.1.0 (MOS Note 2045552.1.) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles New Features in Application Management Pack 13.1.1.1 for E-Business Suite Application Management Pack 13.1.1.1 for EM 13c Now Available Oracle Application Management Pack Release 13.4.1.0.0 is Now Available New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier Announcements

As a follow-up to a prior announcement, we are pleased to announce that the Oracle Application Management Pack 13.1.1.1.0 is now certified with Oracle Database 19c.  What's New Certification with Oracle...

Active Data Guard

Updated: Oracle Database 19c Certified with EBS 12.1.3

[14-SEP-2020: Added AMP 13.1.1.1.0 certification with 19c] [22-SEP-2020:  Updated for Certification of EBS 12.1.3 Data Masking Template with DB 19c ] Since we first blogged about the certification of EBS 12.1.3 with Oracle Database 19c in September 2019, we have announced a number of additional certifications. This blog article provides a consolidated view of these updates.  Note: The source of truth for certifications is maintained on My Oracle Support.  If in doubt, always check the Certifications database for the final word. Oracle E-Business Suite 12.1.3 with Database 19c 1. Certified Platforms The Certified Platforms list includes items that have been explicitly certified by EBS development. Linux x86-64 Oracle Linux 7.4 Update 4 (7.4) or later Red Hat Enterprise Linux 7.5 Update 5 (7.5) or later SUSE Linux Enterprise Server 12 SP3 or later IBM:  Linux on System Z Red Hat Enterprise Linux 7 SUSE Linux Enterprise Server 12 Oracle Solaris (SPARC systems, 64-bit) Oracle Solaris 11.4 or later Oracle Solaris 11.3  or later IBM AIX on Power Systems AIX 7.1 TL5 SP1 or later AIX 7.2 TL2 SP1 or later HP-UX Itanium HP-UX 11.31 September 2014 Quality Pack or later Windows Microsoft Windows x64 (64-bit) 2. Supported Database Features and Options The Supported Database Features and Options list includes items that are supported but not explicitly certified by EBS. Our general policy is that the Oracle Database generic documentation applies to these features and options, even if we haven't certified them specifically. Advanced Compression Database In-Memory Database Partitioning Native PL/SQL Compilation Oracle Application Express (APEX) Oracle Label Security (OLS) SecureFiles Virtual Private Database (VPD) 3. Certified Database Features and Options The Certified Database Features and Options list includes items that have been explicitly certified by EBS development. Active Data Guard Data Guard Using Logical Host Names Data Guard Using Physical Server Names Data Masking Database Vault Export/Import In Place Standby Upgrade to 19c Multitenant architecture (CDB architecture) with a single Pluggable Database (PDB) (single tenant) Oracle Real Application Clusters (Oracle RAC) Transparent Data Encryption (TDE) with Online Tablespace Encryption Conversion Transportable Tablespaces for data migration processes 4. Certified Integrations and Optional Deployments The Certified Integrations list includes items that have been explicitly certified by EBS development.  Oracle Application Management Pack Releases 13.1.1.1.0 and 13.4.1.0 Oracle E-Business Suite 12.1.3 Integrated with Oracle Access Manager for Single Sign-on Oracle E-Business Suite 12.1.3 with Database 19c Integrated with GoldenGate for Reporting Oracle E-Business Suite Integrated SOA Gateway (ISG) What Remains to be Certified? This section includes all items that are pending certification. You may subscribe to this blog for the latest in certification announcements.  Pending Certifications - Platforms Oracle Solaris on x64 (64-bit) Pending Certifications - Database Features and Options The Pending Certifications - Database Features and Options list includes items that require explicit certification and that we currently plan to certify in the future.  Transportable Database for data migration processes References For EBS 12.1.3 and Oracle Database 19c MOS Note references, go to the EBS 12.1.3 Resources tab in the following My Oracle Support document: Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier Announcements

[14-SEP-2020: Added AMP 13.1.1.1.0 certification with 19c] [22-SEP-2020:  Updated for Certification of EBS 12.1.3 Data Masking Template with DB 19c ] Since we first blogged about the certification of EBS...

Active Data Guard

Updated: Oracle Database 19c Certified with EBS 12.2

[14-SEP-2020: Added AMP 13.1.1.1.0 certification with 19c] Since we first blogged about the certification of EBS 12.2 with Oracle Database 19c in September 2019, we have announced a number of additional certifications. This blog article provides a consolidated view of these updates.  Note: The source of truth for certifications is maintained on My Oracle Support. If in doubt, always check the Certifications database for the final word. Oracle E-Business Suite 12.2 with Database 19c 1. Certified Platforms The Certified Platforms list includes items that have been explicitly certified by EBS development. Linux x86-64 Oracle Linux 7.4 Update 4 (7.4) or later Red Hat Enterprise Linux 7.5 Update 5 (7.5) or later SUSE Linux Enterprise Server 12 SP3 or later Linux on IBM Z Red Hat Enterprise Linux 7 SUSE Linux Enterprise Server 12 Oracle Solaris (SPARC systems, 64-bit) Oracle Solaris 11.4 or later Oracle Solaris 11.3  or later IBM AIX on Power Systems IBM AIX on Power Systems (64-bit) - AIX 7.1 and 7.2 HP-UX Itanium HP-UX 11.31 Windows Microsoft Windows x64 (64-bit) 2. Supported Database Features and Options The Supported Database Features and Options list includes items that are supported but not explicitly certified by EBS. Our general policy is that the Oracle Database generic documentation applies to these features and options, even if we haven't certified them specifically. Advanced Compression Database In-Memory Database Partitioning Native PL/SQL Compilation Oracle Application Express (APEX) Oracle Label Security (OLS)* SecureFiles Virtual Private Database (VPD)* Note: *There are special considerations for Oracle E-Business Suite 12.2 and the required edition-based redefinition database feature as follows:  For OLS, monitor this blog for updated guidance  For VPD, refer to Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (MOS Note 1577661.1) 3. Certified Database Features and Options The Certified Database Features and Options list includes items that have been explicitly certified by EBS development. Active Data Guard Data Guard Using Logical Host Names Data Guard Using Physical Server Names Data Masking Database Vault Export/Import In Place Standby Upgrade Multitenant architecture (CDB architecture) with a single Pluggable Database (PDB) (single tenant) Oracle Real Application Clusters (Oracle RAC) Transparent Data Encryption (TDE) with Online Tablespace Encryption Conversion Transportable Tablespaces for data migration processes 4. Certified Integrations The Certified Integrations list includes items that have been explicitly certified by EBS development.  Oracle Application Management Pack Releases 13.1.1.1.0 and 13.4.1.0 Oracle E-Business Suite 12.2 with Database 19c Integrated with Oracle Access Manager for Single Sign-on Oracle E-Business Suite 12.2 with Database 19c Integrated with GoldenGate for Reporting Oracle E-Business Suite Integrated SOA Gateway (ISG) What Remains to be Certified? This section includes all items that are pending certification. You may subscribe to this blog for the latest in certification announcements.  Pending Certifications - Platforms Oracle Solaris on x64 (64-bit) Pending Certifications - Database Features and Options The Pending Certifications - Database Features and Options list includes items that require explicit certification and that we currently plan to certify in the future.  Transportable Database for data migration processes References For EBS 12.2 and Oracle Database 19c MOS Note references, go to the EBS 12.2 Resources tab in the following My Oracle Support document: Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier Announcements

[14-SEP-2020: Added AMP 13.1.1.1.0 certification with 19c] Since we first blogged about the certification of EBS 12.2 with Oracle Database 19c in September 2019, we have announced a number of...

Certifications

Transportable Tablespaces for On-Premise Database Migrations Now Certified with EBS 12.1.3 and Database 19c

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for on-premise Oracle E-Business Suite Release 12.1.3 with Oracle Database 19c. To use this certified process the source database must be either Oracle Database 11gR2 (11.2.0.4), 12cR1 (12.1.0.2) or 19c and the target database is Oracle Database 19c. The target database will consist of a single pluggable database (PDB) in a container database (CDB). This EBS 12.1 with Database 19c database migration process utilizes the full transportable export/import feature. The full transportable export/import feature significantly speeds up the migration process while also offering the optional use of incremental backup to minimize downtime. Patch 31405457, delivered by the EBS Platform Engineering team, is required for this migration process. The patch is now generally available on MOS for use by EBS customers. The patch provides various SQL scripts to facilitate the export and import of an EBS database instance using TTS. The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) with the following statement: SQL> select platform_name, endian_format from v$transportable_platform; The following table is a list of relevant platforms certified for the EBS 12.1 with Database 19c on the database tier: Big Endian Little Endian Oracle Solaris on SPARC Linux x86-64 HP-UX Itanium Windows x64 IBM AIX on Power Systems   Linux on IBM Z     Guidance for Using Transportable Tablespaces The use of TTS may greatly speed up the migration of the data portion of the database. It does not however affect the speed of migrating the metadata which is done using export/import. Smaller databases (less than 1TB) may see little gain from the use of TTS and other techniques like export/import are simpler and possibly faster. We recommend that when considering the use TTS, you first perform a test migration with export/import on your database using the 'metrics=y' parameter. This will provide information regarding the relative size of data vs metadata in your database and thereby give you a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that TTS is suitable as a migration process to reduce downtime. This particular certification is specific to on-premise platform migrations. Additional platform migration certifications that are in progress or planned include the following: EBS 12.2 and 12.1.3 DB cross-platform migration to Oracle Cloud using 19c Transportable Tablespaces References Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.1 using Oracle Database 19c Enterprise Edition on a Multitenant Environment (MOS Note 2707504.1) Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1) Database Initialization Parameter Settings for Oracle E-Business Suite Release 12 (MOS Note 396009.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Oracle Database Administrator's Guide 19c Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for on-premise Oracle E-Business Suite...

Quarterly EBS Upgrade Recommendations: August 2020 Edition

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified releases.  You can research these yourself using this MOS Note: How to Find E-Business Suite Patches & E-Business Suite Technology Stack Patches (Note 1633974.2) Note:  EBS 12.0 and 11.5.10 are in sustaining support.  No new patches are available.  You should upgrade to EBS 12.2.  Before upgrading to EBS 12.2, apply the minimum 12.0 patching baseline or the minimum 11i patching baseline.  Upgrade Recommendations for August 2020   EBS 12.2  EBS 12.1 Check your EBS support status and patching baseline Apply the minimum 12.2 patching baseline (EBS 12.2.3 + latest technology stack updates listed below) In Premier Support to December 2031 Apply the minimum 12.1 patching baseline (12.1.3 Family Packs for products in use + latest technology stack updates listed below) Upgrade to EBS 12.2 In Premier Support to December 2021 Market-Driven Support (MDS) for EBS 12.1 available beginning Jan 2022 Apply the latest EBS suite-wide RPC or RUP 12.2.9 Aug 2019 12.1.3 RPC5 Aug 2016 Use the latest Rapid Install StartCD 51 Feb 2016 StartCD 13 Aug 2011 Apply the latest EBS technology stack, tools, and libraries AD/TXK Delta 12 Aug 2020 FND Jul 2020 Web ADI RPC Jan 2018 Report Manager Bundle 5 Nov 2018 EBS 12.2.9 OAF Bundle 3 Jul 2020 EBS 12.2.7 OAF Bundle 9 Jul 2020 EBS 12.2.6 OAF Bundle 24 Jul 2020 EBS 12.2.5 OAF Update 23 Dec 2019 EBS 12.2.4 OAF Update 21 Oct 2019 ETCC Jul 2020 Web Tier Utilities 11.1.1.9 Daylight Savings Time DSTv34 Oct 2019 Upgrade to JDK 7 Web ADI Bundle 5 Jan 2018 Report Manager Bundle 5 Jan 2018 FND Jul 2020 OAF RUP 5 Jun 2016 JTT Update 4 Oct 2016 Daylight Savings Time DSTv34 Oct 2019 Upgrade to JDK 7 Apply the latest security updates July 2020 Critical Patch Update SHA-2 PKI Certificates SHA-2 Update for Web ADI & Report Manager to Feb 2020 Migrate from SSL or TLS 1.0 to TLS 1.2 Sign JAR files July 2020 Critical Patch Update SHA-2 PKI Certificates SHA-2 Update for Web ADI & Report Manager to Feb 2020 Migrate from SSL or TLS 1.0 to TLS 1.2 Sign JAR files Use the latest certified desktop components Migrate to Java Web Start Upgrade to IE 11 Upgrade to Firefox  ESR 78.x  or ESR 68 Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016 or Office 365 ProPlus) Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607) Migrate to Java Web Start Upgrade to IE 11 Upgrade to Firefox  ESR 78.x or ESR 68 Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016 or Office 365 ProPlus) Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607) Upgrade to the latest database Database 19c (19.8) Extended Support Fee Waived for EBS for 12.1.0.2 (July 2022), 11.2.0.4 (Dec 2020) Database 19c (19.8) Extended Support Fee Waived for EBS for 12.1.0.2 (July 2022), 11.2.0.4 (Dec 2020) If you're using Oracle Identity Management Upgrade to Oracle Access Manager 12c Upgrade to Oracle Internet Directory 12c or Oracle Unified Directory 12c Migrate from Oracle SSO to  Oracle Access Manager 12c Upgrade to Oracle Internet Directory 12c If you're using Oracle Discoverer Migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA) Discoverer 11.1.1.7 is in Sustaining Support as of June 2017 Migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA) Discoverer 11.1.1.7 is in Sustaining Support as of June 2017 If you're using Oracle Portal Migrate to Oracle WebCenter Portal 12c Migrate to Oracle WebCenter Portal 12c

Here are our latest upgrade recommendations for Oracle E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle's product...

Certifications

GoldenGate 19c Now Certified with EBS 12.2 and EBS 12.1 Using DB 19c

We are pleased to announce the certification of Oracle GoldenGate 19c (19.1) with Oracle E-Business Suite 12.2.3 and later and Oracle E-Business Suite 12.1.3 using Oracle Database 19c (19.7 or later).  Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems. The certified configuration of EBS with GoldenGate 19c provides a unidirectional method of replicating the Oracle E-Business Suite (source) database to a remote (target) Oracle database, which can be used for operational reporting.  The configuration is achieved using Integrated Extract and Integrated Replicat using the Oracle GoldenGate Classic Architecture. See the following document for details: Deploying Oracle GoldenGate 19c to Achieve Operational Reporting for Oracle E-Business Suite Release 12 with Oracle Database 19c (MOS Note 2692032.1) "How" But Not "What" The document above describes how to use GoldenGate to replicate data from the E-Business Suite to another system. It doesn't provide any guidance about which database objects to replicate. The E-Business Suite data model is vast, as you'd expect of something that has supports the integrated functioning of over 200 functional product modules. GoldenGate is a development tool, and like all development tools, requires an expert-level understanding of the E-Business Suite data model for successful use. Here's a good EBS data model resource: Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) Only Unidirectional Replication for EBS GoldenGate includes the ability to provide data replication in both directions. In some generic scenarios, you can choose to make alterations to replicated data on the external instance and have those changes updated back in the source database. Bidirectional replication is not permitted for E-Business Suite environments. You can use GoldenGate to replicate EBS data to an external database, but you cannot move that altered data back into the EBS database. GoldenGate's ability to read data in EBS databases is certified, but it must not be used to write to EBS databases. Not Certified for EBS Platform Migrations, Database Upgrades, or Disaster Recovery GoldenGate is not certified with EBS for the following: Upgrading E-Business Suite databases from one version to another Migrating E-Business Suite databases from one operating system platform to another Replicating E-Business Suite databases for disaster recovery purposes Why not? Tables without a primary key or unique index are fully supported by Oracle GoldenGate, but could add extra volume to redo log generation as all columns must be logged as well. EBS has over 10,000 tables without primary keys. If update or delete operations are performed on these tables it may negatively impact performance. In addition to this, GoldenGate does not support all data types that are used by EBS.  Oracle does not currently have any plans to produce a certified or automated method of using GoldenGate for EBS database upgrades, platform migrations or the creation of disaster recovery environments. You should use our certified processes for EBS database upgrades, platform migrations and business continuity.  Replication to a Non-Editioned Target Database EBS 12.2's Online Patching architecture has significant implications for data replication solutions implemented using Oracle GoldenGate. The referenced MOS note describes how to set up a unidirectional configuration of Oracle GoldenGate replication from an Oracle E-Business Suite Release 12.2 source database to a non-editioned target database. Using GoldenGate with EBS 12.2 environments is significantly different from previous EBS releases.  If you are upgrading your GoldenGate + EBS 12.1 environment to EBS 12.2, you must plan carefully for the new integration steps detailed in the document. References Deploying Oracle GoldenGate 19c to Achieve Operational Reporting for Oracle E-Business Suite Release 12 with Oracle Database 19c (MOS Note 2692032.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Database 19c (MOS Note 2608030.1) Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (MOS Note 2617787.1) Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (MOS Note 2617788.1) Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.2 using Oracle Database 19c Enterprise Edition on a Multitenant Environment (MOS Note 2674405.1) Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Active Data Guard 19c Certified with EBS 12.2 Oracle Data Guard 19c Certified with EBS 12.2 When Using Physical Server Names Oracle Data Guard 19c Certified with EBS 12.2 When Using Logical Host Names Transportable Tablespace for On-Premise Database Migrations Now Certified with EBS 12.2 and Database 19c New FAQ: EBS 12.2 and 12.1 and the Oracle Multitenant (CDB) Database Architecture Oracle E-Business Suite Technology Blog - Database Tier Announcements

We are pleased to announce the certification of Oracle GoldenGate 19c (19.1) with Oracle E-Business Suite 12.2.3 and later and Oracle E-Business Suite 12.1.3 using Oracle Database 19c (19.7 or later)....

Application Tier

How to Receive the Latest EBS Technology News, Certification Announcements and Updates

Customers and partners frequently ask, "How do I receive the latest updates posted on the Oracle E-Business Suite Technology Blog?" The information on how to receive notifications from this blog as described in this blog article are also available when you click the Subscribe to Blog Updates button from the Oracle E-Business Suite Technology blog home page. Here are some ways you can receive notifications as new articles are published on this blog: Subscribe to receive emails from the Oracle E-Business Suite Technology Blog Receive an email once a day when new blog articles are published from sender Oracle E-Business Suite Technology. To subscribe to emails: Click HERE to go to this blog's email subscription URL. Next, provide your email address, prove that you are not a robot, and click Complete Subscription Request.  Important final step:  To begin receiving notifications, you will receive an email to confirm your subscription.  If you do not verify via email, you subscription request will not go through. Subscribe to the Oracle E-Business Suite Technology Blog RSS feed Use your favorite RSS feed reader to get the latest updates. Subscribe to our blog RSS feed with this URL: https://blogs.oracle.com/ebstech/rss Follow Oracle E-Business Suite Technology on Twitter Our Twitter account is updated as blog articles are published. If you are an active Twitter user, follow us @oracle_ebstech. Key Oracle E-Business Suite Technology References Oracle E-Business Suite Release 12.2 Information Center - Documentation (MOS Note 1583110.1) Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap (MOS Note 1934915.1) Oracle E-Business Suite Release 12.1 Information Center - Documentation (MOS Note (806593.1) Oracle E-Business Suite Release 12.0/12.1 Technology Stack Documentation Roadmap (MOS Note 380482.1) Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (MOS Note 1302189.1) Subscribing to Hot Topic E-Mails - [VIDEO] (MOS Note 793436.2)

Customers and partners frequently ask, "How do I receive the latest updates posted on the Oracle E-Business Suite Technology Blog?" The information on how to receive notifications from this blog as...

Application Tier

DSTv35 Timezone Patches Available for E-Business Suite 12.2 and 12.1

The DSTv35 timezone upgrade is now available and certified with Oracle E-Business Suite Releases 12.2 and 12.1. This update includes the timezone information from IANA Time Zone 2020a update.  Note:  DST patches are cumulative and therefore include all previous Oracle DST updates. How Does Oracle E-Business Suite Work Across Time Zones? Periodically, a country or region changes their DST rules or timezone definitions. In addition, and more frequently, they may switch to or from Daylight Saving Time or Summer Time. If your Oracle E-Business Suite environment is configured to support doing business across multiple time zones, you need to keep your timezone definition files up-to-date by applying patches as described in this article. This will ensure that the times transactions take place are recorded correctly, and thereby meet applicable business and legal requirements. Is My Oracle E-Business Suite Environment Affected? When a country or region changes its timezone definitions or DST rules, your Oracle E-Business Suite environment will require patching if either of the following is true: Your EBS environment is located in the affected country or region or Your EBS environment is located outside the affected country or region, but you conduct business or have customers or suppliers there The following are major additions or changes in the DSTv35 time zones definitions compared to the previous release: Morocco springs forward on 2020-05-31, not 2020-05-24 Canada's Yukon advanced to -07 year-round on 2020-03-08 America/Nuuk renamed from America/Godthab What Patches Do I Require? The following MOS note identifies the various components in your Oracle E-Business Suite environment that may need DST patches: Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in Oracle E-Business Suite Release 12.x (MOS Note 563019.1) Note: Proactive back ports of DST upgrade patches to all Oracle E-Business Suite tiers and platforms are not created and supplied by default. If you need this DST release and an appropriate patch is not currently available, raise a service request through support providing a business case and your version requirements. What if I Do Not Apply the Relevant Patches? If you do business with a country or region that has changed its timezone definitions, and record a transaction that occurs at the boundary between the “old” and the “new” time, then the transaction may be recorded incorrectly. Specifically, that transaction's timestamp may be out by an hour. References Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in Oracle E-Business Suite Release 12.x (MOS Note 563019.1) Related Articles DSTv34 Timezone Patches Available for E-Business Suite 12.2 and 12.1 DSTv33 Timezone Patches Available for E-Business Suite 12.2 and 12.1 DSTv32 and DSTv31 Timezone Patches Available for E-Business Suite 12.2 and 12.1

The DSTv35 timezone upgrade is now available and certified with Oracle E-Business Suite Releases 12.2 and 12.1. This update includes the timezone information from IANA Time Zone 2020a update.  Note:  DS...

Data Guard

In Place Standby Upgrade to Database 19c Now Certified for EBS 12.1.3

Oracle Data Guard can be used to create a physical standby database as part of your disaster recovery plan for your production Oracle E-Business Suite environment. Oracle Active Data Guard can be used to create a reporting database for your Oracle E-Business Suite database. EBS 12.1.3 documents for use with Oracle Data Guard 19c and Active Data Guard 19c are available here: Business Continuity for Oracle E-Business Suite Release 12.1 on Oracle Database 19c Using Physical Host Names (MOS Note 2567091.1) Business Continuity for Oracle E-Business Suite Release 12.1 on Oracle Database 19c Using Logical Host Names (MOS Note 2567092.1) Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.1 and Database 19c (MOS Note 2608027.1) When upgrading the database to Oracle Database 19c, you can now upgrade the physical standby database in place. This certified process helps minimize your downtime requirements for the database upgrade of your production and standby databases. Refer to the following document for detailed instructions: Oracle E-Business Suite Release 12.1: Upgrading to Oracle Database 19c with Existing Physical Standby (MOS Note 2665457.1) The following is a summary of the steps that must be performed in order to upgrade the EBS standby database in place when upgrading to Database 19c:       1. Prepare for the Oracle Database 19c upgrade. This includes:             a. Installing Database 19c on the primary database server.             b. Creating the Database 19c CDB on the primary database server.             c. Copying the Database 19c ORACLE_HOME to the standby database server.             d. Backing up the Database 19c CDB on the primary database server.             e. Restoring the Database 19c CDB to the standby database server.             f. Configuring log synchronization between the primary and standby Database 19c CDBs.       2. Upgrade to Oracle Database 19c. This includes:             a. Preparing for the upgrade to Database 19c non-CDB.             b. Upgrading the primary database and standby database to Database 19c non-CDB.       3. Convert the primary database and the standby database to Database 19c CDB/PDB.       4. Run AutoConfig on the primary database server and standby database server. References Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Oracle E-Business Suite Release 12.1: Upgrading to Oracle Database 19c with Existing Physical Standby (MOS Note 2665457.1) Business Continuity for Oracle E-Business Suite Release 12.1 on Oracle Database 19c Using Physical Host Names (MOS Note 2567091.1) Business Continuity for Oracle E-Business Suite Release 12.1 on Oracle Database 19c Using Logical Host Names (MOS Note 2567092.1) Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.1 and Database 19c (MOS Note 2608027.1) Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 New FAQ: EBS 12.2 and 12.1 and the Oracle Multitenant (CDB) Database Architecture Oracle Data Guard 19c Certified with EBS 12.1.3 When Using Physical Host Names Oracle Data Guard 19c Certified with EBS 12.1.3 When Using Logical Host Names Active Data Guard 19c Certified with EBS 12.1.3 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier

Oracle Data Guard can be used to create a physical standby database as part of your disaster recovery plan for your production Oracle E-Business Suite environment. Oracle Active Data Guard can be used...

Active Data Guard

In Place Standby Upgrade to Database 19c Now Certified for EBS 12.2

Oracle Data Guard can be used to create a physical standby database as part of your disaster recovery plan for your production Oracle E-Business Suite environment. Oracle Active Data Guard can be used to create a reporting database for your Oracle E-Business Suite database. EBS 12.2 documents for use with Oracle Data Guard 19c and Active Data Guard 19c are available here: Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (MOS Note 2617787.1) Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (MOS Note 2617788.1) Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Database 19c (MOS Note 2608030.1) When upgrading the database to Oracle Database 19c, you can now upgrade the physical standby database in place. This certified process helps minimize your downtime requirements for the database upgrade of your production and standby databases. Refer to the following document for detailed instructions: Oracle E-Business Suite Release 12.2: Upgrading to Oracle Database 19c with Existing Physical Standby (MOS Note 2665458.1) The following is a summary of steps that must be performed in order to upgrade the EBS standby database in place when upgrading to Database 19c:       1. Prepare for the Oracle Database 19c upgrade. This includes:             a. Installing Database 19c on the primary database server.             b. Creating the Database 19c CDB on the primary database server.             c. Copying the Database 19c ORACLE_HOME to the standby database server.             d. Backing up the Database 19c CDB on the primary database server.             e. Restoring the Database 19c CDB to the standby database server.             f. Configuring log synchronization between the primary and standby Database 19c CDBs.       2. Upgrade to Oracle Database 19c. This includes:             a. Preparing for the upgrade to Database 19c non-CDB.             b. Upgrading the primary database and standby database to Database 19c non-CDB.       3. Convert the primary database and the standby database to Database 19c CDB/PDB.       4. Run AutoConfig on the primary database server and standby database server. References Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2) Oracle E-Business Suite Release 12.2: Upgrading to Oracle Database 19c with Existing Physical Standby (MOS Note 2665458.1) Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (MOS Note 2617787.1) Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (MOS Note 2617788.1) Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Database 19c (MOS Note 2608030.1) Related Articles New MOS Note: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 New FAQ: EBS 12.2 and 12.1 and the Oracle Multitenant (CDB) Database Architecture Oracle Data Guard 19c Certified with EBS 12.2 When Using Physical Server Names Oracle Data Guard 19c Certified with EBS 12.2 When Using Logical Host Names Active Data Guard 19c Certified with EBS 12.2 Extended Support Fee Waived for Oracle Database 12.1.0.2 for Oracle E-Business Suite Oracle E-Business Suite Technology Blog - Database Tier

Oracle Data Guard can be used to create a physical standby database as part of your disaster recovery plan for your production Oracle E-Business Suite environment. Oracle Active Data Guard can be used...