Power Tools: Configuring EBS R12 Database Tiers with AutoConfig

[Editor's Note: This is the fourth and last of a series of four articles on new AutoConfig features. These articles are written by members of our AutoConfig Development team. This is your opportunity to interact directly with that team with your feedback on this tool.]

The AutoConfig Build Context utility (adbldxml.pl) has traditionally been used by administrators to rebuild the context file in Oracle E-Business Suite 11i. In Apps 11i, the AutoConfig Build Context utility was introduced to allow customers to migrate to AutoConfig easily. Later on, due to numerous changes in the 11i technology stack, it became hard to keep the utility in sync for the Applications tier. So it was not recommended to customers for discretionary use, but instead only when absolutely needed like in case of cross-platform migrations and database upgrades.

Diagram showing the process by which the AutoConfig Build Context Utility consolidates data from the EBS database environment variables and context template to generate a context file

Revived for Apps 12

The AutoConfig Build Context utility has been revived and re-introduced in Oracle E-Business Suite R12 for the database tier. It is essential for enabling AutoConfig on the database tier of an R12 E-Business Suite instance in the following scenarios:

How Does it Work?

The AutoConfig Build Context utility reads information from EBS database and environment variables and builds the context file out of the database context template ($ORACLE_HOME/appsutil/template/adxdbctx.tmp). This is illustrated in the figure above.

Running the AutoConfig Build Context Utility

The utility can be run by issuing the following command on the database tier:

perl $ORACLE_HOME/appsutil/bin/adbldxml.pl

Note: In R12, this utility is supported only on the database tier.

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:


Related Articles


Hi Ramya,

I saw this:
Note: In R12, this utility is supported only on the database tier.

I have a question. For some reason if i miss my CONTEXT_FILE on Apps Tier, than i do not see any way to recover it.

I know there is another way to download it from Database using
"perl adclonectx.pl retrieve" BUT do we have any other way to generate CONTEXT_FILE as adbldxml.pl does?

Thanks and Regards
Neeraj Kataria

Posted by Neeraj Kataria on April 10, 2009 at 12:28 PM PDT #

Hi Neeraj,

In R12, the only way to retrieve the context file on the Applications tier is using the adclonectx.pl script.

There is no tool to build the context file from scratch on the Applications tier, the way adbldxml.pl does on the Database tier.


Posted by Ramya Damodaran on April 16, 2009 at 03:12 PM PDT #

all installation of r12 is sucessfull, but i am nnable to see the login page after restart... my hotst name is
http://linuxtest.nctex:8000 ... but page goes unresponded...
please help

Posted by Muhammad Waseem on August 11, 2009 at 06:00 PM PDT #

Hello, Muhammad,

I'd like to get someone to help you with this. Can you log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged?

Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.


Posted by Steven Chan on August 12, 2009 at 04:00 AM PDT #

Hello Steven,
thanks for your comment.

I am on the final phases of finalizing the setting up standby for oracle apps using dataguard via the grid control.

One of the parts that is missing is the configuration of the database tier and application tier for the standby so that when is ready to switchover from our primary, we are ready to go.

I have found a doc for the configuration of the application tier (Doc id: 1070033.1), but I cannot find any doc on how to setup the database tier (standby db created via rman). How can we configure the database with autoconfig setup? How can it be possible if we cannot log into the stnadby (except with sys or system as sysdba)? how is the adaautocfg. or adclone scripts to be run if they cannot log as apps? I appreciate if you can help me to identify the steps that needs to be done on the database side. Much obliged.

Posted by guest on June 16, 2011 at 07:17 AM PDT #

I need to create new DAD entry for my client in R12, I have already done it on 11i.

$FND_TOP/admin/template/custom apps_ux.conf

With the following:
connect_string = %s_weboh_twotask%
password = %s_APPSpwd%
username = %s_apps_user%
default_page = fnd_web.ping
document_table = aa_blob_files
document_path = docs
document_proc =
upload_as_long_raw =
upload_as_blob = *
reuse = Yes
connmax = 10
pathalias = fndgfm
pathaliasproc = fnd_gfm.dispatch
enablesso = No
input_filtering = Yes
custom_auth = PerPackage

Upon running autoconfig, this file would be used to generate the target file $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app, which would have the correct and instance specific pw for apps.

Unfortunately, it does not appear that the R12 DAD file has an autoconfig custom template…thus I am left to hard code the DAD file directly…which won’t work for my customers, since they would have to place a hard coded apps pw value for each instance upon which our software is installed.

I need this to work automatically, without manual intervention.

Does R12 already have some form of mod_plsql configured that we could use for our custom app? I don’t see any EBS entries in the DAD file on our R12 server. In fact, the DAD file is empty.

Please advise on this is there any way to do that in R12.

Appreciate your help.


Posted by guest on October 28, 2015 at 02:50 AM PDT #

Hi Guest,

mod pl_sql is not supported in Release 12. Consequently, DAD is also not supported in Release 12.

The following article is designed to help you make the transition:

Posted by Robert Farrington on October 30, 2015 at 03:05 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« July 2016