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 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 the Database 12c codeline -- either 12.1.0.1 or 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 the Database 12c codeline -- either 12.1.0.1 or 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 the Database 12c codeline -- either 12.1.0.1 or 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 may be upgraded by EBS sysadmins to get the latest updates for security, performance, and stability.  These updates are optional for EBS users.

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
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today