Tuesday Aug 09, 2011

Latest DSTv16 Timezone Patches Available for E-Business Suite R12

Hourglass iconIf your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in January 2011 and released as DSTv15.

DSTv16 is now available and certified with Oracle E-Business Suite Release 12. The DSTv16 update includes the timezone information from Olson tzdata 2011g. 

Is Your Apps Environment Affected?

When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:

  • Your Oracle E-Business Suite environment is located in the affected country or region OR
  • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region

We last discussed the DSTv15 patches on this blog. The latest DSTv16 timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv16 includes changes to the following timezones since the DSTv15 release:

  • Africa/Cairo
  • Africa/Casablanca
  • America/Juneau
  • America/Havana
  • America/Santiago
  • Asia/Amman
  • Atlantic/Stanley
  • Europe/Istanbul
  • Pacific/Honolulu
  • Pacific/Easter
  • Pacific/Apia
  • Egypt
  • Cuba
  • Chile/Continental
  • Turkey
  • US/Hawaii
  • Chile/EasterIsland
  • Asia/Istanbul

What Patches Are Required?

In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:

What happened to EBS 11i?

The certification of DST v16 with Oracle E-Business Suite Release 11i is still in progress.  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates. You're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.    

Related Articles

Friday Jul 22, 2011

Reminder: Database 11.1.0.7 Premier Support ends August 2012

It's deja vu all over again.  Since I covered the Error Correction Support (ECS) dates for the 11gR2 Database a few days ago, it's also worth reminding you of an important support milestone for the 11gR2 Database codeline.

Premier Support for Oracle Database 11gR1 (11.1) ends on August 31, 2012.  Extended Support for 11.1 continues to the end of August 2015. These support timelines are covered in the Lifetime Support Policy for Oracle Technology Products.

The 11.1.0.7 patchset is the terminal patchset for the 11gR1 database codeline.  If you're still on the 11.1.0.6 patchset, you should note that Error Correction Support for that ended on September 18, 2009, as detailed here:

If you're not already on 11.2.0.2, we recommend that all Apps customers make plans for a database upgrade soon.

No support exceptions for EBS users

Remember that all Oracle Database support timelines apply to E-Business Suite environments.  There are no special support exemptions for EBS environments.  For an in-depth discussion about how database support timelines affect EBS customers, see:

Related Articles

Tuesday Jul 19, 2011

Reminder: Database 11.2.0.1 Error Correction Support ends Sept. 2011

The Server Technologies division supports the previous release for 12 months after the release of the latest patchset.  The 11.2.0.2 Database patchset was released in Sept 2010.  This means that 11gR2 Database patches produced after September 13, 2011 will require the 11.2.0.2 patchset as a prerequisite.  For more details about patching timelines for individual database patchsets, see:
If you're not already on 11.2.0.2, we recommend that all Apps customers make plans for a database upgrade soon.

No support exceptions for EBS users

Remember that all Oracle Database support timelines apply to E-Business Suite environments.  There are no special support exemptions for EBS environments.  For an in-depth discussion about how database support timelines affect EBS customers, see:
Related Articles

Thursday Jul 14, 2011

Using Audit Vault with Oracle E-Business Suite

Oracle Audit Vault is a database option that automates the collection and consolidation of audit data to support regulatory compliance and reduce security risks.  Audit Vault provides compliance and entitle reports, alert notifications, and centralized audit policy management.  Audit Vault provides compliance reports to address regulatory requirements for database activity monitoring and auditing for:
  • Sarbanes-Oxley (SOX) Act
  • Health Insurance Portability and Accountability Act (HIPAA)
  • Payment Card Industry (PCI) Data Security Standards (DSS)

Conceptual diagram showing audit data tracked by Oracle Audit Vault

 From the Oracle Audit Vault FAQ:

Audit Vault extracts audit records produced by the database's native audit facility so no special certification is required by the application since it is transparent. Any packaged application such as Oracle E-Business Suite, PSFT, Siebel, and SAP work seamlessly with Audit Vault to collect the native audit records.

E-Business Suite suggests that auditing and monitoring of privileged users, user sessions, database links, and database changes is a key element in monitoring and securing your applications. Please see Metalink Note 189367.1. Audit Vault supports all versions of E-Business Suite that sit on top of Oracle database versions 9.2.x forward.

In addition, the Oracle database column, client_identifier, can be used to pass the end application user to the native audit record. E-Business Suite updates client_identifier automatically starting with version 12 of the application, PeopleTools starting with 8.50, and SAP kernal version starting with 7.10. The client_identifier value can be used in the Audit Vault reports to view the application user, OS user, and database connection user information for forensic analysis.

No special setups required for EBS

In other words, you can use Audit Vault's generic documentation for E-Business Suite databases.  No special EBS-specific documentation or setups are required to enable Audit Vault in EBS instances.

Related Articles


Monday Jul 11, 2011

Secure Enterprise Search 11.1.2.2 Certified with E-Business Suite 12

Oracle Secure Enterprise Search 11g 11.1.2.2 is now certified with Oracle E-Business Suite Release 12 (12.1.3 and higher).  Secure Enterprise Search (SES) is an optional add-on to provides additional search capabilities for R12.  Apps users can search for E-Business Suite data using a unified search engine, with search results displayed based upon their Applications responsibilities. 

Screenshot of Asset Inquiry screen using Secure Enterprise Search with EBS

Certified Platforms

Oracle Secure Enterprise Search must be installed on an SES-certified platform while integrating with Oracle E-Business Suite 12.1.3 running on a fully-certified E-Business Suite platform.  It's a bit complex to show the interplay of SES certifications against E-Business Suite certifications here.  You can refer to the Certifications section of My Oracle Support to review both E-Business Suite and Secure Enterprise Search certified configurations.

References

Related Articles


Thursday May 26, 2011

Database 11.2.0.2 Certified with EBS R12 on IBM: Linux on System z

As a follow-on to our original announcement, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher, 12.1.2 and higher) on the following Linux on System z platforms:

Release 12.1 (12.1.2 or higher):

  • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)

Release 12.0 (12.0.4 or higher)1:

  • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
  • Red Hat Enterprise Linux (RHEL) version 4 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)

1: 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. Starting with Release 12.1.2, Linux on System z became a fully certified platform.

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

EBS 12 References
Related Articles

Wednesday May 25, 2011

Database 11.2.0.2 Certified with EBS on HP-UX

As a follow-on to our original announcement, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 (12.0.4 and higher, 12.1.1 and higher) and 11i (11.5.10.2 + ATG PF.H RUP 6 and higher)on the following additional platforms:

