E-Business Suite Applications Technology Stack Utility / Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc) (Doc ID 601736.1)

APPLIES TO:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

GOAL

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?

SOLUTION

On Application Tier

1. Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
2. Ensure "APPLRGF" variable is set in environment. If not, set it to the same value as "APPLTMP" (Note: If you set the output file directory using -outfile parameter, skip this step and the file will be generated under $APPLRGF/TXK directory).
3. Navigate to <FND_TOP>/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 when running the command on a single line - Supply the apps user password as is applicable for parameter "-appspass"
   Windows	­PERLPRG% %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 when running the command on 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 <APPLTMP>/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.txt -reporttype=text

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

On Database Tier

1. Establish the needed environment parameters by sourcing the Database environment file as the owner of the Database tier file system. |
2. Ensure "ORACLE_HOME" variable is set in environment and correctly pointing to your database ORACLE_HOME.
3. Navigate to <ORACLE_HOME>/appsutil/bin. Run the utility/command as below (all on a single line):
   
   

   Operation System	Command Line
   Unix or Linux	$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html Note:- Run the above command in single line - Supply the apps user password as is applicable for parameter "-appspass"
   Windows	­PERLPRG% %ORACLE_HOME%/appsutil/bin/TXKScript.pl -script=%ORACLE_HOME%/appsutil/bin/txkInventory.pl -txktop=%ORACLE_HOME%/appsutil/temp -contextfile=%CONTEXT_FILE% -appspass=apps -outfile=%ORACLE_HOME%/appsutil/temp/Report_DB_Inventory.html Note: - Run the above command in 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.
   appspass	APPS schema password.
   outfile	Location for the report being generated.

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

   outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.txt -reporttype=text

4. Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script
5. Upload the report output file (default: $ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html ) to Oracle Support for review