Steven Chan

Subscribe to Steven Chan feed
Oracle Blogs
Updated: 7 hours 25 min ago

EBS Releases 12.1 and 12.2 certified with SLES 12

Fri, 2018-11-16 12:08

I am pleased to announce that Oracle E-Business Suite Releases 12.1.3 and 12.2.6 (or higher) are now certified with SUSE Linux Enterprise Server (SLES) 12 on x86-64.

Installations of E-Business Suite on this operating system require specific patches to the latest startCD prior to installing, followed by the application of the 12.1.3 RUP or the 12.2.6 RUP (or higher) for EBS 12.1 and 12.2 respectively. Cloning of existing EBS 12.1.3 or 12.2 environments to SLES 12 is also certified using the standard Rapid Clone process.

There are also requirements to upgrade technology components such as the Oracle Database (to 11.2.0.4 or 12.1.0.2) and Fusion Middleware components as necessary. All requirements, known issues, patches needed, etc. are noted in the Installation and Upgrade Notes (IUN) below and must be reviewed and implemented.

For more information on requirements, please review the following documents:

 

Categories: APPS Blogs

New OA Framework 12.2.6 Update 16 Now Available

Wed, 2018-11-14 10:15

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

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 16 (Patch 28649181:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

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. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • Partial Page Rendering (PPR) event queuing fails intermittently in the IE 11 browser on Windows 7.

  • The table scroll bar cannot be moved up or down on the iProcurement item search page.

  • Text inside a disabled message text area fails to wrap and may therefore not display fully in the IE 11 browser.

  • An advanced table with many columns shows blank on scrolling down in the IE 11 browser on Windows 7.

Related Articles

Categories: APPS Blogs

November 2018 Update to E-Business Suite Technology Codelevel Checker (ETCC)

Tue, 2018-11-13 13:24

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps missing overlay patches to the default corresponding Database Patch Set Update (PSU) patches, and displays them in a patch recommendation summary.

What’s New

ETCC has been updated to include bug fixes and patching combinations for the following recommended versions of the following updates:

  • Oracle Database Proactive BP 12.1.0.2.181016
  • Oracle Database PSU 12.1.0.2.181016
  • Oracle JavaVM Component Database PSU 12.1.0.2.181016
  • Oracle Database Patch for Exadata BP 12.1.0.2.181016
  • Oracle Database PSU 12.1.0.2.181016
  • Oracle JavaVM Component Database PSU 12.1.0.2.181016
  • Microsoft Windows Database BP 12.1.0.2.181016
  • Oracle JavaVM Component 12.1.0.2.181016 on Windows
  • Microsoft Windows Database BP 12.1.0.2.181016
  • Oracle JavaVM Component 12.1.0.2.181016 on Windows

Obtaining ETCC

We recommend always using the latest version of ETCC, as new bugfixes will not be checked by older versions of the utility. The latest version of the ETCC tool can be downloaded via Patch 17537119 from My Oracle Support.

References

Related Articles

Categories: APPS Blogs

Announcing Continuous Innovation on Oracle E-Business Suite 12.2

Thu, 2018-11-08 12:18

Oracle announced a “Continuous Innovation” release model for Oracle E-Business Suite 12.2, delivering ongoing applications and underlying technology stack updates without a major upgrade. At the same time, we are announcing Premier Support for Oracle E-Business Suite 12.2 through at least 2030.

This means that Oracle E-Business Suite customers already running on 12.2 can continue to access new applications functionality and separately uptake later versions of underlying technology for years to come, without the time and expense of a major release upgrade. 

Oracle E-Business Suite customers historically have adopted new versions of the technology stack together with a new applications code level via a major release upgrade. This involved using Oracle’s Rapid Install tool to deliver new versions of Oracle Fusion Middleware platform technologies, a new applications code level, and upgrade scripts to move the schema, PL/SQL, and data in place to the new Oracle E-Business Suite release level.

It has been Oracle’s plan to move to a Continuous Innovation release model that separates technology stack updates from applications code updates, allowing E-Business Suite customers to consume later technology while retaining their current applications code level. We previously announced that we would start Continuous Innovation with the next major 12.X release, after the existing 12.2 release. We have since determined that we can implement Continuous Innovation on the existing 12.2 release, removing the need for a new 12.X release.

For more details, see:

Categories: APPS Blogs

JRE 1.8.0_201 Certified with Oracle EBS 12.1 and 12.2

Wed, 2018-11-07 12:23

Java logo

Java Runtime Environment 1.8.0_201 (a.k.a. JRE 8u201-b11) and later updates on the JRE 8 codeline are now certified with Oracle E-Business Suite 12.1 and 12.2 for Windows clients.

Java Web Start is available

This JRE release may be run with either the Java plug-in or Java Web Start.

Java Web Start is certified with EBS 12.1 and 12.2 for Windows clients.  

Considerations if you're also running JRE 1.6 or 1.7

JRE 1.7 and JRE 1.6 updates included an important change: the Java deployment technology (i.e. the JRE browser plugin) is no longer available for those Java releases. It is expected that Java deployment technology will not be packaged in later Java 6 or 7 updates.

JRE 1.7.0_161 (and later 1.7 updates) and 1.6.0_171 (and later 1.6 updates) can still run Java content.  They cannot launch Java.

End-users who only have JRE 1.7 or JRE 1.6 -- and not JRE 1.8 -- installed on their Windows desktop will be unable to launch Java content.

End-users who need to launch JRE 1.7 or 1.6 for compatibility with other third-party Java applications must also install the JRE 1.8.0_152 or later JRE 1.8 updates on their desktops.

Once JRE 1.8.0_152 or later JRE 1.8 updates are installed on a Windows desktop, it can be used to launch JRE 1.7 and JRE 1.6. 

How do I get help with this change?

EBS customers requiring assistance with this change to Java deployment technology can log a Service Request for assistance from the Java Support group.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

All patches required for ensuring full compatibility of the E-Business Suite with JRE 8 are documented in these Notes:

For EBS 12.1 & 12.2

Implications of Java 6 and 7 End of Public Updates for EBS Users

The Oracle Java SE Support Roadmap and Oracle Lifetime Support Policy for Oracle Fusion Middleware documents explain the dates and policies governing Oracle's Java Support.  The client-side Java technology (Java Runtime Environment / JRE) is now referred to as Java SE Deployment Technology in these documents.

Starting with Java 7, Extended Support is not available for Java SE Deployment Technology.  It is more important than ever for you to stay current with new JRE versions.

If you are currently running JRE 6 on your EBS desktops:

  • You can continue to do so until the end of Java SE 6 Deployment Technology Extended Support in June 2017
  • You can obtain JRE 6 updates from My Oracle Support.  See:

If you are currently running JRE 7 on your EBS desktops:

  • You can continue to do so until the end of Java SE 7 Deployment Technology Premier Support in October 2017.
  • You can obtain JRE 7 updates from My Oracle Support.  See:

If you are currently running JRE 8 on your EBS desktops:

  • You can continue to do so until the end of Java SE 8 Deployment Technology Premier Support in March 2019
  • You can obtain JRE 8 updates from the Java SE download site or from My Oracle Support. See:

Will EBS users be forced to upgrade to JRE 8 for Windows desktop clients?

No.

This upgrade is highly recommended but remains optional while Java 6 and 7 are covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JRE 6 and 7 desktop clients. Note that there are different impacts of enabling JRE Auto-Update depending on your current JRE release installed, despite the availability of ongoing support for JRE 6 and 7 for EBS customers; see the next section below.

Impact of enabling JRE Auto-Update

Java Auto-Update is a feature that keeps desktops up-to-date with the latest Java release.  The Java Auto-Update feature connects to java.com at a scheduled time and checks to see if there is an update available.

Enabling the JRE Auto-Update feature on desktops with JRE 6 installed will have no effect.

With the release of the January Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Enabling the JRE Auto-Update feature on desktops with JRE 8 installed will apply JRE 8 updates.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.12 (High Sierra) can run JRE 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 8 for EBS application tier servers?

No.

JRE is used for desktop clients.  JDK is used for application tier servers.

JRE 8 desktop clients can connect to EBS environments running JDK 6 or 7.

JDK 8 is not certified with the E-Business Suite.  EBS customers should continue to run EBS servers on JDK 6 or 7.

Known Issues

Internet Explorer Performance Issue

Launching JRE 1.8.0_73 through Internet Explorer will have a delay of around 20 seconds before the applet starts to load (Java Console will come up if enabled).

This issue fixed in JRE 1.8.0_74.  Internet Explorer users are recommended to uptake this version of JRE 8.

Form Focus Issue Clicking outside the frame during forms launch may cause a loss of focus when running with JRE 8 and can occur in all Oracle E-Business Suite releases. To fix this issue, apply the following patch:

References

Related Articles
Categories: APPS Blogs

JRE 1.7.0_201 Certified with Oracle E-Business Suite 12.1 and 12.2

Wed, 2018-11-07 12:23

Java logo

Java Runtime Environment 1.7.0_201 (a.k.a. JRE 7u201-b11) and later updates on the JRE 7 codeline are now certified with Oracle E-Business Suite Release 12.1 and 12.2 for Windows-based desktop clients.

What's new in this update?

This update includes an important change: the Java deployment technology (i.e. the JRE browser plugin) is no longer available as of this Java release. It is expected that Java deployment technology will not be packaged in later Java 7 updates.

JRE 1.7.0_161  and later JRE 1.7 updates can still run Java content.  These releases cannot launch Java.

End-users who only have JRE 1.7.0_161 and later JRE 1.7 updates -- but not JRE 1.8 -- installed on their Windows desktop will be unable to launch Java content.

End-users who need to launch JRE 1.7 for compatibility with other third-party Java applications must also install the October 2017 CPU release JRE 1.8.0_151 or later JRE 1.8 updates on their desktops.

Once JRE 1.8.0_151 or a later JRE 1.8 update is installed on a Windows desktop, it can be used to launch JRE 1.7.0_161 and later updates on the JRE 1.7 codeline. 

How do I get help with this change?

EBS customers requiring assistance with this change to Java deployment technology can log a Service Request for assistance from the Java Support group.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

Effects of new support dates on Java upgrades for EBS environments

Support dates for the E-Business Suiteand Java have changed.  Please review the sections below for more details:

  • What does this mean for Oracle E-Business Suite users?
  • Will EBS users be forced to upgrade to JRE 7 for Windows desktop clients?
  • Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

How can EBS customers obtain Java 7?

EBS customers can download Java 7 patches from My Oracle Support.  For a complete list of all Java SE patch numbers, see:

Both JDK and JRE packages are now contained in a single combined download.  Download the "JDK" package for both the desktop client JRE and the server-side JDK package. 

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

Java Auto-Update Mechanism

With the release of the January 2015 Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.12 (High Sierra) can run JRE 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

JRE ("Deployment Technology") is used for desktop clients.  JDK is used for application tier servers.

JDK upgrades for E-Business Suite application tier servers are highly recommended but currently remain optional while Java 6 is covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JDK 6 for application tier servers. 

Java SE 6 (excluding Deployment Technology) is covered by Extended Support until December 2018.  All EBS customers with application tier servers on Windows, Solaris, and Linux must upgrade to JDK 7 (excluding Deployment Technology) by December 2018. EBS customers running their application tier servers on other operating systems should check with their respective vendors for the support dates for those platforms.

JDK 7 is certified with E-Business Suite 12.  See:

Known Issues

When using Internet Explorer, JRE 1.7.0_01 had a delay of around 20 seconds before the applet started to load. This issue is fixed in JRE 1.7.0_95 and later updates on the JRE 1.7 codeline.

References

Related Articles
Categories: APPS Blogs

JRE 1.6.0_211 Certified with Oracle E-Business Suite

Wed, 2018-11-07 12:23

Java logThe latest Java Runtime Environment 1.6.0_211 (a.k.a. JRE 6u211-b11) is now certified with Oracle E-Business Suite Release 12.1 and 12.2 for Windows-based desktop clients.

Final Release for Java 6

This is the final release on the Java 6 codeline. Extended Support for Java 6 SE ends on December 31, 2018. There will be no further Java 6 updates:

All customers should upgrade desktop clients to JRE 7, JRE 8, or JWS 8 at their earliest convenience. 

What's new in this update?

This update includes an important change: the Java deployment technology (i.e. the JRE browser plugin) is no longer available as of the Java 1.6.0_171 release. It is expected that Java deployment technology will not be packaged in later Java 6 updates.

JRE 1.6.0_171 and later JRE 1.6 updates can still run Java content.  These releases cannot launch Java.

End-users who only have JRE 1.6.0_171 and later JRE 1.6 updates -- but not JRE 1.8 -- installed on their Windows desktop will be unable to launch Java content.

End-users who need to launch JRE 1.6 for compatibility with other third-party Java applications must also install the October 2017 PSU release JRE 1.8.0_152 or later JRE 1.8 updates on their desktops.

Once JRE 1.8.0_152 or a later JRE 1.8 update is installed on a Windows desktop, it can be used to launch JRE 1.6.0_171 and later updates on the JRE 1.6 codeline. 

How do I get help with this change?

EBS customers requiring assistance with this change to Java deployment technology can log a Service Request for assistance from the Java Support group.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

Effects of new support dates on Java upgrades for EBS environments

Support dates for the E-Business Suiteand Java have changed.  Please review the sections below for more details:

  • What does this mean for Oracle E-Business Suite users?
  • Will EBS users be forced to upgrade to JRE 7 for Windows desktop clients?
  • Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?
32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Deploying JRE documentation for your EBS release for details.

How can EBS customers obtain Java 6 updates?

Java 6 is now available only via My Oracle Support for E-Business Suite users.  You can find links to this release, including Release Notes, documentation, and the actual Java downloads here: Both JDK and JRE packages are contained in a single combined download after 6u45.  Download the "JDK" package for both the desktop client JRE and the server-side JDK package.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.12 (High Sierra) can run JRE 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

JRE ("Deployment Technology") is used for desktop clients.  JDK is used for application tier servers.

JDK upgrades for E-Business Suite application tier servers are highly recommended but currently remain optional while Java 6 is covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JDK 6 for application tier servers. 

Java SE 6 (excluding Deployment Technology) is covered by Extended Support until December 2018.  All EBS customers with application tier servers on Windows, Solaris, and Linux must upgrade to JDK 7 by December 2018. EBS customers running their application tier servers on other operating systems should check with their respective vendors for the support dates for those platforms.

JDK 7 is the latest Java release certified with E-Business Suite 12 servers.  See:

References

Related Articles
Categories: APPS Blogs

New White Paper: Oracle EBS 12.2 with Database 12.1.0.2 Advanced Row Compression

Tue, 2018-11-06 16:09

Oracle Database 12c Advanced Compression provides features designed to compress structured data (Advanced Row Compression), unstructured data (Advanced LOB Deduplication and Compression), database backups (RMAN and Data Pump Compression), and network traffic (Data Guard Redo Log Transport and Advanced Network Compression). 

Our EBS architects have released a new whitepaper that focuses on Advanced Row Compression:

This whitepaper quantifies the storage benefits for Oracle E-Business Suite and documents its effect on performance. Advanced Row Compression can reduce your current storage requirements as well as defer the future purchase and integration of additional storage. It includes optimization for Flashback Data Archive (FDA) history tables, which reduces the storage requirements for using FDA to track changes to tables.

Importantly, Advanced Row Compression is completely transparent to Oracle E-Business Suite and can even be used with Transparent Data Encryption (TDE) tablespace encryption because compression is applied before the data blocks are encrypted. The compression ratio depends on the data being compressed and more specifically the cardinality of the data. Customers have reported a reduction in storage by a factor of 2x to 4x across a range of systems. This new white paper examines whether this is the case for Oracle E-Business Suite. 

Related Articles

Categories: APPS Blogs

Updated: Minimizing EBS 12.2.8 Upgrade Downtimes

Mon, 2018-11-05 11:39

We have updated our recommendations for minimizing downtimes when upgrading to EBS 12.2.8:

Written by Jim Machin, a senior member of our Applications Performance group, this white paper contains a wealth of detailed technical recommendations for reducing the amount of time needed for an
EBS 12.2.8 upgrade. 

Events vs. sessions bottlenecks diagram

It covers:

  • Technical preparation and planning activities
  • Diagnostics for monitoring and troubleshooting performance issues
  • Common solutions to performance issues
  • Oracle Applications Tablespace Model (OATM) considerations
  • Methods for purging old data
  • Gathering statistics
  • Detailed recommendations for improving resource management, sizing, and workloads

Latest updates to this whitepaper

This white paper is updated regularly with new tips and recommendations based upon our Application Performance group's work with actual EBS 12.2 customers and their Service Requests.  All EBS 12.2 sysadmins should monitor this white paper regularly.  This latest version includes the following updates:

  • High Level of "enq: KO - fast object checkpoint" wait event – Internal Only
  • Middle Tier Sizing / Applications Tier Bottlenecks
  • Additional Fixed Object and Dictionary statistics information and advice.
  • Additional Materialized View advice, including ADZDMVREFRESHNEEDED.sql
  • Explicit mention of Online Patching Readiness reports and compliance checker in pre upgrade activities.
  • Improved explanation of how AD_ZD_TABLE_APPLY.sql uses DBMS_PARALLEL_EXECUTE to split work into chunks and call DBMS scheduler.
  • Addition of solutions for long running AD_ZD_TABLE_APPLY.sql.
  • Specific instances where extent size and high row length could impact batch size and performance adversely.
  • Advice for initialization parameter db_writer_processes
  • Additional references to documents 554539.1 1065393.1 and 2125596.1. Remove references to document 1585857.1
  • Amend SGA and Huge Pages advice

Related Articles

 

Categories: APPS Blogs

Updated for EBS 12.2.8: Reference Tools for Developers

Thu, 2018-11-01 14:41

Regular readers of this blog know that we have three reference tools that are essential for every E-Business Suite upgrade:

  1. File Comparison Report (Note 1446430.1)
  2. Data Model Comparison Report (Note 1290886.1)
  3. Seed Data Comparison Report (Note 1327399.1)

These tools allow you to generate a report of the differences between one EBS release and another for specific EBS products.

For example, you could use the Data Model Comparison to get a list of EBS 11.5.10.2 database objects that were updated in EBS 12.1.3 for Bill of Materials (BOM):

Screenshot of data model comparison report tool

What's New?

These tools now cover EBS 12.2.8 and all earlier EBS 12.2.x releases.

For example, you can now compare EBS 12.2.8 to:

  • 11.5.10 Minimum Baseline
  • 12.1.3
  • 12.2.3
  • 12.2.4
  • 12.2.5
  • 12.2.6

Related Articles

Categories: APPS Blogs

New Features in Application Management Pack 13.1.1.1 for E-Business Suite

Wed, 2018-10-31 14:21

Guest Author: Angelo Rosado

We are pleased to announce the release of Bundle Patch 2 for Application Management Pack 13.1.1.1.0 for Oracle E-Business Suite. This is the second update for AMP 13.1.1.1.0, which was released in July 2016.

We strongly recommend that you apply Bundle Patch 2 as listed below, to obtain critical fixes and enhancements:

The patch can be downloaded from My Oracle Support, as shown below:

What's New in Bundle Patch 2?

  • Pre-validate & Discovery support for complex environments
  • EBS Patch Recommendation to report on CPU Patches
  • Enhanced Starting/Ending EBS Blackouts
  • Critical customer bug fixes in the following modules:
    • Discovery
    • Smart Clone
    • Patch Manager
    • Customization Manger

What else is New?

  • Published procedures to Discover & Monitor EBS on Oracle Cloud Infrastructure (OCI):
    • Procedures to install AMP on On-Premises
    • Procedures to Install AMS on OCI
  • Procedures to Discover & Monitor EBS using DB System on OCI:
    • VM DB Single Node System
    • VM DB System RAC
    • Exadata System
  • Certification of Oracle E-Business Suite 12.2.8 with Oracle Application Management Pack 13.1.1.1
  • Certification of Oracle Application Management Pack 13.1.1.1 with Oracle Enterprise Manager 13R3

References

 Related Articles

 

Categories: APPS Blogs

Quarterly EBS Upgrade Recommendations: October 2018 Edition

Tue, 2018-10-30 13:23

We've previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy.   

Here are our latest upgrade recommendations for 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 Note:

Upgrade Recommendations for October 2018

  EBS 12.2  EBS 12.1  EBS 12.0  EBS 11.5.10 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 September 30, 2023

Apply the minimum 12.1 patching baseline
(12.1.3 Family Packs for products in use + latest technology stack updates listed below)

In Premier Support to December 31, 2021

In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline

In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 11i users should be on the minimum 11i patching baseline

Apply the latest EBS suite-wide RPC or RUP

12.2.8
Oct. 2018

12.1.3 RPC5
Aug. 2016

12.0.6

11.5.10.2
Use the latest Rapid Install

StartCD 51
Feb. 2016

StartCD 13
Aug. 2011

12.0.6


11.5.10.2

Apply the latest EBS technology stack, tools, and libraries

AD/TXK Delta 10
Sept. 2017

FND
Apr. 2017

EBS 12.2.6 OAF Update 15
Oct 2018

EBS 12.2.5 OAF Update 20
July 2018

EBS 12.2.4 OAF Update 19
May 2017

ETCC
Aug. 2018

Web Tier Utilities 11.1.1.9

Daylight Savings Time DSTv28
Nov. 2016

Upgrade to JDK 7

Web ADI Bundle 5
Jan. 2018

Report Manager Bundle 5
Jan. 2018

FND
Apr. 2017

OAF Bundle 5
Jun. 2016

JTT Update 4
Oct. 2016

Daylight Savings Time DSTv28
Nov. 2016

Upgrade to JDK 7

 

 

Apply the latest security updates

Oct 2018 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

Oct 2018 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

Oct. 2015 Critical Patch Update April 2016 Critical Patch Update Use the latest certified desktop components

Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements.

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 60

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)

Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 60

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)

    Upgrade to the latest database Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 If you're using Oracle Identity Management

