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

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

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2] on any platform.

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 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 <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.html -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	%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

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

 Specific Component

E-Business Suite Version.

Connect to the database as user apps and run the following sql.

SQL> select release_name from apps.fnd_product_groups;

Workflow Version.

Connect to the database as user apps and run the following sql.

SQL> select distinct TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION’;

Database version. 

Connect to the database with sqlplus as sysdba and run next query:

SQL> select * from v$version;

Web Server or Application Server version.

Oracle EBS 11i 

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

Forms version.

Logon the Applications Middle-tier as the Application owner, using ssh terminal..
Set the correct environment variables and run next command:

Oracle EBS 11i 

$ORACLE_HOME/bin/f60run | grep Version | grep Forms

Oracle EBS 12.2

$ORACLE_HOME/bin/frmcmp_batch | grep Version | grep Forms

Reports version.

Oracle EBS 12.2

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

$ORACLE_HOME/bin/rwrun | grep Release

  

Oracle Java Plug-in version. 

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

grep plugin $CONTEXT_FILE

OA Framework Version.

Oracle EBS 11i 

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

Weblogic server version.

Oracle EBS 12.2

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

Fusion Middle Ware (FMW) version.

Oracle EBS 12.2

Logon the Applications Middle-tier as the Application owner, using ssh terminal.

Set the correct environment variables.
Set the correct ORACLE_HOME variable:
E.g. export ORACLE_HOME=/u001/oracle/R122/FMW_Home/Oracle_EBS-app1

Run next command:
$ORACLE_HOME/OPatch/opatch lsinventory

Jinitiator version.

Logon the Applications Middle-tier as the Application owner, using ssh terminal.
Set the correct environment variables and run next command:

grep jinit_ver_comma $CONTEXT_FILE