Useful commands to find the versions of various components used in Oracle E-Business Suite
Find Apache Version or Oracle Application server version in R12
Log in to the Application server and source the environment fine and execute the below command,
# $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
Perl Version in EBS,
# $IAS_ORACLE_HOME/perl/bin/perl -v|grep built
Java Version/JDK Version
# cd $ADMIN_SCRIPTS_HOME/
# sh java.sh -version
JRE version
# cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version
Weblogic Version
# cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
Fusion Middle Ware (FMW) version in EBS R12.2 /how to check fmw version
Source Fusion Middle Ware oracle home and then run the below opatch command,
# $ORACLE_HOME/OPatch/opatch lsinventory
Oracle EBS version from the backend
Connect to the database as user apps,
SQL> select release_name from apps.fnd_product_groups;
Check the AD & TXK version in R12
Connect to the database as apps user,
SQL> col codelevel format a30
SQL> col name format a40
SQL> select ABBREVIATION, NAME, codelevel FROM apps.AD_TRACKABLE_ENTITIES where abbreviation in (‘txk’,’ad’);
Workflow Version with Apps
Connect to Database as apps user,
SQL> select text ,name from wf_resources where name like ‘%WF_VERSION%’;
Version collection script provided by Oracle
Oracle has provisioned bulit in scripts to collect versions of technology stack components. Reference – 601736.1
For Application Tier
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=<apps password> -outfile=<File_Directory>/<output_file_name>
For Database Tier
$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=<apps password>
-outfile=$ORACLE_HOME/appsutil/temp/<output_file_name>