Friday Apr 24, 2015

Best Practices for Optimizing Oracle XML Gateway Performance

Oracle XML Gateway allows you to generate, consume and transport business transaction documents via XML messages from Oracle E-Business Suite (EBS). It uses Oracle Workflow, Business Event System, Oracle Advanced Queuing, and other database components.

Leaving aside the network latency, the performance of XML Gateway’s inbound and outbound message processing depends on sizing and resource allocation of various components on the EBS application and database tiers.

XML Gateway architecture diagram

In Oracle E-Business Suite Release 12.2, we enhanced XML Gateway’s core execution engine for inbound message processing. Now, inbound transactions are mainly processed on the application tier. Outbound transactions are processed on the database tier. 

Our Applications Performance team executed performance tests on XML Gateway R12.2. The test cases involved payloads of varying sizes and concurrent messages. Based on our tests, we have published new performance tuning recommendations for Oracle XML Gateway. It includes sizing of Oracle Workflow listeners, updates of XML Gateway properties,  and tuning of memory and cache settings of OAFM Managed Servers:

References

Related Articles

Tuesday Apr 14, 2015

EBS OA Extensions for JDeveloper Certified with Windows 8.1

Jdeveloper logoWhen you create extensions to Oracle E-Business Suite OA Framework pages, you must use the version of Oracle JDeveloper shipped by the Oracle E-Business Suite product team. 

The version of Oracle JDeveloper is specific to the Oracle E-Business Suite Applications Technology patch level, so there is a new version of Oracle JDeveloper with each new release of the Oracle E-Business Suite Applications Technology patchset. These patchsets must be certified for the desktop operating system that is used to develop the OA Framework extensions. 

The latest updates of the OA Extensions for JDeveloper are certified with Windows 8.1.  There are updates for EBS 12.2.4, 12.2.3, 12.1.3, and 11.5.10.2.

For details, see:

Pending Certifications

The certification of the following Desktop Client tools on Windows 8.1 is still pending:

  • BI Publisher Desktop Tools (formally XML Publisher)
  • Discoverer Administrator/Desktop
  • Sales for Handhelds (Outlook Sync Client)
  • Warehouse Builder Client

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.   

Related Articles

Monday Apr 06, 2015

Reminder: Upgrade EBS 12.2 to FMW 11.1.1.7

Oracle periodically produces Fusion Middleware patchsets -- cumulative collections of fixes -- between major product releases.  All Oracle customers have 24 months to upgrade from the prior patchset when a later patchset is released.  This is called the "grace period."  You cannot request new patches for the prior patchset after the grace period ends.

Where are Fusion Middleware grace periods documented?

The specific grace periods for upgrading from one Fusion Middleware patchset to another are published here:

Do these apply to EBS customers?

Yes.  These dates apply to all Oracle customers, including E-Business Suite customers.  

Which EBS releases are affected?

E-Business Suite 12.2 originally included Fusion Middleware 11.1.1.6 as part of its Rapid Install. Specifically, The Oracle E-Business Suite Release 12.2's Rapid Install delivers three Fusion Middleware (FMW) components:

  1. Oracle WebLogic Server 10.3.6 (this is the "$FMW_HOME") 
  2. Oracle WebTier Utilities 11.1.1.6
  3. Oracle Common Home (Part of Oracle WebTier Utilities 11.1.1.6)

According to the Note above, new patches were released for FMW 11.1.1.6 until April 30, 2014. EBS customers can still download existing patches produced for FMW 11.1.1.6, but no new patches for FMW 11.1.1.6 are being produced now.

What is the impact on EBS 12.2 customers?

EBS 12.2 customers who need new patches for their FMW components must to be on FMW 11.1.1.7. The Oracle WebTier Utilities and the Oracle Common Home should be upgraded by EBS sysadmins to get the latest updates for security, performance, and stability. 

Where can I get these updates?

You can download the latest update for these two components here: 

Here are instructions on how to apply this update to your EBS 12.2 environment:

Related Articles

Tuesday Mar 17, 2015

March 2015 Updates to AD and TXK for EBS 12.2

We continue to release updates to EBS 12.2 technology stack (TXK) and Applications Database (AD) components.  We released the first set of updates in March 2014, the second set in May 2014, the third set in July 2014, the fourth set in October 2014, the fifth set in November 2014, and have now made available a sixth set of critical updates.

If you are on Oracle E-Business Suite Release 12.2, we strongly recommend that you apply these two newly-released patch collections at your earliest convenience:

Delta 6 screenshot

You must always keep your AD and TXK codelevels synchronized. See the following Note for an additional FND patch needed, as well as complete installation instructions:

What's new in these updates?

  • Online Patching support for single file system on development or test systems
  • Integration of EBS Technology Consistency Checker (ETCC) with ADOP
  • Simplification and enhancement of adop console messages
  • Performance improvements in adop operations
  • Improved error reporting by Online Patching Log Analyzer utility
  • Change to default password for spliced products
  • Ability to deregister a custom application
  • Elimination of certain context variables
  • Support for Managed Server Independence Mode
  • Enhancements to Delete Application Tier Node
  • Minimize failures by pre-checking the availability of required ports during cutover phase
  • Removed dynamic generation of portlet.xml file used by Oracle E-Business Suite portlet producer
  • Provision to change passwords during rapid clone
  • Provision for txkSetAppsConf.pl to accept new arguments

