Identify versions of components in EBS

Useful commands to find the versions of various components used in Oracle E-Business Suite

Log in to the Application server and source the environment fine and execute the below command.

Find Apache Version in R12

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Find Perl Version in EBS

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Find Java Version/JDK Version

cd $ADMIN_SCRIPTS_HOME/

sh java.sh -version

Find JRE Version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

Find Weblogic Version

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

Find Opatch Version

$ORACLE_HOME/OPatch/opatch lsinventory

Oracle EBS version from the backend then connect to the database as user apps,

Find Oracle EBS Version

SQL>select release_name from apps.fnd_product_groups;

Find AD & TXK version in R12

SQL>select ABBREVIATION, NAME, codelevel FROM apps.AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');

Find Workflow Version in R12

SQL>select text ,name from wf_resources where name like '%WF_VERSION%';

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=<File_Directory>/<output_file_name>