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>

Recent Posts

Start typing and press Enter to search