Release 12:

  • HP-UX PA-RISC (64-bit) (11.31)

Release 11i:

  • HP-UX Itanium (11.31)1
  • HP-UX PA-RISC (64-bit) (11.31)

1: This OS is a 'database tier only' or 'split tier configuration' platform where the application tier must be on a fully certified E-Business Suite platform.

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

Certification of the following database options and features is still underway:
  • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.2
EBS 11i References
EBS 12 References

Related Articles

Tuesday May 17, 2011

Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release R12 (12.0.4 and higher, 12.1.1 and higher) with Oracle Database 11g Release 2.

Small endian to big endian platform mappings

Obtaining the Required EBS Patch

This migration process requires a patch delivered by the E-Business Suite Platform Engineering team that is 'Controlled', i.e. it requires a password obtainable from Development through Oracle Support. We released the required patch in this manner to potentially monitor customer issues (due to the nature of this technology), to gauge suitability and to monitor uptake. Customers may be required to fill out a questionnaire as part of an evaluation and approval process.

Does it meet your requirements?

Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) on the source platform:

SQL> select platform_name from v$db_transportable_platform;
If the intended target platform does not appear in the output, it means that it is of a different endian format from the source and Transportable Tablespaces (for large databases) or export/import should be used for database migration.

The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. We recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that XTTS is suitable to reduce downtime.

References

Related Articles


Monday May 16, 2011

TDE Tablespace Encryption 11.2.0.2 Certified with E-Business Suite

Oracle Advanced Security is an optional licenced Oracle 11g Database add-on. Oracle Advanced Security Transparent Data Encryption (TDE) offers two different features: column encryption and tablespace encryption. TDE Tablespace Encryption 11.2.0.2 is now certified with Oracle E-Business Suite Release 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) and Release 12 (Releases 12.0.6 and higher and 12.1.1 and higher).

What is Transparent Data Encryption (TDE) ?

Oracle Advanced Security Transparent Data Encryption (TDE) allows you to protect data at rest. TDE helps address privacy and PCI requirements by encrypting personally identifiable information (PII) such as Social Security numbers and credit card numbers.

TDE is completely transparent to existing applications with no triggers, views or other application changes required. Data is transparently encrypted when written to disk and transparently decrypted after an application user has successfully authenticated and passed all authorization checks. Authorization checks include verifying the user has the necessary select and update privileges on the application table and checking Database Vault, Label Security and Virtual Private Database enforcement policies.

Existing database backup routines will continue to work, with the data at rest remaining encrypted in the backup. For encryption of entire database backups, TDE can be used in combination with Oracle RMAN.

What is Tablespace Encryption ?

TDE Key Management architectureNew in Oracle Database 11g, the Oracle Advanced Security now includes support for tablespace encryption.

When a tablespace is created through Enterprise Manager or on the command line, an option now exists to specify that the file be encrypted on the file system. When new data is added to the new tablespace using the insert command or datapump, entire tables will be transparently encrypted. When the database reads data blocks from the encrypted tablespace it will transparently decrypt the data blocks.

With this certification, Oracle E-Business Suite environments can be migrated to the latest 11gR2 version of encrypted tablespaces. For more information, see:

This database option is certified for all EBS platforms on which Oracle Database 11.2.0.2 is certified.  You can refer to the Certifications system on My Oracle Support for details about certified EBS platforms for this database release.

Related Articles



Tuesday May 10, 2011

Database 10.2.0.5 Certified with EBS on Nine Additional Platforms

As a follow-on to the original certification announcement, Oracle Database 10gR2 Patch Set 10.2.0.5.0 is now certified with Oracle E-Business Suite Release 11i and Release 12 (12.0, 12.1) on the following additional platforms:

Release 11.5.10.2 + ATG RUP 6 and higher

  • HP-UX PA-RISC (64-bit) (11.11, 11.23, 11.31)
  • HP-UX Itanium (11.23, 11.31)1
  • IBM: Linux on System z (RHEL 4 and 5, SLES 9 and 10)1
Release 12 (12.0)
  • HP-UX PA-RISC (64-bit) (11.11, 11.23, 11.31)
  • IBM: Linux on System z (RHEL 4 and 5, SLES 9 and 10)1
Release 12 (12.1)
  • HP-UX PA-RISC (64-bit) (11.23, 11.31)
  • IBM: Linux on System z (RHEL 5, SLES 9 and 10)
1: This is a database tier only (or split tier) configuration where the application tier must reside on a different fully certified E-Business Suite platform

This announcement includes:
  • Oracle Database Vault
  • Transparent Data Encryption (Column Encryption)
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
  • Export/Import Process for Oracle E-Business Suite Release 11i and Release 12 Database Instances
EBS 12 References
EBS 11i References

Related Articles

Monday May 09, 2011

Oracle Database 11gR2 11.2.0.2 Certified with EBS on Microsoft Windows

As a follow-on to our 11.2.0.2 certification announcement late last year, Oracle Database 11g Release 2 (11.2.0.2) is now certified with Oracle E-Business Suite Release 12 and 11i on the following Microsoft Windows platforms:

Release 12.1.1 and higher
  • Microsoft Windows Server (32-bit) (2003, 2008)
  • Microsoft Windows x64 (64-bit) (20031, 20081, 2008 R22)
Release 12.0.4 and higher
  • Microsoft Windows Server (32-bit) (2003)
  • Microsoft Windows x64 (64-bit) (2003, 2008, 2008 R2)1
Release 11.5.10.2 + ATG PF.H RUP 6 and higher
  • Microsoft Windows Server (32-bit) (2003)
  • Microsoft Windows x64 (64-bit) (2003, 2008)1
1: This OS is a 'database tier only' or 'split tier configuration' platform where the application tier must be on a fully certified E-Business Suite platform.
2: This OS is a 'database tier only' platform for Release 12.0. For 12.1.1 or higher, it is also supported on the application tier via the migration process outlined in My Oracle Support Document 1188535.1.

This announcement for Oracle E-Business Suite R12 and 11i includes:
  • Oracle Database Vault
  • Transparent Data Encryption (Column Encryption)
  • Advanced Security Option (ASO)/Advanced Networking Option (ANO)
  • Export/Import Process for Oracle E-Business Suite Release 11i and Release 12 Database Instances
EBS 11i References
EBS 12 References
Related Articles

Tuesday Jan 25, 2011

Database 10gR2 10.2.0.5 Certified with EBS on 14 Additional Platforms

