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

Using Two New Oracle Database 11gR2 Features With EBS

Steven Chan
Senior Director

With the recent announcement of Oracle Database 11gR2 ( 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 (, 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:


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

Starting with 11gR2 (, 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.


Related Articles

Join the discussion

Comments ( 2 )
  • Akshaya Friday, April 13, 2012


    Even in To disable Fast Validation

    you need to set _disable_fast_validate=TRUE while applying the maintenance pack for EBS 12.1.1 and 12.1.3 to reduce the time needed to apply the patches.


  • Yamini Tuesday, November 26, 2013

    Is this true for ? I'll be upgrading EBS 12.1.2 to 12.1.3 and have DB, do I need to set _disable_fast_validate=TRUE ? Its mentioned in various upgrade documents.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.