How to find EBS R12 components Version

We are often asked How to find EBS 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 EBS R12 version with command and reports.

Table of Contents

Apache Version

$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 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 /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 find EBS Apps Version (11i/R12/12.2)

Connect to 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 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