How to find EBS R12 components Version

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.


1. Apache Version - $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

2. Perl Version - $IAS_ORACLE_HOME/perl/bin/perl -v|grep built

3. Java Version/JDK Version - sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"

4. JRE version - cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

5. Forms Version - $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

6. Plsql Version - $ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

7. Forms Communication mode - cat $FORMS_WEB_CONFIG_FILE|grep serverURL=

8. Version collection script provided by Oracle - 
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

9. Weblogic version in R12.2 - cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

10. 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

11. How to find EBS Apps Version (11i/R12/12.2) -

sqlplus apps/appspass

select release_name from apps.fnd_product_groups;

12. How to check version of file on filesystem - adident Header <file name>

13. How to check Unix Operating system Version -

Solaris -> cat /etc/release 
Red Hat Linux -> cat /etc/redhat-release

14. 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.10
txk      Oracle Applications Technology Stack     C.10