Autoconfig in R12.2

By -

🔧 AutoConfig Overview in Oracle E-Business Suite

AutoConfig is a configuration tool that automates the setup of both Application Tier and Database Tier in Oracle E-Business Suite.

The required configuration information is stored in an XML repository called the Applications Context File. There is one context file for each tier — Application and Database.

🧩 AutoConfig Components

  • Context File
  • Driver Files
  • Template Files

📘 Context File

It contains configuration values and environment details for each server.

Format: SID_HOSTNAME.xml

Location:

  • Application Tier: echo $CONTEXT_FILE
  • Database Tier: $ORACLE_HOME/appsutil/<contextfile.xml>

📝 Template Files

Template files contain placeholder tags used to create configuration files. When AutoConfig runs, these tags are replaced with actual values from the context file.

Locations:

  • Application Tier: $PRODUCT_TOP/admin/template
  • Database Tier: $ORACLE_HOME/appsutil/template

🚀 Driver Files

Each product top has its own driver file. It defines mappings between template files and target configuration files.

Location:

  • /apps/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/admin/driver/
  • /apps/oracle/TEST/fs1/EBSapps/appl/fnd/12.0.0/admin/driver/

⚙️ AutoConfig Template and Driver Overview

In template files, environment variables that need replacement are defined. The driver files list which configuration files to generate. When AutoConfig runs, it reads these definitions and creates configuration files automatically.

📂 AutoConfig Scripts and Log Locations

ScriptPurposeApplication TierDatabase Tier
adautocfg.shWrapper to call adconfig.sh and pass context files.$INST_TOP/admin/scripts$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
adconfig.shWrapper that calls adconfig.pl (invoked by adautocfg.sh).$AD_TOP/bin$ORACLE_HOME/appsutil/bin
LogsCreated by AutoConfig to track configuration.$INST_TOP/admin/log/MMDDhhmm$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDhhmm

🧠 How to Enable AutoConfig on the Database Tier

AutoConfig must be enabled once before execution on the DB Tier.

🔹 Steps to Enable

  1. Create AppsUtil Zip File on Apps Tier
    perl $AD_TOP/bin/admkappsutil.pl
  2. Copy appsutil.zip to Database Tier and unzip under $ORACLE_HOME
  3. Install JRE on Database Tier
  4. Generate Context File
    perl $ORACLE_HOME/appsutil/bin/adbldxml.pl
  5. Run AutoConfig
    $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh

✅ Summary Table

StepActionTier
1Create appsutil.zip using admkappsutil.plApplication Tier
2Copy appsutil.zip to DB TierDatabase Tier
3Install JREDatabase Tier
4Generate Context FileDatabase Tier
5Run adautocfg.shDatabase Tier
Note: AutoConfig must be enabled on the Database Tier at least once before running successfully.

❓ AutoConfig FAQs

What is AutoConfig?

AutoConfig is an Oracle E-Business Suite utility that automates configuration using XML-based context files for both tiers.

What are the basic components of AutoConfig?

ComponentLocationDescription
Applications ContextApp Tier: <INST_TOP>/appl/admin
DB Tier: <RDBMS ORACLE_HOME>/appsutil		XML repository (<CONTEXT_NAME>.xml) with instance-specific info.
Template FilesApp Tier: <PROD_TOP>/admin/template
DB Tier: <RDBMS ORACLE_HOME>/appsutil/template		Contain placeholders replaced with actual values from context.
Driver FilesApp Tier: <PROD_TOP>/admin/driver
DB Tier: <RDBMS ORACLE_HOME>/appsutil/template		Lists templates, destinations, and commands for AutoConfig execution.

When should I run AutoConfig?

  • After updating a context file
  • When Oracle documentation instructs (patch, upgrade, clone, migration)
  • After applying ADX product patches

Where are the AutoConfig log files?

  • Application Tier: <INST_TOP>/admin/log/<MMDDhhmm>/adconfig.log
  • Database Tier: <RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm>/adconfig.log

How to Roll Back AutoConfig?

Backup configuration files from each AutoConfig run are stored under /out/<MMDDhhmm> directory. Use restore.sh (UNIX) or restore.cmd (Windows) to roll back.

Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...
Read more

How to run Gather Schema Statistics in R12.2

By -
Image
What is Gather Schema Statistics? Gather Schema Statistics program generates statistics that quantify the data distribution and storage characteristics of tables, columns, indexes, and partitions. The cost-based optimization (CBO)  uses these statistics to calculate the selectivity of prediction and to estimate the cost of each execution plan. Why Run the Gather Schema Statistics? When Data is update, insert, delete in table of user end Like (Technical User ,Finance User ,Ect) It become necessary to run the Gather Schema Statistics It’s recommended to Run GSS in Weekly Once or twice. How to run Gather Schema Statistics? Login application with sysadmin user Submit Request Window Navigate to: Concurrent > Requests Enter the parameters This can be run for specific schemas by specifying the schema name or enter ‘ALL’ to gather statistics for every schema in the database Submit the Gather Schema Statistics program Parameters: S...
Read more

JSP Compilation in R12.2

By -
Sometime after upgrade, cloning and patching front end login page is not opening showing blank page or showing “ java.lang.StringIndexOutOfBoundsException ” error. This issue was occurring due to cache is not cleared after upgrade/Cloning JSP Compilation steps Step 1: Shutdown the application services Step 2: Take backup for the _Page(class file) folders $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> a $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> $ mkdir _pages $ ls -lrt Step 3: Run the below command $ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 99 Step 4: Start the application and clear browser cache. After completed the JSP compilation home page not coming please clear the image and style sheet cache also Cabo Images and style sheets can be corrupted or out of sync in the cabo caches, you may need to clear the related directories after backup: Step1: Shutdown the services...
Read more