Somehow this certification that was completed last year missed out as a blog article (though it was updated at the time in our official Certifications matrix on My Oracle Support). 

As a follow-on to our original certification announcement, Oracle Database 10gR2 Patch Set 10.2.0.5.0 is certified with Oracle E-Business Suite Release 11i and R12 on the following additional platforms:

Platforms certified for 11i (11.5.10 CU2+ATG_PF.H.delta.6 (RUP 6) and higher)

  • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
  • Oracle Solaris on SPARC (64-bit) (8, 9, 10)
  • Oracle Solaris on x86-64 (64-bit) (10) (See Note 1)

Platforms certified for R12 (12.0.4 and higher) and 12.1 (12.1.1 and higher):

  • HP-UX Itanium (11.23, 11.31)
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
  • Oracle Solaris on SPARC (64-bit) (8, 9, 10)
  • Oracle Solaris on x86-64 (64-bit) (10) (See Note 1)

Screencap of download screen for 10 2 0 5 database patchset page 10205-download.png


Notes

  1. This is a split configuration certification where the application tier must be on a fully certified E-Business Suite platform.

Certified Database Options

This database patchset certification also includes the following 10gR2 10.2.0.5 database options:

  • Real Application Clusters
  • Oracle Database Vault
  • TDE Column Encryption
  • Advanced Security Option/Advanced Networking Option (ANO/ASO) 
Should You Upgrade to This Release?

There are two important considerations if you're deciding whether to upgrade to this release.  The first:  Premier Support for 10gR2 ended in July 2010.  The second: Error Correction Support for 10.2.0.4 ends in April 2011 -- in three months.  For more details about what this means for E-Business Suite environments, and recommendations, see this article:
EBS 12 References
EBS 11i References
Related Articles

Friday Jan 21, 2011

Upgrading EBS 12 to DB 11g with Physical Standby Enabled

It's possible to use Oracle Data Guard to create physical standby databases for disaster recovery.  E-Business Suite users can configure their environments with the latest version of Oracle Data Guard 11g by following the documents linked in this article:
When upgrading a database to a new release, you can upgrade the Data Guard Physical Standby database inline to minimize the downtime. To achieve this in an EBS 12 environment, additional manual configuration steps are needed on both the primary and standby systems.  These manual steps allow redo to be shipped from the primary and applied on the standby during the upgrade.

Diagram showing synchronization of primary and data guard physical standby environments  dataguard2.JPG
After the upgrade, the primary and physical standby will be in sync, and the physical standby should be reconfigured using AutoConfig.

We have now published EBS 12-specific documentation covering this upgrade scenario for both 11gR1 and 11gR2 databases: Related Articles

Thursday Jan 20, 2011

Reminder: Error Correction Support for DB 10gR2 10.2.0.4 Ends April 30, 2011

Experienced Apps DBAs know that they need to monitor database support windows for their E-Business Suite environments.  For an in-depth discussion about how database support policies affect E-Business Suite users, see:
An important deadline is approaching if you're still running any E-Business Suite release on the 10gR2 10.2.0.4 database.  New 10gR2 patches produced after April 30, 2011 will require 10.2.0.5.  No new patches will be produced for 10.2.0.4 after that date. 

This is covered, along with other useful topics, in the following 10gR2 Support FAQ from my colleagues in the Server Technologies division:

Another important point from that FAQ:
8. Will I get more time to install 10.2.0.5 if it is released on my platform close to April 30, 2011?

Yes.  We will always support the previous patch set for at least 3 months, even if it is released after the one year to install the new patch set is up.  For example, patching for 10.2.0.4 generally expires on April 30, 2011.  If you are running 10.2.0.4 on the Commodore 64 platform and Oracle releases it after April 30, 2011, we will still patch 10.2.0.4 for you for 3 months following the 10.2.0.5 release on your platform.
Advice for EBS sysadmins

If you're still running your EBS environment on the 10.2.0.4 database, here are your options (in order of greatest bang-for-your-upgrade-buck):
  1. Upgrade to 11.2.0.2.  It's the latest 11gR2 database version certified with the E-Business Suite. Upgrading to this level will buy you the longest period before you're forced to do another database upgrade.
  2. Upgrade to 11.1.0.7.  It's the latest 11gR1 database version certified with the E-Business Suite.  Looking at this pragmatically, though, I don't see much value in upgrading to 11gR1.  If you're going to go to the trouble of upgrading from 10gR2 10.2.0.4 to a newer major database release, you might as well do it right and upgrade to 11.2.0.2.
  3. Upgrade to 10.2.0.5.  If you're planning on staying on 10gR2 for a while, you should be on a release for which you can get new patches and security fixes.
Related Articles

Wednesday Jan 19, 2011

E-Business Suite Release 12 Certified With Microsoft Windows Server 2008 R2 (Windows x64)

windows-logo.jpg
I am pleased to announce that Oracle E-Business Suite Release 12 (12.1.1 or higher) is now certified with Microsoft Windows x64 (64-bit) on both the application and database tiers through a certified migration of an existing Release 12 installation. Microsoft Windows Server 2008 R2 is a Windows x64 (64-bit) only operating system and is the latest Windows server version.

Support of the E-Business Suite on this platform is achieved by a two-step process of migrating the Oracle Database first (as documented in the 11gR2 Database Tier Only Platform note), and then migrating the application tier using the process documented in the R12 Rapid Clone note. These steps and all requirements are outlined in:
The operating systems certified on this platform are:
  • Microsoft Windows Server 2008 R2 Standard
  • Microsoft Windows Server 2008 R2 Enterprise
  • Microsoft Windows Server 2008 R2 Datacenter
  • Microsoft Web Server 2008 R2
Oracle E-Business Suite does not support Hyper-V and Server Core in Windows Server 2008 R2. Please review the documents below for all requirements and additional details on the use of EBS on this new platform.

A number of external technology components are also certified with E-Business Suite R12 on this platform such as Oracle Internet Directory 11g, Oracle Discoverer 11g, Oracle Portal 11g, etc. Please review the Certifications tab on My Oracle Support for current information on platform support and certifications.

References
Related Articles

Wednesday Jan 12, 2011

Latest DSTv15 Timezone Patches Available for E-Business Suite

Wooden_hourglass_small2.jpg
If your E-Business Suite Release 11i or 12 environment is configured to support Daylight Saving Time (DST) or international time zones, it's important to keep your timezone definition files up-to-date. They were last changed in July 2010 and released as DSTv14. DSTv15 is now available and certified with Oracle E-Business Suite Release 11i and 12.

Is Your Apps Environment Affected?

