X

The Latest Technology Stack News Directly from EBS Development

  • May 22, 2009

Everything You Ever Wanted to Know About AutoConfig Variables

Guest Author

Luckily, you were not afraid to ask. AutoConfig supports the automated configuration of  E-Business Suite technology stack components, but tracking down specific AutoConfig variables in their associated configuration files can be a daunting task. 
The AutoConfig Search Utility (formally known as the TXK Context Variable Information Utility) scans your AutoConfig infrastructure for a requested string and generates a detailed report about the relevant AutoConfig variables and their usage. The report
contains, among other things, the following information about relevant AutoConfig variables:


  1. Description

  2. Current value

  3. Default value

  4. Relevant AutoConfig template files

You can use the utility to search for:


  • A complete context variable name

  • A string that contains the partial context variable name

  • A string that is mentioned in the context variable definition, default value, or templates

For example you can enter either "s_contextfile" or even the word "context."  If you search for just a word the report will include information on all context variables that have the given word in
their name or in their definition.

We delivered the first version of the AutoConfig Search Utility in E-Business Suite Release 11i and 12.0.x.  We've enhanced and updated Phase II of the tool in Release 12.1.1.

In the first version, the scope of the AutoConfig Search Utility is limited to AD and FND products. In the latest version included with Release 12.1.1, we've expanded the tool's scope to include ALL product tops.  We've also enhanced the 12.1.1 version
to allow you to drill down into all configuration files that include the variable.  The tool generates the report in HTML format on the application and database tier.

Running the AutoConfig Search Utility

Here's an example report generated when running the AutoConfig Search Utility from the Application tier for the search string "java" using the following command:

perl <FND_TOP>/bin/txkrun.pl -script=GenCtxInfRep -keyword=jdbc -outfile= txkContext_Apps.html

The 12.1.1 report looks like this:

Screenshot of sample EBS AutoConfig Search Utility report

Obtaining the AutoConfig Search Utility

You can download the AutoConfig Search Utility via the following patches:



Utility VersionReleasePatch Number and Description
Phase I11i6372396: TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH S (APRIL/MAY 2008)
Phase I12.07207440:  R12.TXK.A - TXK - 12.0.4 Consolidated Patch 1
Phase II12.1.1

R12.1.1 Rapid Install or 7303030: 12.1.1 Maintenance Pack

References

Related Articles

Join the discussion

Comments ( 7 )
  • Ben Prusinski Monday, May 25, 2009

    Hi,

    Nice summary for autoconfig search for R12. Is there a way to modify a context variable for R12 without using the OAM interface? I understand that Oracle wants us to use it instead of editing the XML file directly for autoconfig.

    Regards,

    Ben


  • Richard Halford Tuesday, May 26, 2009

    You can edit the XML directly, but shouldn't do it that way as AFAIK, its not really supported anymore.

    OAM is the proper way to do it, thats the way we do it now, even if it is a rather labourious process.

    The big advantage of OAM though is that you can put comments against updates and keep a history of updates. Its easy enough to pull them out of FND_OAM_CONTEXT_FILES later.

    Its a pitty FND_OAM_CONTEXT_CUSTOM doesn't have the same ability to track changes for completness.


  • Vikram Das Wednesday, June 3, 2009

    Hi,

    It doesn't work on 11.5.10.2 with ATG RUP6, TXK Rollup S:

    $ perl $FND_TOP/bin/txkrun.pl -script=GenCtxInfRep -keyword=jdbc -outfile=txkContext_Apps.html

    *******FATAL ERROR*******

    PROGRAM : (/gpsesp76/erpapp/appl/fnd/11.5.0/bin/txkrun.pl)

    TIME : Wed Jun 3 14:18:12 2009

    FUNCTION: [ Level 1 ]

    ERRORMSG: -script $FND_TOP/patch/115/bin/txkGenCtxInfRep.pl does not exist

    $ ls -ltr $FND_TOP/patch/115/bin/txkGenCtxInfRep.pl

    $FND_TOP/patch/115/bin/txkGenCtxInfRep.pl: No such file or directory

    $ sqlplus /nolog

    SQL*Plus: Release 8.0.6.0.0 - Production on Wed Jun 3 14:18:26 2009

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    SQL> conn apps/apps

    Connected.

    SQL> select bug_number

    2 from ad_bugs

    3 where bug_number='6372396';

    BUG_NUMBER

    ------------------------------

    6372396

    SQL>

    - Vikram


  • Steven Chan Wednesday, June 3, 2009

    Hi, Vikram,

    Can you log a formal Service Request for the issue that you're encountering? I'd like to investigate this more systematically.

    Regards,

    Steven


  • Rajai Sukhon Wednesday, June 10, 2009

    Vikram,

    Command works in 1159. When typing "-script=GenCtxinfRep" below notice that GenCtxinfRep uses 'i' in lower case.

    perl txkrun.pl -script=GenCtxinfRep -keyword=jdbc -outfile= txkContext_Apps.html


  • Senthil Monday, August 5, 2019
    Thanks. Not sure, if this is the right place, but I wanted to ask this :

    I would like to know, where from the values of all the autoconfig variables in the context file are generated. Is there any one ore more tables that store all the variables such as s_dbSid, s_apps_jdbc_connect_descriptor, s_dbhost etc. along with their values, which autoconfig reads and generates all the configurations files ?
  • Elke Phelps (Oracle Development) Monday, August 5, 2019
    Senthil - Thanks for the inquiry. How the information is stored and used is dependent upon your release of Oracle E-Business Suite. You can find more information in the EBS Release 12.2 or 12.1 web library. If you require additional details than are specified in the documentation, you may open an Oracle Support Service Request.

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