What's changed in these updates?

  • Enhanced Rapid Clone
  • Improvements in handling when running ADOP on multiple nodes
  • Improvements to single sign-on functionality
  • Improvements to JVM and Admin server heap size
  • Improved ADOP flow
  • Improvements in ADOP flow communications handling
  • Improvements on Integrated SOA Gateway scripts
  • Support for unlimited number of application tier nodes

What Is a Codelevel?

Oracle E-Business Suite Release 12 patches are grouped into codelines. A codeline begins with a point release (for example, Release 12.0) and progresses to include all the patches created to maintain that point release.

Patches associated with codelines implement a set of features for a point release, and also provide fixes for that set of features. Such a unique set of product features for a point release is referred to as a a codelevel. You can think of it as the code you get when you apply a set of patches: in other words, it is defined by the patches that deliver it. Codelevels are cumulative, with each containing the initial set of features plus all the fixes created for that product.

Benefits of the Latest Codelevel

There are several important reasons you should adopt this latest recommended AD/TXK codelevel:

  • It includes a number of significant fixes and improvements.
  • New patches to implement code fixes will only be appliable to the latest AD/TXK codelevel.
  • No code fixes will be created for earlier AD/TXK codelevels.

How Can I Get To the Latest Codelevel?

Installation instructions are here:

Further information about these updates can be found here:

Related Articles

Thursday Feb 26, 2015

Reminder: Upgrade Database 12.1.0.1 to 12.1.0.2 by July 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 12.1.0.1 Database patchset on July 22, 2015. All EBS customers on Database 12.1.0.1 should upgrade to the Database 12c 12.1.0.2 patchset before then. 

Related Articles

Friday Feb 20, 2015

EBS 12.x certified with Apple Mac OS X 10.10 (Yosemite)

Apple logoOracle E-Business Suite Release 12 (12.1.3, 12.2.4 or higher) is now certified with Apple Mac OS X 10.10 (Yosemite) with the following desktop configuration:

  • Mac OS X 10.10 ("Yosemite" version 10.10.2 or higher)
  • Safari version 8 (8.0.3 or higher)
  • Oracle JRE 7 plugin (1.7.0_72 or higher) and JRE 8 plugin (1.8.0_31 or higher)

Users should review all relevant information along with other specific patching requirements and known limitations posted in:

Related Articles


Monday Feb 16, 2015

Tutorial: Publishing EBS 12.2 PL/SQL APIs as REST Services

Oracle E-Business Suite Integrated SOA Gateway provides REST and SOAP-based web service interfaces for public PL/SQL APIs registered in the EBS Integration Repository.  Here is a video tutorial that walks you through the process of deploying our seeded PL/SQL APIs as REST services in EBS 12.2.4:

Title page for ISG video tutorial

What is in this tutorial?

This step-by-step video tutorial walks you through the following:

  1. Search API in Integration Repository
  2. Deploy API as REST Service
  3. Create Grants for REST Service
  4. Invoke EBS REST Service (in JSON message format)
  5. Verify the result in EBS

This tutorial is recommended for integration architects, developers and implementers working on Oracle E-Business Suite integrations. The steps mentioned in this tutorial apply to Oracle E-Business Suite Integrated SOA Gateway R12.2.3 or R12.2.4 instance configured for REST Services (using My Oracle Support Doc ID 1311068.1).

References

Related Articles

Thursday Feb 12, 2015

Database 12.1.0.2 Certified with E-Business Suite 11i

I’m pleased to announce that 12.1.0.2, the first patchset for Database 12c is now certified with Oracle E-Business Suite 11i. Be sure to review the 11i interoperability note.

Database support implications may also be reviewed in the database patching and support article. 

Screenshot of Database 12.1.0.2 OTN download page

Oracle E-Business Suite Release 11i

Prerequisites
  • 11.5.10.2 + ATG PF.H RUP 7 and higher

Certified Platforms

  • Linux x86-64 (Oracle Linux 5) -- Database-tier only
  • Linux x86-64 (RHEL 5) -- Database-tier only
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only

Pending Platform Certifications

  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 

Database Feature and Option Certifications
The following database options and features are supported for use:

Pending Feature/Option Certifications

  • Active Data Guard
  • Data Guard Redo Apply with Physical Standby Databases

Certifications Not Planned

  • Oracle Multitenant
  • Oracle In Memory Database
  • Oracle Database Vault
  • Transportable Database and Transportable Tablespaces data migration processes

About the pending certifications

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.   

EBS 11i References

Related Articles


Tuesday Feb 10, 2015

EBS 12.2 Certified on Microsoft Windows Server 2012 R2

Microsoft Windows Server logoOracle E-Business Suite Release 12.2 (12.2.3 and higher) is now certified on Microsoft Windows Server 2012 R2. For details, see:

The following editions of Microsoft Windows Server 2012 R2 are certified with Oracle E-Business Suite Release 12.2:

  • Microsoft Windows Server 2012 R2 Standard
  • Microsoft Windows Server 2012 R2 Datacenter

The above operating systems running as guests on Windows Server 2012 Hyper-V are also certified for Oracle E-Business Suite Release 12.2.

Users should also review the Microsoft Windows Server Catalog for information regarding hardware certified or supported with these operating system versions.

Unlike our certification of EBS 12.1.3 on Windows Server 2012 R2, E-Business Suite 12.2 can be installed directly on the platform with the use of the latest startCD (version 49 or higher) with Rapid Install.

Related Articles

Thursday Feb 05, 2015

Reminder: Upgrade Database 10.2.0.5 Before July 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 11.1.0.7 Database patchset on July 31, 2015. There is additional fine print for Severity 1 fixes and other platforms -- see the Note for details.

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Reminder: Upgrade Database 11.1.0.7 Before August 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 11.1.0.7 Database patchset on August 31, 2015. There is additional fine print for Severity 1 fixes and other platforms -- see the Note for details.

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Reminder: Upgrade Database 11.2.0.3 Before August 2015

E-Business Suite customers must ensure that their database remains on a level that is covered by Error Correction Support (ECS) -- i.e. while you can get new patches, Critical Patch Updates (CPU), and Patch Set Updates (PSU).  We've covered this in detail here:

The following Note lists Error Correction Support dates for all database patchsets for all database releases:

That Note shows that patching ends for the 11.2.0.3 Database patchset on August 27, 2015

All EBS customers should upgrade to a later patchset or database release before then.  As of today, options include upgrading to the 11.2.0.4 patchset or Database 12c 12.1.0.2.

Related Articles


Tuesday Jan 27, 2015

EBS Error Correction Policy Updated for EBS 12.2

Oracle provides bug fixes and legislative updates for Oracle E-Business Suite as part of its Premier and Extended Support offerings.  The requirements and methods for delivering those updates are explained here:

We've updated this document with new content for EBS 12.2.  All EBS 12.2 customers should read Version 5 carefully.

EBS support timelines

What is our standard guidance?

Oracle recommends that all customers apply the latest suite-wide Release Update Pack. There are significant benefits to keeping your E-Business Suite environment updated with the latest suite-wide Release Update Packs:

  • They are cumulative, reducing the overhead of identifying many individual patchsets
  • They deliver the latest new features and enhancement requests
  • They include the latest updates for performance, stability, and security
  • They reduce the number of prerequisites required for other patches or new technology integrations

What has changed?

We have added new content that specifies that the minimum patching baseline for the EBS 12.2 base release is the EBS 12.2.3 Release Update Pack and some additional specific AD and TXK patches.

Should you apply later EBS 12.2 patches?

Yes.  As of today, the latest RUP available is the EBS 12.2.4 Release Update Pack

We recommend that all EBS 12.2 customers apply the latest RUP and AD/TXK patches available, even though the minimum level specified in the updated Error Correction is lower.

Related Articles

Monday Jan 26, 2015

Database 12.1.0.1 Certified with EBS 12.2 on Itanium and AIX

As a follow up to our original certification announcement, Oracle Database 12c Release 1 (12.1.0.1) is now certified with Oracle E-Business Suite Release 12.2 (12.2.2 and higher) on the following additional platforms:
  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
This announcement includes:
  • Oracle Database 12cR1 Version 12.1.0.1
  • Oracle Database 12cR1 Version 12.1.0.1 Real Application Clusters (RAC)
  • TDE Column Encryption with Oracle Database 12cR1 Version 12.1.0.1
  • TDE Tablespace Encryption with Oracle Database 12cR1 Version 12.1.0.1
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO) with Oracle Database 12cR1 Version 12.1.0.1
  • Export/Import Process with Oracle Database 12cR1 Version 12.1.0.1

Pending Certifications 

The following are not yet certified and will be announced at a later date once completed.

  • Oracle Multitenant 12cR1 Version 12.1.0.1
  • Oracle Database Vault 12cR1 Version 12.1.0.1
  • Transportable Database and Transportable Tablespaces Data Migration Processes

References

Related Articles



Thursday Jan 22, 2015

Using SHA-2 Signed Certificates with EBS

Secure Hash Algorithms (SHA) are used for a variety of cryptographic purposes including signing of public key infrastructure (PKI) certificates (e.g., code signing cerificates and Secure Socket Layer (SSL) or Transport Layer Security (TLS) server certificates). Currently, the SHA family of functions include SHA-0, SHA-1, SHA-2 and SHA-3. This article and reference notes focus on the use of the SHA256 hash function of SHA-2 with Oracle E-Business Suite.

Why is SHA-2 important to you?

Industry standards for encryption algorithms are constantly under review. Many certificate authorities are recommending or mandating SHA-2 as the minumum signature algorithm for issuing certificates. The time frame for moving to SHA-2 varies depending upon the certificate authority that is used. The requirement for SHA-2 also impacts intermediate certificates which must also be SHA2 in order to chain back to the end-entity SHA-2 certificate issued. Root certificates are not impacted.