When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:
  • Your Oracle E-Business Suite environment is located in the affected country or region OR
  • Your Oracle E-Business Suite environment is located outside the affected country or region but you conduct business or have customers or suppliers in the affected country or region
We last discussed the DSTv14 patches on this blog. The latest "DSTv15" timezone definition file is cumulative and includes all DST changes released in earlier time zone definition files. DSTv15 includes changes to the following timezones since the DSTv14 release:
  • Africa/Cairo 2010 2010
  • Egypt 2010 2010
  • America/Bahia_Banderas 2010 2010
  • Asia/Amman 2002
  • Asia/Gaza 2010 2010
  • Europe/Helsinki 1981 1982
  • Pacific/Fiji 2011
  • Pacific/Apia 2011
  • Hongkong 1977 1977
  • Asia/Hong_Kong 1977 1977
  • Europe/Mariehamn 1981 1982
What Patches Are Required?

In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.

We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:
Related Articles

Thursday Jan 06, 2011

Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

For most Oracle Database users, Oracle Active Data Guard allows users to:
  1. Create a physical standby database for business continuity and disaster recovery
  2. Offload reporting from the production database to the read-only physical standby database
E-Business Suite customers have been able to use Active Data Guard to create physical standby databases for their EBS environments since the feature was introduced with the 11g Database.  EBS sysadmins can use the generic Active Data Guard documentation to take advantage of the Active Data Guard standby database capabilities. 

I am pleased to announce that it is now possible to offload a subset of some ReportWriter-based reports -- but not all -- from a production EBS environment to an Active Data Guard physical standby database.  But before I go into the details of this newly-certified configuration, it's necessary to understand some details about what happens whenever someone attempts to access the E-Business Suite.

adg_diagram.png

Behind the scenes: logging into the E-Business Suite

Every E-Business Suite user is assigned one or more responsibilities.  These responsibilities govern the E-Business Suite applications (i.e. menu functions) and data that a given user can access.  For example, as a manager, I might be assigned responsibilities that allow me to review my employees' compensation and approve their expense reports.  I'm also an employee, which means that I can review my own payslips and file new expense reports.

Every time anyone logs into a running E-Business Suite instance, the following things happen:

  1. Their authenticated credentials are checked against their assigned E-Business Suite responsibilities.
  2. A user session is created in the E-Business Suite database.
  3. All activities are logged for audit and tracking purposes, even queries against existing data.

This level of security prevents E-Business Suite unauthorized users from, say, assigning stock options to themselves.  It also provides an audit trail in case someone abuses their position by attempting to cook the books in the midst of a financial industry meltdown.

This also applies to the use of external reporting tools like Oracle Discoverer.  Discoverer users must log into the E-Business Suite instance, which checks their assigned responsibilities to prevent users from running reports against data that they're unauthorized to view.

What does that mean?

Putting this together: 

  • Active Data Guard makes a read-only replication of a given database. 
  • Even the simple act of logging into an E-Business Suite database requires write access.
What's Changed in this new Active Data Guard certification?

In this new certification, it is possible to run a subset of the standard Oracle Reports delivered with the E-Business Suite against the Active Data Guard instance.  In some cases, EBS reports also perform writes against the database; those reports will not run in this Active Data Guard configuration.

We've made the following changes to support this new configuration:
  1. Created new Active Data Guard database triggers to redirect minimal required read/write activity back to the primary E-Business Suite database. 
  2. Introduced changes within the E-Business Suite's FND layer to support this new functionality.
  3. Developed Parallel Concurrent Processing configurations to manage the report executions against Active Data Guard.
Technical Prerequisites

This configuration requires the following prerequisites:
  • Oracle E-Business Suite Release 12.1.3 or later
  • Oracle Database 11.1.0.7 or 11.2.0.2 with the Active Data Guard database option
Getting access to this new configuration

Given the new state of this configuration, we'd like to stay very close to customers implementing this in their E-Business Suite environments.  Although the documentation is published externally, the required EBS patches are currently being distributed in a controlled availability release.  To get access to these patches, please log a formal Service Request with Oracle Support to request a password to access this patch.  While working with Oracle Support to obtain the password, you should also send an email to "ebs_adgrel_us at oracle.com" so that we can monitor your Service Request in Development.

References
Related Articles

Wednesday Dec 29, 2010

New Whitepaper: Oracle E-Business Suite on Exadata

[Dec. 30, 2010 Update: Added link to Note 1133355.1]

Our Maximum Availability Architecture (MAA) team has quietly been amassing a formidable set of whitepapers about the Oracle Exadata Database Machine.  They're available here:
If you're one of the lucky ones with access to this hardware platform, you'll be pleased to hear that the MAA team has just published a new whitepaper with best practices for EBS environments:
exadata_v2_feature_main.png
This whitepaper covers the following topics:
  • Getting to Exadata -- a high level overview of fresh installation on, and migration to, Exadata Database Machine with pointers to more detailed documentation
  • High Availability and Disaster Recovery -- an overview of our MAA best practices with pointers to our detailed MAA Best Practices documentation
  • Performance and Scalability -- best practices for running Oracle E-Business Suite on Exadata Database Machine based on our internal testing
As an added bonus, the whitepaper has details about the internal testbeds where this configuration was evaluated with Oracle's own 18 TB Global Single Instance.  The whitepaper's Appendix discusses Exada Smart Flash Cache results, Smart Scan, RAC, and RMAN backup performance.

Need an Overview of Migration Options?

Also useful:  A summary of the different technologies and techniques that you can use to migrate your E-Business Suite database to Exadata can be found here:
That overview Note provides a short but precise analysis of physical migration techniques (e.g. Data Guard Physical Standby, Transportable Database, Transportable Tablespaces, Rapid Clone) vs. logical migration techniques (e.g. Oracle Data Pump).

Related Articles


Friday Dec 17, 2010

Is RAC One Node Certified for E-Business Suite?

Oracle Real Application Clusters (RAC) is a cluster database with a shared cache architecture that supports the transparent deployment of a single database across a pool of servers.  RAC is certified with both Oracle E-Business Suite Release 11i and 12.  We publish best-practices documentation for specific combinations of EBS + RAC versions.  For example, if you were planning on implementing RAC for EBS 12, you would use this documentation:
Many of the largest E-Business Suite users in the world run RAC today, including Oracle; see this Oracle R12 case study for details.

A number of customers have recently asked whether RAC One Node can be used with the E-Business Suite.  From the RAC website:
Oracle RAC One Node is a new option available with Oracle Database 11g Release 2. Oracle RAC One Node is a single instance of an Oracle RAC-enabled database running on one node in a cluster.

