EBusiness Suite Application Techstack component Versions



One Stop Standard Script to Oracle E-BS Application Techstack component Versions:


Really Required for Apps DBAs


MOS ID :601736.1


On Application Tier

  1. Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
  1. Ensure “APPLRGF” variable is set in environment. If not, set it to the same value as “APPLTMP”.
  1. Navigate to /patch/115/bin. Run the utility/command as follows :
    Operation System Command Line
    Unix or Linux

    		 $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl
    -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP
    -contextfile=$CONTEXT_FILE
    -appspass=apps
    -outfile=$APPLTMP/Report_App_Inventory.html

    Note:
    – Run the above command in single line
    – Remove the ” after each parameter while you run this command in a single line
    – Supply the apps user password as is applicable for parameter “-appspass”
    Windows

    		 %ADPERLPRG% %FND_TOP%patch115binTXKScript.pl
    -script=%FND_TOP%patch115bintxkInventory.pl
    -txktop=%APPLTMP% -contextfile=%CONTEXT_FILE%
    -appspass=apps
    -outfile=%APPLTMP%Report_App_Inventory.html

    Note:
    – Run the above command in single line
    – Remove the ” after each parameter while you run this command in a single line
    – Supply the apps user password as is applicable for parameter “-appspass”

    Where:

    txktop Temporary working directory use by Perl Modules. Should not be an empty string.
    contextfile Location of the context file. If not passed, default is picked from the environment.
    appspass APPS schema password. If not passed, default password is used.
    outfile Location for the report being generated. If not passed, the default location is /TXK

    To generate the report in text format, the parameter “-reporttype=text” needs to be passed to the above commands. For example:

    outfile=$APPLTMP/Report_App_Inventory.html -reporttype=text


  1. Operation System Command Line
    Unix or Linux

    		 $ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl
    -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP
    -contextfile=$CONTEXT_FILE
    -appspass=apps
    -outfile=$APPLTMP/Report_App_Inventory.html

    Note:
    – Run the above command in single line
    – Remove the ” after each parameter while you run this command in a single line
    – Supply the apps user password as is applicable for parameter “-appspass”
    Windows

    		 %ADPERLPRG% %FND_TOP%patch115binTXKScript.pl
    -script=%FND_TOP%patch115bintxkInventory.pl
    -txktop=%APPLTMP% -contextfile=%CONTEXT_FILE%
    -appspass=apps
    -outfile=%APPLTMP%Report_App_Inventory.html

    Note:
    – Run the above command in single line
    – Remove the ” after each parameter while you run this command in a single line
    – Supply the apps user password as is applicable for parameter “-appspass”


  1. Where:

  1. txktop Temporary working directory use by Perl Modules. Should not be an empty string.
    contextfile Location of the context file. If not passed, default is picked from the environment.
    appspass APPS schema password. If not passed, default password is used.
    outfile Location for the report being generated. If not passed, the default location is /TXK

  1. To generate the report in text format, the parameter “-reporttype=text” needs to be passed to the above commands. For example:

  1. outfile=$APPLTMP/Report_App_Inventory.html -reporttype=text

  1. Once the command executes successfully, it should generate the report file in the location specified for “outfile” parameter in above script
  1. Incase you have more than one application tier’s (multi-node architecture), follow the steps 1-4 on each of the Application tiers
  1. Upload the report output file (default: $APPLTMP/Report_App_Inventory.html )to Oracle Support for review

Sure it helps you….please comment.


Yours,
Narasimha Rao

Recent Posts