Upgrade to Oracle Access Manager 12c

Upgrade to Oracle Internet 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  11.1.1.9 Migrate to Oracle WebCenter 11.1.1.9 or upgrade to Portal 11.1.1.6 (End of Life Jun. 2017).

 

 
Categories: APPS Blogs

Open Interfaces Now Available from EBS Adapter in Oracle Integration Cloud

Mon, 2018-10-29 18:15

Open Interfaces are available as REST based web services as part of Oracle E-Business Suite Integrated SOA Gateway’s August 2018 update. I am pleased to announce the availability of Open Interfaces from Oracle E-Business Suite Adapter in Oracle Integration Cloud.

Open Interfaces include Open Interface Tables and Interface Views. Depending on direction of Open Interface Table, you will be able to perform CRUD operations on it. That is, you will be able to insert (Create), Read, Update or remove (Delete) data stored in an Open Interface table from Oracle Integration Cloud using EBS Adapter. Also, you will be able to submit the associated concurrent program for validation and further processing. And, you can Read data from Open Interface Views.

This capability is available for Oracle E-Business Suite Release 12.1.3 and E-Business Suite 12.2.3 and onwards.

References

Related Articles

Categories: APPS Blogs

EBS Releases 12.2 and 12.1 Certified with Oracle Solaris 11.4 on SPARC