Diagram of RAC One Node database migration between nodes rac_one_node.png

RAC ONE Node is supported as a cold failover solution for E-Business Suite environments.  We don't support live node migration; the E-Business Suite does not have code-level support for Fast Application Notification (FAN) events at present. 

Is there RAC One Node documentation for EBS environments?


No, we do not explicitly certify or document E-Business Suite configurations.  You can follow the generic RAC One Node documentation to implement this in E-Business Suite environments.  If you're interested in using this technology with the E-Business Suite, you're advised to run proof-of-concept tests prior to a production deployment to ensure that it meets your operational requirements.

Related Articles


Friday Dec 10, 2010

E-Business Suite Certified with DB 11.2.0.2 on HP-UX Itanium and IBM AIX on Power

As a follow-on to our previous certification announcement, Oracle Database 11g Release 2 (11.2.0.2) s now certified with Oracle E-Business Suite Release 12 (12.0.x and 12.1.x) and 11i (11.5.10.2 + ATG PF.H RUP 6 and higher) on the following additional platforms:

Oracle E-Business Suite Release 12
  • HP-UX Itanium (11.31)
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
Oracle E-Business Suite Release 11i
  • IBM AIX on Power Systems (64-bit) (5.3, 6.1)

db_11202_screenshot.png

This announcement for Oracle E-Business Suite R12 and 11i includes:
Pending Certifications
  • Transparent Data Encryption (TDE) Tablespace Encryption
  • Other platform certifications are pending and awaiting the availability of this patchset on the platform, including:
    • HP-UX PA-RISC (64-bit)
    • Microsoft Windows Server (32-bit)
    • IBM: Linux on System z 
  • 'Split tier' or 'database tier only' certifications on:
    • AIX 7 (R12)
    • HP-UX Itanium 11.31 (11i)
    • Microsoft Windows x64 (64-bit) (R12)
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
EBS 12 References
Related Articles

Thursday Dec 02, 2010

Maintaining Your EBS Environment for Maximum Performance

I think that all E-Business Suite DBAs know that they need to apply a number of interoperability patches when upgrading from one database release to another.  These are documented in our Interoperability Upgrade Notes for a given EBS + database combination.  For example, if you're upgrading Oracle E-Business Suite Release 12 to the latest 11gR2 11.2.0.2 database, you'd apply the patches listed here:
However, I don't think it's as widely-known that there are two other classes of patches that you might need to apply.  These are documented in the following two Notes:
  1. Oracle E-Business Suite Recommended Performance Patches (Note 244040.1)
  2. Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1)

Performance benchmark graph for EBS 12 1 2 cpu_load.png


What are E-Business Suite "recommended performance patches"?

Oracle E-Business Suite Recommended Performance Patches (Note 244040.1) is written and maintained by our Applications Performance team.  I've covered this team's responsibilities previously, but to recap: this team is dedicated to optimizing the performance of the E-Business Suite.  They perform all of our E-Business Suite benchmarks and high-volume scalability testing, and they work intensively with our largest E-Business Suite customers in fine-tuning E-Business Suite configurations. 

They've summarized all of their hard-won expertise about performance-related patches in a single document.  A major part of this document covers database patches, but that's not all.  It also covers performance-related patches for:
  • Client tools
  • Applications Technology products and components
  • Financials products
  • Manufacturing and Supply Chain products
  • Human Resources products
  • Sales & Marketing products
This should be your first stop after upgrading your database or if you're trying to nail down a troublesome database performance-related issue.  I consider this mandatory reading for all E-Business Suite DBAs.

Do you want to apply database Patch Set Updates?

Our Server Technologies division began releasing quarterly database Patch Set Updates (PSU) in July 2009.   Patch Set Updates include:
  • Field-tested fixes for critical technical issues that may affect a large number of customers
  • Critical Patch Update fixes
Database Patch Set Updates are optional for E-Business Suite users.  If you choose to use them, database Patch Set Updates may safely be applied to Oracle E-Business Suite Release 11i and 12 environments.  Patch Set Updates are fully compatible and supported for use with the E-Business Suite.  Depending upon the database version and Oracle E-Business Suite release, one or more overlay patches may be required to address conflicts with a specific Oracle Database Patch Set Update.

Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Note 1147107.1) summarizes the latest overlay patches required when applying Database Patch Set Updates to Oracle E-Business Suite environments running on the 10gR2, 11gR1, and 11gR2 databases.  If you use PSUs with your EBS database, you should review this Note on a regular basis.

Related Articles

Tuesday Nov 30, 2010

EBS 11i Extended Support Starts December 2010 with Minimum Patching Baselines

[Editor: This article was originally published in January 2010, and again in August 2010.  Reposting this article in its entirety with small modifications to emphasize the date.]

Premier Support for Oracle E-Business Suite Release 11i ends today, November 30, 2010. Extended Support for EBS 11i begins tomorrow, December 1st, 2010.

Extended Support comes at an additional cost, but these are waived for Oracle E-Business Suite Release 11i through November 2011. I'm in EBS Development and not sales, so you should contact your Oracle account manager with questions about Extended Support costs. 

Here is a comparison of the different support levels:

A new set of minimum technical requirements for Apps 11i goes into effect when Extended Support begins in December 2010.  These new minimum baseline patch requirements are listed in:
What are the impacts of this new baseline?

As always, Oracle Support will assist with diagnosis, triage, and debugging of any issues that you report for your E-Business Suite environment.  You will continue to have access to any existing online support tools, knowledge base documentation, and pre-existing fixes.

If you report a new issue that requires a new bug fix, you should be aware that new patches will be released only for the new baseline patches listed in the Minimum Baseline Patch Requirements Note.  You should plan to apply the baseline patches (at minimum) listed in Note 883202.1 by November 2010 in order to receive any new bug fixes.

Minimum Baseline Patch Requirements
  • Oracle E-Business Suite Release 11.5.10 Consolidated Update 2 plus additional patches listed in Note 883202.1
  • ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765)
  • 10.2.0.4 Database or 11.1.0.7 Database
  • Forms6i Patchset 19 (version 6.0.8.28, Patch 6194129)
  • Oracle HTTP Server MLR Patchset 4393827
  • Sun Java Runtime Engine (JRE) 1.6.0_03 or higher
The baseline versions listed here (and in the Note) are current as of the document's release date but may change in the future.  Any changes will be communicated via Note 883202.1.  If you've found this article as the result of a web search, I would strongly encourage you to check the latest version of the Note for the current information.

