Find Ebs Technology Stack Component Versions

1	A very good report to collect versions of technology stack components is described in MOS article 601736.1. Below an example of how to run this report on unix/linux   Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next perl command: 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
2	How to find E-Business Suite Version:  Connect to the database with sqlplus as user apps and run next query: SQL> select release_name from apps.fnd_product_groups;
3	How to find the Workflow Version:  Connect to the database with sqlplus as user apps and run next query: SQL> select distinct TEXT Version from WF_RESOURCES where NAME = ‘WF_VERSION';
4	How to find the Web Server or Application Server version:  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
5	How to find the Forms & Reports version in EBS 11i  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: $ORACLE_HOME/bin/f60run | grep Version | grep Forms
6	How to find the Forms & Reports version in EBS R12  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: $ORACLE_HOME/bin/rwrun | grep Release
7	How to find the Jinitiator version:  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: grep jinit_ver_comma $CONTEXT_FILE
8	How to find the Oracle Java Plug-in version:  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: grep plugin $CONTEXT_FILE
9	How to find the OA Framework Version (11i only):  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: adident Header $FND_TOP/html/OA.jsp adident Header $OA_HTML/OA.jsp
10	How to find the Database version:  Connect to the database with sqlplus as sysdba and run next query: SQL> select * from v$version;
11	How to find the Weblogic server version in EBS R12.2:  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables and run next command: cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
12	How to find the Fusion Middle Ware (FMW) version in EBS R12.2  Logon the Applications Middle-tier as the Application owner, using a terminal emulator (E.g. Putty). Set the correct environment variables. Set the correct ORACLE_HOME variable: E.g. export ORACLE_HOME=/u001/oracle/R122/FMW_Home/Oracle_EBS-app1 Run next command: $ORACLE_HOME/OPatch/opatch lsinventory Ref: http://www.bluegecko.dk/oracle-applications/how-to-find-ebs-technology-stack-component-versions/