When does Oracle E-Business Suite use certificates?

1. HTTPS clients (outbound connections)
HTTPS client connections that originate from Oracle E-Business Suite. For HTTPS clients, you may need to apply product patches to use SHA-2 certificates. Currently, the following products have identified additional requirements to support SHA-2 for HTTPS clients:

  • XML Gateway
    Follow the instructions in the patch README and apply the following patch: 19909850
  • iProcurement
    Follow the instructions for iProcurement in My Oracle Support Note 1937220.1.

In addition to products that initiate outbound connections from java code on the application tier, the Oracle Database may also act as an HTTP client when the UTL_HTTP package is utilized. Some Oracle E-Business Suite products leverage UTL_HTTP for outbound HTTPS connections. You may also use UTL_HTTP for external integrations and customizations.

For the Oracle Database to utilize a PKI (including SHA-2 signed) certificate, SSL/TLS for outgoing connections database connections must be configured.  Our testing in Oracle E-Business Suite development has confirmed that UTL_HTTP is SHA-2 compliant as of Oracle Database 11.1.0.7 (we have not tested with earlier database versions).The steps for enabling and testing SSL/TLS configuration for the Oracle Database are documented in the following:

2. Server Side
In addition to client side (outbound connections), the Oracle E-Business Suite application tier utilizes PKI certificates for code signing by AD Jar Signing and for the (inbound) SSL/TLS termination point using the Oracle HTTP Server.

AD JAR Signing
During patching, Oracle E-Business Suite uses certificates to sign JARs that will be delivered to the browser. As of Java 1.5, Java and its utilities keytool and jarsigner supports SHA-2 certificates. SHA-2 certificates are certified for JAR signing for all versions of Oracle E-Business Suite (11i, 12.0, 12.1 and 12.2) and Java 1.5 and higher.

Oracle HTTP Server (inbound connections)
SHA-2 certificates are also used by the Oracle HTTP server that is delivered with the Oracle E-Business Suite Applications Technology. The requirements for SHA-2 for the Oracle HTTP Server vary per Oracle E-Business Suite version as follows:

  • Oracle E-Business Suite Release 12.2
    SHA-2 certificates are certified with the Oracle HTTP Server delivered with Oracle E-Business Suite 12.2. The wallet management tools that are shipped with EBS 12.2 generate Certificate Signing Requests (CSRs) signed using MD5. The following note has been updated with the steps necessary to create CSRs signed with other algorithms including SHA-2:
  • Oracle E-Business Suite Releases 12.0 and 12.1
    We are currently working on the certification of SHA-2 certificates with the Oracle HTTP Server for Oracle E-Business Suite Release 12.0 and 12.1. As an option while we are working on this certification, you may use an alternate technology (ie, a load balancer, reverse proxy, etc) that supports SHA-2 as the SSL/TLS termination point. Another alternative is to request that your certificate authority issue a SHA-1 certificate.

  • Oracle E-Business Suite Release 11i
    SHA-2 certificates are certified with Oracle E-Business Suite Release 11i when using mod_ssl.so OpenSSL library version 0.98za or later.  To get the minimum mod_ssl.sl library required for EBS 11i and SHA-2, you must apply the July 2014 CPU. Note: We always recommend that you apply the most current CPU available to your environment. You may refer to the following note for additional details:

Related Articles

References

Thursday Jan 08, 2015

Database 12.1.0.2 Certified with E-Business Suite 12.2

I’m pleased to announce that 12.1.0.2, the first patchset for the 12c Database, is now certified with E-Business Suite 12.2.2 and higher. 

Database support implications may also be reviewed in this database patching and support article.

Oracle E-Business Suite Release 12.2.x
Certified Platforms
  • Linux x86-64 (Oracle Linux 5, 6)
  • Linux x86-64 (RHEL 5, 6)
  • Linux x86-64 (SLES 11)
  • Oracle Solaris on SPARC (64-bit) (10, 11) 
  • Oracle Solaris on x86-64 (10, 11)*