What EBS 11i products are affected by this new baseline?

In addition to the major technology stack components shown above, Note 883202.1 contains additional minimum baseline requirements for:
  • Applications Technology
    • Common Applications Calendar
  • Contracts
    • Core Contracts
    • Procurement Contracts
    • Project Contracts
    • Sales Contracts
    • Service Contracts
  • Customer Data Management
    • Customers Online
    • Trading Community
  • Financials
    • Assets
    • iAssets
    • Advanced Collections
    • Bill Presentment Architecture
    • Cash Management
    • E-Business Tax
    • Financials for the Americas
    • Financials for Asia/Pacific
    • Financials Common Country
    • Financials for EMEA
    • Financials for India
    • Internet Expenses
    • Lease Management
    • Loans
    • Payables
    • Payments
    • Property Manager
    • Public Sector Budgeting
    • Public Sector Financials
    • Public Sector Financials (International)
    • Receivables
    • iReceivables
    • Treasury
    • U.S. Federal Financials
  • Human Resources
    • Advanced Benefits
    • Approvals Management
    • HR Intelligence
    • Human Resources
    • Labor Distribution
    • Learning Management
    • Payroll (All Localizations)
    • Payroll (International/Custom)
    • iRecruitment
    • Self-Service Human Resources
    • Time and Labor
    • US Federal Human Resources
  • Intelligence
    • Balanced Scorecard
    • E-Business Intelligence
  • Interaction Center
    • Customer Interaction History
  • Logistics
    • Inventory Management
    • Warehouse Management
  • Manufacturing
    • Cost Management
    • Quality
    • Supply Chain Globalization
    • Work in Process
  • Marketing and Sales
    • Incentive Compensation
    • Marketing
    • Partner Management
    • Quoting
    • Sales
    • Sales for Handheld
    • Sales Offline
    • Territory Management
    • Trade Management
  • Order Management
    • Advanced Pricing
    • Configurator
    • Order Capture
    • Order Management
  • Procurement
    • iProcurement
    • Purchasing
    • Sourcing
    • iSupplier Portal
    • Supplier Scheduling
  • Product Lifecycle Management
    • Advanced Product Catalog
    • Bills of Material
    • Document Management and Collaboration
    • Engineering
    • Item Master
  • Projects
    • Grants Accounting
    • Project Billing
    • Project Collaboration
    • Project Costing
    • Project Portfolio Analysis
    • Project Foundation
    • Project Resource Management
    • Projects
  • Service
    • Advanced Scheduler
    • Complex Maintenance, Repair & Overhaul
    • Customer Care
    • Depot Repair
    • Field Service
    • iSupport
    • Teleservice
  • Supply Chain Planning
    • Demand Planning
    • Production Scheduling
    • Strategic Network Optimization
Related Articles

Sunday Nov 28, 2010

Using Two New Oracle Database 11gR2 Features With EBS

ORACLE_DB11G_CLR.GIF

With the recent announcement of Oracle Database 11gR2 (11.2.0.2) certification with Oracle E-Business Suite, we've also certified two new features with the E-Business Suite to make your life a little easier.

These two new features are:

  1. The Single Client Access Name (SCAN) feature that was introduced with the Oracle Database 11g Release 2 Grid Infrastructure to simplify client access to database services.

  2. No need to disable Fast Validation before performing Applications maintenance or upgrade operations.

Single Client Access Name support for EBS environments

Single Client Access Name (SCAN) is an Oracle Real Application Clusters (RAC) 11gR2 feature that provides a single name for clients to access Oracle databases running in a cluster. This means that the client's connect information can remain the same if cluster nodes are added or removed.

The SCAN feature is now certified for use with the EBS AutoConfig configuration management tool, and can be deployed with EBS by following the steps below.

  1. Meet the configuration prerequisites for using the SCAN listener, as per My Oracle Support Knowledge Document Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 (Doc ID  823587.1).

  2. Set the following AutoConfig parameters as shown below:
    • s_scan_name = <SCAN Name>
    • s_scan_port = <SCAN Port>
    • s_update_scan = <TRUE>
  3. Run AutoConfig on the EBS database tier to create SCAN configuration files on that tier.

  4. Run AutoConfig on the application tier to create SCAN configuration files on that tier.

No Need to Disable Fast Validation

With database versions prior to Oracle 11gR2 (11.2.0.2), you needed to disable Fast Validation in the database when performing Applications upgrades or maintenance operations.

To disable Fast Validation, you needed to add the following parameter to the database initialization parameter file:

_disable_fast_validate=TRUE

Failing to set this in Oracle Database 11gR1 (11.1.0.7) or 11gR2 (11.2.0.1) could lead to invalid objects and forms or reports compilation failures, potentially causing problems with product functional flows.

Starting with 11gR2 (11.2.0.2), this parameter no longer needs to be set for upgrade or maintenance operations (and then unset again for normal operations).  This is one less thing for you to have to remember.

References

Related Articles

Monday Nov 15, 2010

11gR2 11.2.0.2 Database Certified with E-Business Suite

[Jan 20, 2011 Update: Removed erroneous Linux x86-64 SLES 9 database tier reference]

[Nov 18, 2010 Update: Added HP-UX Itanium to the EBS 11i list of pending certifications]


We certified the 11gR2 11.2.0.1 Database with E-Business Suite 11i and EBS 12 late in 2009.  It's taken a little longer than we had hoped to certify 11.2.0.2, the first patchset for the 11gR2 Database.  The reasons: the release cycle for 11.2.0.2 overlapped with our EBS 12.1.3 release cycle, and some of the ports for this patchset weren't released until just before Halloween.  Our Server Technologies team is as-yet working on other ports, too.

I know that some of you have been eager to apply this latest patchset to your E-Business Suite databases, so I'm very pleased to announce that Oracle Database 11gR2 Patchset 1 Version 11.2.0.2 is now certified with the E-Business Suite. 

Screenshot of 11-2-0-2 11gR2 database patchset 1 Patchset 10098816 download page db_11202_screenshot.png

Oracle E-Business Suite Release 11i
Prerequisites
  • Oracle E-Business Suite Release 11.5.10.2
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5) -- Database-tier only
  • Linux x86-64 (RHEL 4, 5) -- Database-tier only
  • Linux x86-64 (SLES 10--Database-tier only)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10) -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows Server (64-bit)
  • HP-UX PA-RISC (64-bit)
  • HP-UX Itanium
  • IBM: Linux on System z 
  • IBM AIX on Power Systems