Fri, 2018-10-26 10:40

The latest version of Oracle Solaris on SPARC, 11.4, is now certified with the following EBS and database releases:

  • Oracle E-Business Suite Release 12.2.3 (or higher) with Oracle Database 12cR1 (12.1.0.2)
  • Oracle E-Business Suite Release 12.1.3 with Oracle Database 12cR1 (12.1.0.2)

Solaris 11.4 offers numerous enhanced features for enterprise deployments, including advanced monitoring, updating, migration and virtualization capabilities.

Running EBS on Solaris 11.4 requires a number of prerequisites and patches. These are described in the documents listed below.

References
Categories: APPS Blogs

Firefox Quantum ESR 60 Certified with EBS 12.1 and 12.2 for macOS High Sierra 10.13

Thu, 2018-10-18 13:04

Mozilla Firefox Quantum Extended Support Release 60 is certified as a macOS-based client browser on macOS High Sierra (macOS 10.13) for Oracle E-Business Suite 12.1 and 12.2.

What Use-cases Are Certified?

Oracle E-Business Suite (EBS) R12 has two interfaces: a web-based (OA Framework/HTML) model for modules like iProcurement and iStore, and Oracle Forms/Java based model for our professional services modules like Oracle Financials.

Firefox Quantum Extended Support Release (ESR) 60.x is now certified with macOS for both web-based and Oracle Forms/Java based models as outlined below.

  • Firefox ESR 60.x is certified for EBS users running web-based (HTML / OA Framework) screens.
  • Firefox ESR 60.x is certified for running Java content in EBS using Java Web Start (JWS) technology.
  • Firefox ESR 60.x is not certified for running Java content in EBS using Java Plug-in technology.