*This is a 'database tier only' or 'split tier configuration' certification where the application tier must be on a fully certified E-Business Suite platform.
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit) 
  • IBM AIX on Power Systems (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
Database Feature and Option Certifications
The following database options and features are supported for use:

Pending Feature/Option Certifications

  • Oracle Multitenant
  • Oracle Database Vault
  • TDE Tablespace Encryption
  • Transportable Database and Transportable Tablespaces data migration processes

About the pending certifications

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which will be posted as soon as soon as they're available.  

EBS 12.2 References

Related Articles
The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Wednesday Jan 07, 2015

Oracle VM Templates For EBS 12.2.4 For Exalogic Now Available

We are pleased to announce that Oracle VM Templates for Oracle E-Business Suite 12.2.4 for Exalogic are available for download from the Oracle Software Delivery Cloud:

12.2.4 Exalogic

These VM templates can be imported into the Enterprise Manager Ops Center to deploy E-Business Suite Linux 64-bit environments on Exalogic servers.

Note: The Exalogic Elastic Cloud platform is optimized for the application tier. We recommend that you run databases that experience heavy loads (such as User Acceptance Tests or Production databases) on a machine dedicated for that purpose.

These templates deliver the full EBS software stack, including the Oracle Linux 6.5 operating system, Oracle E-Business Suite, and additional required technology components.

Available Templates

The available Oracle E-Business Suite Release 12.2.4 templates for Exalogic are:

  • VISION Demo Database Tier
  • Production (PROD) Database Tier
  • Application Tier
  • Sparse Application Tier

Usage Tips

An Oracle E-Business Suite Release 12.2.4 for Exalogic installation requires one template for the database tier and another for the primary application tier.

First, choose either the VISION Demo Database template (for a fully-configured demonstration system with sample data) or the Production (PROD) Database template for an empty instance ready for configuration and production deployment. Then choose the Application Tier template.

You can optionally use the Sparse Application Tier template to add a secondary application tier to your new installation or to an existing farm.  Sparse Application Tier templates are small Oracle VM templates that contains an operating system.  Secondary application tiers can be used for EBS web, application, and batch servers.

Technology Components

Operating System

  • Oracle Linux 6 Update 5 operating system

Oracle E-Business Suite Release 12.2.4 VM templates utilize the base Oracle Linux image (OL) 6.5, which requires Oracle Exalogic Elastic Cloud Software (EECS) July 2014 PSU version 2.0.6.1.2 or 2.0.6.0.2 or higher for Exalogic Virtual platforms (Note 1937272.1).

Database

The Vision Demo Database Tier and Production (PROD) Database Tier templates include the following:

  • Database: 11.2.0.4
  • CPU Level: July 2014

Application Tier

The Application Tier template include the following components:

  • Application Tier Code Level: AD and TXK Delta 5 plus Bundle Fixes
  • Oracle Forms and Reports: 10.1.2.3.0
  • Oracle WebLogic Server: 10.3.6.0
  • Web Tier Components: 11.1.1.6
  • JDK: JDK 1.7 build 1.7.0_67-b01
  • Java Plugin: J2SE 1.7
  • CPU Level: July 2014

For additional details and installation instructions, see:

References

Related Articles

Monday Jan 05, 2015

Enhance E-Business Suite Security By Switching to TLS

It seems fitting to start 2015 with a security-related blog post about Secure Socket Layer (SSL) and Transport Layer Security (TLS).  TLS is the successor to SSL. TLS, like SSL, is a protocol that encrypts traffic between applications and servers. TLS is based on SSL 3.0. TLS 1.0 is sometimes referred to as SSL 3.1. Going forward you will hear us talk more about TLS and less about SSL.

TLS is considered to be more secure than SSL.  All systems that use SSL 3.0 may be vulnerable to a design vulnerability in SSL’s handling of block cipher mode padding.  The Padding Oracle on Downgraded Legacy Encryption (POODLE) attack is one possible attack vector for web browsers and web servers.

Oracle E-Business Suite customers can migrate to TLS and mitigate the effects of POODLE attacks by following:

Happy 2015!

.Related Articles

References

Wednesday Dec 31, 2014

2014: A Year in Review for Oracle E-Business Suite

Happy New Year.  2014 was another big year for the Oracle E-Business Suite. 

Did you miss any of the most-important articles of the year?

Upgrading to EBS 12.2

Updates to EBS 12.2

Updates to EBS 12.1

Java

Important Technology Stack Updates

Virtualization

Maintaining and Extending EBS

Support Policies

Friday Dec 26, 2014

Oracle WebTier Utilities 11.1.1.7 Now Certified with EBS 12.2

The Oracle E-Business Suite Release 12.2's Rapid Install delivers three Fusion Middleware (FMW) components:
  1. Oracle WebLogic Server 10.3.6 (this is the "$FMW_HOME") 
  2. Oracle WebTier Utilities 11.1.1.6
  3. Oracle Common Home (Part of Oracle WebTier Utilities 11.1.1.6)

EBS 12.2 technology stack architecture diagram

The Oracle WebTier Utilities and the Oracle Common Home should be upgraded by EBS sysadmins to get the latest updates for security, performance, and stability.

If you'd like to upgrade these two components, you can download the latest update here: 

For instructions on how to apply this update to your EBS 12.2 environment, see:

Related Articles

Wednesday Dec 24, 2014

New Rapid Install StartCD 12.2.0.49 for EBS 12.2 Now Available

We are pleased to announce the availability of the latest Oracle E-Business Suite startCD, 12.2.0.49. As the fundamental installation medium for EBS, the startCD is what you begin with when installing or upgrading to Release 12.2.

This latest version includes many important fixes, which are described in the readme of the startCD patch (listed below). The new startCD is highly recommended for all customers who will use Rapid Install to perform an installation or upgrade to Release 12.2:

Rapid Install Welcome Screen

How to Obtain startCD 12.2.0.49

You can download the startCD as Patch 19378467.

Using Rapid Install

Full instructions for Rapid Install can be found in Oracle E-Business Suite Installation Guide: Using Rapid Install (Part No. E22950_18). This book is available in the EBS Web Library in both PDF and HTML formats.

Additonal References

You should also refer to the following My Oracle Support knowledge documents:

Related Articles

Friday Dec 19, 2014

Preparing Your Customizations for EBS 12.2

EBS 12.2 comes with Online Patching, a fresh new user interface, updated EBS product modules, and new mobile apps.  If you've customized your EBS environment or are using third-party extensions from other vendors, you'll need to ensure that they work with EBS 12.2.

EBS 12.2 New Home Page screenshot

Review the updated development standards

Coding standards, OA Framework capabilities, and, of course, database object development standards  have all been updated in EBS 12.2.  Making your extensions and customizations work with Online Patching is crucial.  Check this comprehensive guide:

Also, if you're interested in taking advantage of the latest user interface (UI) enhancements in EBS 12.2.4, check this Note:

Check your file, data model, and seed data dependencies

The following tools generate detailed reports of the differences between a specific EBS release for files, tables, and seed data. You can drill into the E-Business Suite Technical Reference Manual (eTRM) for details on the database model, database objects, and their relationships, too.

Verify your third-party extensions and tools

Contact your third-party software providers to confirm whether they have updated their EBS extensions or tools to be compatible with EBS 12.2.  This is critical for extensions or tools that are tightly-coupled with the E-Business Suite, i.e. those extensions that modify EBS tables directly. 

Another option is to check whether your Oracle partner has put their software through the Oracle Validated Integration program for EBS 12.2.

Review Guidance for Integrating Custom and Third-Party Products With Oracle E-Business Suite Release 12.2 (Note 1916149.1).  

Related Articles


Thursday Dec 11, 2014

Top 9 Frequently-Asked Questions About Online Patching

Online Patching allows you to apply patches to an EBS 12.2 system while it is still up and  running.  If you're just getting started with Online Patching, you'll find this document useful:

We update this document regularly.  It currently covers frequently asked questions about core Online Patching concepts, resource requirements, functionality, patch application, and handling of customizations and third-party integrations.  We intend to add troubleshooting information to this document soon.

As a preview of that document, here are the top 9 frequently-asked questions about Online Patching:

Which Oracle E-Business Suite releases can Online Patching be used with?
Online patching is used with Oracle E-Business Suite 12.2 and higher.

What types of patch are applied online?
All Oracle E-Business Suite Release 12.2 patches are applied online. This includes one-off patches, patch rollups, consolidated updates and security patches.

What is the Online Patching cycle?
The Online Patching cycle is a sequence of inter-related steps (phases) used to apply patches to an Oracle E-Business Suite system.

EBS 12.2 online patching cycle

What tool is used to apply online patches?
The AD Online Patching (adop) command-line utility is used to manage the Online Patching cycle.

Is there any downtime in Online Patching?
There is a short period of downtime when the application tier services are shut down and restarted. The database remains open all the time.

Do I upgrade to Release 12.2 with Online Patching?
No. After you upgrade to Oracle E-Business Suite Release 12.2, you will enable Online Patching.

Once I upgrade to Release 12.2, can I still apply patches in the traditional way?
No. All patches for Release 12.2 will be online patches. The traditional, pre-12.2 method of applying patches will not work.

Can I still use adpatch in the Release 12.2 Online Patching environment?
No. While the Oracle tools may internally invoke the adpatch utility, direct user invocation of adpatch is not allowed.

Are there any plans to make Online Patching available with pre-12.2 releases?
No. Online patching can only be used with Release 12.2.

Related Articles

Wednesday Dec 10, 2014

Top Three EBS 12.2 Online Patching Resources

Oracle E-Business Suite Release 12.2 introduced Online Patching, a feature that greatly reduces the downtime that was needed in previous releases to apply patches and updates. Online Patching minimizes downtime by allowing patching operations to be performed while users remain on the system.

Online Patching features

  • In Release 12.2, all patching operations are carried out while the applications are in use and users are online. 
  • Patching is performed using the new adop (AD Online Patching) utility.
  • A short period of downtime is required to restart application tier services; the E-Business Suite database does not need to be restarted.

Online Patching EBR editions

Here's the official Online Patching documentation:

Here's our official webcast with a primer on Online Patching:

Here's what you need to do to ensure that your customizations work with Online Patching:

Related Articles

Monday Dec 08, 2014

Last Stop For Oracle Applications Tablespace Migration

The Oracle Applications Tablespace Model (OATM) -- sometimes also called the Oracle E-Business Suite Tablespace Model) -- organizes the EBS database by object type rather than by products.  Prior to OATM, the EBS database had two tablespaces for each product, resulting in hundreds of tablespaces.  OATM contains only twelve locally-managed tablespaces.  This simplifies management and requires fewer operating system files.