Oracle E-Business Suite Release 12
Prerequisites
  • Oracle E-Business Suite Release 12.0.4 or later; or,
    Oracle E-Business Suite Release 12.1.1 or later
Certified Platforms
  • Linux x86 (Oracle Linux 4, 5)
  • Linux x86 (RHEL 4, 5)
  • Linux x86 (SLES 10)
  • Linux x86-64 (Oracle Linux 4, 5)
  • Linux x86-64 (RHEL 4, 5)
  • Linux x86-64 (SLES 10)
  • Oracle Solaris on SPARC (64-bit) (10)
  • Oracle Solaris on x86-64 (64-bit) (10)  -- Database-tier only
Pending Platform Certifications
  • Microsoft Windows Server (32-bit)
  • Microsoft Windows Server (64-bit)
  • HP-UX PA-RISC (64-bit)
  • IBM: Linux on System z
  • IBM AIX on Power Systems
  • HP-UX Itanium
Database Feature and Option Certifications
The following 11gR2 11.2.0.2 database options and features are supported for use:
Certification of the following database options and features is still underway:
  • Transparent Data Encryption (TDE) Tablespace Encryption 11gR2 version 11.2.0.2
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
EBS 12 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.

Thursday Nov 11, 2010

Using Physical Standby for EBS 12 Environments on 11g Databases

Database disaster recovery, sometimes also lumped into the broader category of business continuity planning, is a topic that many EBS sysadmins seem to struggle with.  Oracle Data Guard is a set of services that create, manage, and monitor one or more standby databases to enable a primary database to survive disasters and data corruption. If the primary database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch a standby database to the primary role, minimizing the downtime. 

Physical architecture diagram showing target architecture for an E-Business Suite Release 12 disaster recovery deployment

We've previously published EBS-specific documentation covering this for 10gR2 databases:
Our EBS database architects have recently updated that documentation to cover physical standby for both the 11gR1 and 11gR2 databases for E-Business Suite 12 environments.  This updated documentation has been streamlined and updated with our latest recommendations for disaster recovery environments using physical standby.  It's published here:
References
Related Articles

Friday Oct 08, 2010

Database 10gR2 10.2.0.5 Certified with E-Business Suite on Windows

windows-logo.jpg
The 10.2.0.5 database patchset is the terminal release for the 10gR2 codeline.  As a follow-on to the original certification announcement (on July 2, 2010), Oracle Database 10gR2 Patch Set 10.2.0.5.0 is now certified with Oracle E-Business Suite Release 11i and R12 on the following Microsoft Windows Server platforms:
  • Windows Server 2003 (32-bit and 64-bit)
  • Windows Server 2003 R2 (32-bit and 64-bit)
  • Windows Server 2008 (32-bit and 64-bit) for EBS 12 only
  • Windows Server 2008 R2 (64-bit only) for EBS 12 only
The certification with Windows Server 64-bit operating systems are 'database-tier only' (previously known as 'split tier') platform certifications - the application tier must be on a different certified EBS platform such as Windows Server (32-bit).

This announcement includes:
For EBS 11i version 11.5.10 CU2+ATG_PF.H.delta.6 (RUP 6) and higher:
  • Oracle Database 10gR2 Patch Set 10.2.0.5.0
  • Real Application Clusters
  • Oracle Database Vault 
  • TDE Column Encryption 
  • Advanced Security Option/Advanced Networking Option (ANO/ASO)
For EBS R12 Releases 12.0 (12.0.4 and higher) and 12.1 (12.1.1 and higher):
  • Oracle Database 10gR2 Patch Set 10.2.0.5.0
  • Real Application Clusters
  • Oracle Database Vault 
  • TDE Column Encryption
  • Advanced Security Option / Advanced Networking Option (ANO/ASO)
Premier Support for 10gR2 ended July 31, 2010

We've covered this several times already, but it never hurts to keep reminding you that Premier Support for the 10gR2 (10.2) database ended on July 31, 2010.

Regular readers may recall that fees for the first year of Extended Support for the 10gR2 database are waived. There is nothing that customers need to do to remain fully supported other than keep your support contracts current. Higher fees for Extended Support will start August 1, 2011 for most platforms.

This is formally documented in two different places, for those of you who appreciate convergent validation:
If you haven't already done so, I strongly recommend that you review the following article to understand the support implications for E-Business Suite environments:
If you are considering upgrade paths for your EBS environment from 10gR2, you have the choice of either 11gR1 (11.1) or 11gR2 (11.2).  For the longest Premier Support coverage, choose 11gR2.  Here's a snapshot of our EBS database roadmap as of today:

Snapshot of E-Business Suite database certification roadmap as of July 2010 showing end of premier support dates for each database releaseEBS 12 References
EBS 11i References
Related Articles

Thursday Sep 02, 2010

Have You Used 10gR2 Transportable Tablespaces with EBS 11i?

We are soliciting your feedback on our recently announced E-Business Suite Release 11i + 10gR2 Cross Platform Transportable Tablespaces (XTTS) database migration process.

XTTS_Supported_Platforms2.png

We know that quite a few of you have requested this and are curious as to how you might be faring with it. For those customers who have downloaded the controlled patch (6158038) required for this migration of the EBS database, we would love to hear your answers to the following questions:

  1. What is the size of the E-Business Suite Database you've migrated or plan to migrate?
  2. What were the source and target platforms for this database migration (e.g. Linux Itanium to Oracle Solaris on SPARC)?
  3. Where are you currently at in your migration?
    • Not started on migration
    • Migration in progress following MOS Doc 454574.1
    • User testing of migrated system in progress
    • Completed testing and awaiting production migration
    • Live on migrated system in production
  4. Have you filed any SRs as part of your testing of your migration? And if so, what were the SR numbers?
  5. Have you analyzed the time savings when using XTTS vs export/import? If so, what were the savings?
Feel free to post a comment here, or if this information is sensitive, please drop me a line directly.

Other Certifications Still Underway

Transportable Tablespaces for other Database and EBS versions (such as 10gR2+R12, 11g+R12 and 11g+11i) are still under evaluation. 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.

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.


Tuesday Aug 24, 2010

Reminder: Minimum Patching Baselines for E-Business Suite 11i Extended Support

[Editor: This article was originally published in January 2010.  Reposting this article in its entirety.]

Premier Support for Oracle E-Business Suite Release 11i ends in November 2010.  Extended Support begins when Premier Support ends.  Extended Support comes at an additional cost, but these are waived for Oracle E-Business Suite Release 11i through November 2011. I'm in EBS Development and not sales, so you should contact your Oracle account manager with questions about Extended Support costs. 