Certified Versions

Oracle E-Business Suite

  • Oracle E-Business Suite 12.2
  • Oracle E-Business Suite 12.1

Desktop Operating System

  • macOS High Sierra (macOS 10.13.3 or higher)

Java Web Start (JWS)

  • JRE 8 Update 171 or higher

While this is the minimum recommended Java release, users are encouraged to upgrade to the latest and therefore most secure Java 8 CPU release available.

Prerequisite Patch Requirements

Running Firefox on macOS using Java Web Start (JWS) with EBS requires additional patching.

For further information on patch and set up requirements see

Implications for Safari 12 on macOS

Customers have been asking about the compatibility of new versions of the following Apple products with Oracle E-Business Suite Releases 12.1 and 12.2:

  • Safari 12 (works with macOS 10.13.6 and 10.12.6)
  • macOS Mojave (macOS 10.14)

Neither of these two products have been certified with either EBS 12.1 or EBS 12.2 as of October 18, 2018.  

Safari 12 is unable to launch Java in the way that prior Safari versions could. This will prevent E-Business Suite 12.1 and 12.2 customers from running Forms-based products. Therefore, customers should *NOT* upgrade to Safari 12 on macOS desktop platforms.

macOS Mojave (macOS 10.14) includes Safari 12. Customers should *NOT* upgrade to macOS Mojave.