Whether you're already using the Oracle Applications Tablespace Model depends on which version of the E-Business Suite you initially installed. If you started on an older EBS release, you have the option of migrating to the Oracle Applications Tablespace Model.

Is OATM mandatory?

No, it's optional, but we recommend that you use OATM.  It's more-efficient and easier to manage.  You can use the OATM Tablespace Migration Utility to migrate to the new model.

Can I use OATM with EBS 12.2?

The OATM Tablespace Migration Utility cannot be used after you enable Online Patching in EBS 12.2.  If you wish to migrate to OATM, you must do so before you enable Online Patching.

If you do not migrate to OATM, you must continue to manage your tablespaces separately after enabling Online Patching.

References


Friday Dec 05, 2014

Oracle Functional Testing Suite Advanced Pack for EBS 12.2.4 Now Available

E-Business Suite Development is pleased to announce the availability of the Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite 12.2.4, a forward-port of the 12.1.3 Advanced Pack announced earlier this year. Designed for use with the Oracle Functional Testing Suite and its Oracle Flow Builder capability, the pack provides pre-built test components and flows for in-depth testing of the following Oracle E-Business Suite products:
  • Oracle Asset Lifecycle Management
  • Oracle Channel Revenue Management
  • Oracle Discrete Manufacturing
  • Oracle Incentive Compensation
  • Oracle Lease and Finance Management
  • Oracle Process Manufacturing
  • Oracle Procurement
  • Oracle Project Management
  • Oracle Property Manager
  • Oracle Service