Here is a comparison of the different support levels:

A new set of minimum technical requirements for Apps 11i goes into effect when Extended Support begins in November 2010.  These new minimum baseline patch requirements are listed in:
What are the impacts of this new baseline?

As always, Oracle Support will assist with diagnosis, triage, and debugging of any issues that you report for your E-Business Suite environment.  You will continue to have access to any existing online support tools, knowledge base documentation, and pre-existing fixes.

If you report a new issue that requires a new bug fix, you should be aware that new patches will be released only for the new baseline patches listed in the Minimum Baseline Patch Requirements Note.  You should plan to apply the baseline patches (at minimum) listed in Note 883202.1 by November 2010 in order to receive any new bug fixes.

Minimum Baseline Patch Requirements
  • Oracle E-Business Suite Release 11.5.10 Consolidated Update 2 plus additional patches listed in Note 883202.1
  • ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765)
  • 10.2.0.4 Database or 11.1.0.7 Database
  • Forms6i Patchset 19 (version 6.0.8.28, Patch 6194129)
  • Oracle HTTP Server MLR Patchset 4393827
  • Sun Java Runtime Engine (JRE) 1.6.0_03 or higher
The baseline versions listed here (and in the Note) are current as of the document's release date but may change in the future.  Any changes will be communicated via Note 883202.1.  If you've found this article as the result of a web search, I would strongly encourage you to check the latest version of the Note for the current information.

What EBS 11i products are affected by this new baseline?

In addition to the major technology stack components shown above, Note 883202.1 contains additional minimum baseline requirements for:
  • Applications Technology
    • Common Applications Calendar
  • Contracts
    • Core Contracts
    • Procurement Contracts
    • Project Contracts
    • Sales Contracts
    • Service Contracts
  • Customer Data Management
    • Customers Online
    • Trading Community
  • Financials
    • Assets
    • iAssets
    • Advanced Collections
    • Bill Presentment Architecture
    • Cash Management
    • E-Business Tax
    • Financials for the Americas
    • Financials for Asia/Pacific
    • Financials Common Country
    • Financials for EMEA
    • Financials for India
    • Internet Expenses
    • Lease Management
    • Loans
    • Payables
    • Payments
    • Property Manager
    • Public Sector Budgeting
    • Public Sector Financials
    • Public Sector Financials (International)
    • Receivables
    • iReceivables
    • Treasury
    • U.S. Federal Financials
  • Human Resources
    • Advanced Benefits
    • Approvals Management
    • HR Intelligence
    • Human Resources
    • Labor Distribution
    • Learning Management
    • Payroll (All Localizations)
    • Payroll (International/Custom)
    • iRecruitment
    • Self-Service Human Resources
    • Time and Labor
    • US Federal Human Resources
  • Intelligence
    • Balanced Scorecard
    • E-Business Intelligence
  • Interaction Center
    • Customer Interaction History
  • Logistics
    • Inventory Management
    • Warehouse Management
  • Manufacturing
    • Cost Management
    • Quality
    • Supply Chain Globalization
    • Work in Process
  • Marketing and Sales
    • Incentive Compensation
    • Marketing
    • Partner Management
    • Quoting
    • Sales
    • Sales for Handheld
    • Sales Offline
    • Territory Management
    • Trade Management
  • Order Management
    • Advanced Pricing
    • Configurator
    • Order Capture
    • Order Management
  • Procurement
    • iProcurement
    • Purchasing
    • Sourcing
    • iSupplier Portal
    • Supplier Scheduling
  • Product Lifecycle Management
    • Advanced Product Catalog
    • Bills of Material
    • Document Management and Collaboration
    • Engineering
    • Item Master
  • Projects
    • Grants Accounting
    • Project Billing
    • Project Collaboration
    • Project Costing
    • Project Portfolio Analysis
    • Project Foundation
    • Project Resource Management
    • Projects
  • Service
    • Advanced Scheduler
    • Complex Maintenance, Repair & Overhaul
    • Customer Care
    • Depot Repair
    • Field Service
    • iSupport
    • Teleservice
  • Supply Chain Planning
    • Demand Planning
    • Production Scheduling
    • Strategic Network Optimization
Related Articles

Wednesday Aug 04, 2010

E-Business Suite 12 Now Available on Linux on IBM System z

logo_ibm.jpg
Every new E-Business Suite release, patch, roll-up patchset, Family Pack, Consolidated Update, or technology stack certification needs to be tested on every platform that we support for the E-Business Suite.  This is a lot of work.  My teams test on the base Oracle Enterprise Linux platform, and Terri Noyes' Applications Platforms Group tests everything on all of the other operating systems that we support.

As you can imagine, it is very big news when we expand our E-Business Suite operating system portfolio to include a new platform.  This always constitutes a major new commitment to that platform. 

This is why we are pleased to announce that the Oracle E-Business Suite Release 12 is now available on a new fully certified EBS platform - Linux on IBM System z. This IBM platform (i.e. Linux running on an IBM mainframe) is also known as 'Linux on System z' and appears in our Oracle systems (My Oracle Support, aru, bug, etc.) as 'IBM: Linux on System z'.

The Linux on System z platform was previously a 'database tier only' platform (for EBS 11i and 12.0) and will continue to be supported as such on those releases. With this announcement for 12.1, we are supporting the platform as a fully certified EBS platform (i.e. for both application and database tiers).

The release is based on the 12.1.2 EBS codeline and includes a Rapid Install wizard to support new installations as well as 11i upgrades (from a certified EBS 11i platform) to Release 12 on Linux on System z. This first release includes the Oracle Database 10gR2 on the database tier, and Application Server versions 10gR2 and 10gR3.

Various technology certifications are planned as well for the currently available versions of technology products on the platform (such as 10.1.2.3 OID/SSO, 10.1.2.3 Discoverer, AS 10gR3 Patchset 5, etc.) or those expected at some point in the future (such as Oracle Database 11gR2). Separate announcements for these certifications will be sent out as they become available.

The operating systems certified with EBS on this platform are:
  • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 9 (64-bit)
  • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)
Please review the documents below for all requirements and additional details on the use of EBS Release 12 on IBM: Linux on System z. All general documentation pertaining to EBS Release 12.1.1 (such as the Rapid Install Guide and the Upgrade Guide) are relevant as well to this release of 12.1.2 as the general functionality of EBS is the same on this platform.

The release is available now on our public edelivery web site for download.

References
Related Articles

About

Search

Categories
Archives
« July 2015
SunMonTueWedThuFriSat
   
1
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