What changed in Safari 12?

Safari 12 introduces an important change: it removes support for “legacy NPAPI plug-ins”. This affects all EBS releases. macOS Mojave includes Safari 12.

Some products within Oracle EBS 12.1 and 12.2 run via HTML in browsers. These products are sometimes called “self-service web applications”. They are expected to run without issue in Safari 12, but our certification testing is still underway.

Some products within Oracle EBS 12.1 and EBS 12.2 use Oracle Forms. Oracle Forms requires Java for desktop clients. On the macOS desktop platform, the only certified option today for launching Java is via the JRE plugin via the NPAPI approach.

This means that Safari 12 and macOS Mojave (macOS 10.4) will be unable to use the current JRE plugin-based launching technology for Java and Forms for EBS desktop users.

Recommendations for EBS customers on macOS platforms

As of today, the latest certified versions of Safari and macOS are:

  • Safari 11 (works with macOS 10.13)
  • macOS High Sierra (macOS 10.13)

EBS customers should use only certified configurations. EBS customers who use Forms-based products should avoid upgrading to Safari 12 or macOS Mojave today.

EBS customers who have upgraded to Safari 12 on macOS 10.13 can use Firefox ESR 60 to run Forms-based products via the Java Web Start technology.

What is Mozilla Firefox ESR?

