We are often asked How to find the EBS R12 components Version. This includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 versions with commands and reports.
Table of Contents
Apache Version/how to check oracle application server version in r12
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
Perl Version
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
Java Version/JDK 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”
how to check database version in oracle
Connect to the oracle database with sqlplus as sysdba and run the 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 the below command
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
how to check oracle apps version from backend (11i/R12/12.2)/how to check oracle ebs version
Connect to the database as user apps
SQL> select release_name from apps.fnd_product_groups;
How to check version of file on filesystem
adident Header <file name>
How to check Unix Operating system Version
Solaris -> cat /etc/release Red Hat Linux -> cat /etc/redhat-release
How to check AD & TXK version in R12.2
sqlplus apps/appspass
column codelevel format a30
column name format a40
select ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');
ABBREVIA NAME CODELEVEL
-------- ---------------------------------------- ------------------------------
ad Applications DBA C.7
txk Oracle Applications Technology Stack C.7
Please take a look at the following post for more information
what is oracle EBS R12
Oracle R12 INST_TOP
E-Business Suite 11i/R12/R12.1/R12.2
Oracle E-Business Suite Architecture in 12.2
how to apply weblogic patch in R12.2
Leave a Reply