This blog shows how to find the versions of technology stack components. This include versions of Forms, iAS, Framework, JDK, OJSP, Database, etc.
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). 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). $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). $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). $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). 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). 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). adident Header $FND_TOP/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). 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. Run next command: |