OATS Flow Builder screenshot

The Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite 12.2.4 complements and extends the starter pack of 3,600 test components and 230 test flows delivered with the Oracle Functional Testing Suite and its Oracle Flow Builder capability. The starter pack components and flows also have been forward-ported to 12.2.4.

Some Background on Automating Testing with Oracle Application Testing Suite and Oracle Flow Builder     

Testing complex packaged applications like Oracle E-Business Suite can be time-consuming and challenging for organizations, hampering their ability to upgrade to latest releases or apply latest patches. Oracle Functional Testing Suite, the functional and regression testing component of the Oracle Application Testing Suite, offers a unique and powerful testing platform for Oracle E-Business Suite and other Oracle applications.

Starting with the 12.3.0.1 release of Oracle Application Testing Suite, we introduced the Oracle Flow Builder testing framework and accompanying starter pack of pre-built test components and flows. Using Oracle Flow Builder, even non-technical testers can create working test scripts using the pre-built components that Oracle provides. Each component represents an atomic test operation such as “create an invoice batch” or “apply an invoice hold.” Testers can assemble the pre-built components into test flows, and combine test flows with spreadsheet data to drive the testing of multiple data conditions. The Oracle Flow Builder framework allows customers to add, modify and extend the pre-built components to address new functionality and customizations of the Oracle E-Business Suite.

Using Oracle Flow Builder’s component-based test generation framework instead of a traditional record/playback approach has allowed the EBS Quality Assurance team to reduce their test automation effort by 60%. E-Business Suite customers can significantly reduce their test automation effort using Oracle Application Testing Suite with Oracle Flow Builder and the pre-built test components and flows that Oracle provides.

Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite Improves Test Coverage

With the new Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite 12.2.4, we are delivering a significant number of additional test components and flows beyond those contained in the Oracle Flow Builder starter pack for 12.2.4. These additional test components and flows provide 70-80% test coverage and enable the automation of detailed and complex test flows across the Oracle E-Business Suite products.

Downloads

You can download the Oracle Functional Testing Suite Advanced Pack for Oracle E-Business Suite from the Oracle Technology Network.

References


Related Articles

Tuesday Nov 11, 2014

E-Business Suite 12.2.4 VM Virtual Appliances Now Available

Oracle VM Virtual Appliances for E-Business Suite Release 12.2.4 are now available from the Oracle Software Delivery Cloud:

OSDC Screen


These virtual appliances deliver the full software stack, including the Oracle Linux 6.5 operating system, Oracle E-Business Suite, and additional required technology components.  They can be imported into Oracle VM Manager to deploy E-Business Suite Linux 64-bit environments on compatible server-class machines running Oracle VM Server, or imported into Oracle VM VirtualBox to create virtual machines on a desktop PC or laptop.

Available Appliances

The available Oracle E-Business Suite Release 12.2.4 virtual appliances are:

  1. Single Node Vision Demo
  2. Vision Demo Database Tier
  3. Production (PROD) Database Tier
  4. Application Tier
  5. Sparse Application Tier

These appliances can be used to support the following scenarios:

  • Single node E-Business Suite 12.2.4 installation: Choose the single node Vision Demo virtual appliance (Option 1 above) to create a unified virtual machine with the EBS 12.2.4 database and application tiers.
  • Multi-node E-Business Suite 12.2.4 installation: Create a multi-node system using the database virtual appliance of choice (either Vision or PROD) and the application tier virtual appliance. That is, Option 2 or 3 above, followed by Option 4.  You can then add secondary application tiers using Option 5.
  • Operating system-only installation (Oracle Linux 6.5): The sparse application tier virtual appliance (Option 5) includes the necessary operating system packages, kernel parameter settings, and users (oracle and applmgr) required to install Oracle E-Business Suite, providing benefit for customers who plan to use Rapid Install for their 12.2.4 installation.

Technology Components

Operating System

All appliances include the Oracle Linux 6 Update 5 operating system.

Database

