Utility /Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc

Utility /Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc 

Oracle Applications Technology Stack - Version 11.5.10.0 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.
GOAL
How to find the versions of technology stack components (Forms, iAS, Framework, JDK, OJSP, Database, etc.)?
SOLUTION
On Application Tier
Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
Ensure "APPLRGF" variable is set in environment. If not, set it to the same value as "APPLTMP".
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%\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"

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


On Database Tier

Establish the needed environment parameters by sourcing the Database environment file as the owner of the Database tier file system. |
Ensure "ORACLE_HOME" variable is set in environment and correctly pointing to your database ORACLE_HOME.
Navigate to /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
%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"

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.html -reporttype=text
Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script
Upload the report output file (default: $ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html ) to Oracle Support for review