Mozilla offers an Extended Support Release based on an official release of Firefox for organizations that are unable to mass-deploy new consumer-oriented versions of Firefox every six weeks.  For more details about Firefox ESR, see the Mozilla ESR FAQ.

E-Business Suite certified with Firefox Extended Support Releases Only

New personal versions of Firefox on the Rapid Release channel are released roughly every six weeks.  It is impractical for us to certify these new personal Rapid Release versions of Firefox with the Oracle E-Business Suite because a given Firefox release is generally obsolete by the time we complete the certification.

From Firefox 10 and onwards, Oracle E-Business Suite is certified only with selected Firefox Extended Support Release versions. Oracle has no current plans to certify new Firefox personal releases on the Rapid Release channel with the E-Business Suite.

Plug-in Support removed in Firefox ESR 60

Mozilla has removed plug-in support in Firefox ESR 60. This means Firefox ESR 60 cannot run Forms-based content in EBS using the Java plugin method. 

If your Firefox ESR 60 end-users run Forms-based content in EBS, you must switch from the JRE plugin to Java Web Start

EBS patching policy for Firefox compatibility issues

Mozilla stresses their goal of ensuring that Firefox personal versions will continue to offer the same level of application compatibility as Firefox Extended Support Releases. 

Oracle E-Business Suite Development will issue new E-Business Suite patches or workarounds that can be reproduced with Firefox Extended Support Releases.  If you report compatibility issues with Firefox personal releases that cannot be reproduced with Firefox Extended Support Releases, your options are:

  1. Deploy a certified Firefox Extended Support Release version instead of the Firefox personal version
  2. Report the incompatibility between Firefox ESR and Firefox personal to Mozilla
  3. Use Internet Explorer (on Windows) or Safari (on Mac OS X) until Mozilla resolves the issue