The Single Node Vision Demo, Vision Demo Database Tier, and Production (PROD) Database Tier appliances include the following:

  • Database: 11.2.0.4
  • CPU Level: July 2014

Application Tier

The Single Node Vision Demo and Application Tier appliances include the following application tier components:

  • Application Tier Code Level: AD and TXK Delta 5 plus Bundle Fixes
  • Oracle Forms and Reports: 10.1.2.3.0
  • Oracle WebLogic Server: 10.3.6.0
  • Web Tier Components: 11.1.1.6
  • JDK: JDK 1.7 build 1.7.0_67-b01
  • Java Plugin: J2SE 1.7
  • CPU Level: July 2014

For additional details and installation instructions, see:

References

Related Articles

Monday Jun 30, 2014

Creating a Maintenance Strategy for Oracle E-Business Suite

We produce new EBS releases, major updates, Family Packs, and over 150 new certified EBS configurations each year.  It can be difficult to track and implement all of these changes.  With so many potential upgrades, what is the best way of keeping your EBS environment up-to-date?

We're very pleased to let you know about a new webcast and Note that can be used together to help you create a maintenance strategy for Oracle E-Business Suite.

1.  Webcast: "Creating a Maintenance Strategy for Oracle E-Business Suite"

The recorded webcast, Creating a Maintenance Strategy for Oracle E-Business Suite,  features techniques Applications DBAs can use to proactively maintain their Oracle E-Business Suite environment. This webcast covers EBS 12.1 and 12.2 and is intended for EBS architects, managers, and system administrators.

Use the following link to view the webcast:

The webcast starts with a practical approach for defining an EBS maintenance strategy. It then moves to a detailed discussion of tools and approaches for maintaining EBS environments.

Topics include patching shortcuts, distributing worker processes across multiple servers, shared file systems, avoiding resource bottlenecks, and more.

2. Note: "How to find EBS patches"

It can be tricky to find the right EBS product-level and technology stack patches that are needed for your environment. This newly published MOS note can help:

This companion Note guides you through the resources that you can use to create your EBS maintenance strategy.


Next Steps

Now that you know about the recorded webcast and MOS note 1633974.2, what should you do next?

  1. Schedule time to view the webcast, ideally with colleagues in your organization who help plan, deploy, and maintain your EBS environments.
  2. After viewing the recording, work with your colleagues to create a maintenance strategy for your Oracle E-Business Suite environment.
  3. As you execute your maintenance strategy, use the Note to find the latest updates for your environment.
Your feedback is welcome

We are very interested in hearing about your experiences with maintaining your EBS environments using these new resources. You can post your comments here or send me an email.

Related Articles


Wednesday Mar 05, 2014

Oracle Database 11.2.0.4 Certified with E-Business Suite 12.2

I'm very happy to announce the certification of Oracle Database 11.2.0.4 with Oracle E-Business Suite 12.2. 

To begin planning your database upgrade to 11.2.0.4, you should review our documentation in this order:

  1. Interoperability Notes: Oracle E-Business Suite 12.2 with Oracle Database 11g Release 2 (Note 1623879.1) 

  2. R12.2 Consolidated List of Patches and Technology Bug Fixes (Note 1594274.1) .  The interoperability note references this note.  It is crucial that you review all requirements in Section 2.2, "Database 11.2.0.4 Patches and Bug Numbers" of this note.

  3. Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1).  Make certain that you review Section 4, "Release-Specific Database Initialization Parameters For Oracle 11gR2" and Section 6, "Additional Database Initialization Parameters for Oracle E-Business Suite Release 12.2".

What does this mean if you are upgrading to R12.2?

  • This upgrade is highly recommended for all EBS 12.2 environments.

  • If you are just beginning your upgrade to R12.2 project, you should consider upgrading to Oracle Database 11.2.0.4 now. 

  • If your are currently in the midst of your R12.2 upgrade, you may continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 as your R12.2 upgrade project and test plans permit.

  • If your go-live date is soon, you may choose to continue as planned with Oracle Database 11.2.0.3 and upgrade to 11.2.0.4 after you go-live with 12.2.

It may be useful to review the the Oracle Database 11gR2 support policies and dates as part of your decision-making process:

Prerequisites

  • 12.2.2 and higher
Certified Platforms
  • Linux x86-64 (Oracle Linux 5, 6)
  • Linux x86-64 (RH 5, 6)
  • Linux x86-64 (SLES 10, 11)
  • Oracle Solaris on SPARC (64-bit)  (10, 11)
  • Oracle Solaris on x86-64 (64-bit) (10, 11) -  Database tier only
  • IBM AIX on Power Systems (64-bit) (6.1, 7.1)
  • HP-UX Itanium (11.31)
Pending Platform Certifications
  • Microsoft Windows x64 (64-bit)
  • IBM: Linux on System z 
Database Feature and Option Certifications
The following database features and options are certified:

Pending Database Feature and Option Certifications

  • Database Vault

About the pending certifications

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.    

References

Related Articles
The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.
About

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
3
4
5
7
9
10
11
12
13
17
18
19
20
23
24
25
26
27
28
29
30
  
       
Today