How to find R12 components Version



Last updated on August 25th, 2016 at 03:30 am

We are often asked How to find R12 components Version. This is includes all R12.0/R12.1 and R12.2.I will try to explain how to find out that with variours R12 version with command and reports.

Apache Version

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

Perl Version

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

Java Version

sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print $2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;”

Jre version
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

Forms Version

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

Plsql Version

$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

Forms Communication mode

cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo “If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet”

Oracle Database version

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

SQL> select * from v$version;

Version collection script provided by Oracle

We collect versions of technology stack components using oracle provided script as  described in MOS article 601736.1

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=$APPLTMP/Report_App_Inventory.html

Weblogic version in R12.2

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

 

Fusion Middle Ware (FMW) version in EBS R12.2 

Source FMW oracle home and then run the below command

$ORACLE_HOME/OPatch/opatch lsinventory

Please take a look at following post for more information

R12 Introduction
INST_TOP Decoded

E-Business Suite 11i/R12/R12.1/R12.2

Oracle E-Business Suite Architecture in 12.2


Leave a Reply