EBS Compatibility with Firefox ESR security updates

Mozilla may release new updates to Firefox ESR versions to address high-risk/high-impact security issues.  These updates are considered to be certified with the E-Business Suite on the day that they're released.  You do not need to wait for a certification from Oracle before deploying these new Firefox ESR security updates.

References

Related Articles

Categories: APPS Blogs

Critical Patch Update for October 2018 Now Available

Wed, 2018-10-17 11:57

The Critical Patch Update (CPU) for October 2018 was released on 16 October 2018. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents. 

Supported products not listed in the "Supported Products and Components Affected" Section of the advisory do not require new patches to be applied.

The Critical Patch Update Advisory is available at the following location:

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:

  • 15 January 2019
  • 16 April 2019
  • 16 July 2019
  • 15 October 2019
References Related Articles
Categories: APPS Blogs

New OA Framework 12.2.6 Update 15 Now Available

Tue, 2018-10-16 12:41

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

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 15 (Patch 28739010:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

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. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • When Rich Table Interaction is set to off, data binding for user-customizable properties does not take effect for classic tables.

  • A script error occurs on clicking the Go button in the Web ADI LOV window when selecting the Web ADI template.

  • An enhancement that allows developers to set an accessibility role attribute to a table HTML element.

  • Claim line level descriptive flexfields are not saved on page update.

Related Articles

Categories: APPS Blogs

Tutorial: Configuring Integrated SOA Gateway in Oracle E-Business Suite R12.1.3

Mon, 2018-10-15 11:19

I have being receiving queries about configuring Oracle E-Business Suite Integrated SOA Gateway (ISG). ISG provides REST and SOAP based web service interfaces for public integration APIs registered in Oracle Integration Repository. Here's a quick video that walks through the configuration process:

What is in this tutorial?

In this tutorial, I follow the steps documented in Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (MOS ID 556540.1). This is the main document which lists the required patches and steps to configure EBS R12.1.3 instance for Integrated SOA Gateway.

This tutorial has following major sections:

  • Applying Patches
  • Executing TXK script
  • Enabling ASADMIN user
  • Verifying ISG Setup

This tutorial talks about configuring ISG in single node of EBS R12.1.3. If your EBS R12.1.3 instance is configured with a load balancer, you will be required to perform additional steps mentioned in My Oracle Support Document 1081100.1.

References

Related Articles

 

Categories: APPS Blogs

Oracle E-Business Suite 12.2.8 Now Available

Mon, 2018-10-08 15:21

I am pleased to announce that Oracle E-Business Suite 12.2.8 is now available.

This update includes several significant functional innovations around customer requests and voting, Enterprise Command Centers, user experience, data privacy standards, accounting standards changes, and automation to help customers move EBS environments to Oracle Cloud Infrastructure.

For details about the 2018 innovations, see:

Cliff Godwin talks through the latest innovations and what they mean for customers in this video:

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:

What Does Release 12.2.8 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.8 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:

Common Questions and Answers About Upgrading

  • Q: Is there a direct upgrade path from Release 11i to Release 12.2.8?
    A: No. Release 11i customers must first upgrade to Release 12.2 before applying 12.2.8.
  • Q: Is there a direct upgrade path from EBS 12.0 to 12.2.8?
    A: No. Release 12.0 customers must first upgrade to Release 12.2 before applying 12.2.8.
  • Q: Is there a direct upgrade path from EBS 12.2 to 12.2.8?
  • A: Yes. Release 12.2 customers can apply 12.2.8 directly to their
    environments. EBS 12.2.8 is an online patch, so it can be applied while an existing Release 12.2 system is running.
Additional References Related Articles
Categories: APPS Blogs

New OA Framework 12.2.6 Update 14 Now Available

Thu, 2018-10-04 10:31

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

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 14 (Patch 28183913:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

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. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • The details of an expanded row are not visible in the viewport area when a table has more than 30 rows.
  • On the iSupport Service Request creation page, the length of the Problem Summary data input field is inadequate.
  • Messages filtered for viruses are not added to the confirmation message in a specific product flow.
  • Validation of required fields is not triggered when a new row is added to a table.
  • With the application session language set to Arabic, in the IE 11 browser a popup does not appear when the Delete button is clicked.

Related Articles

Categories: APPS Blogs

Pages