Last updated on April 11th, 2019 at 05:39 pm
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 various 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 oracle 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
Weblogic Version can be found using below command
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
Fusion Middle Ware (FMW) version in EBS R12.2
Source Fusion Middle Ware oracle home and then run the below opatch 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
How to apply the technology patches to EBS R12.2