Sunday, 18 November 2018

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?


1.How to find E-Business Suite Version: 
Connect to the database with sqlplus as user apps and run query:
SQL> select release_name from apps.fnd_product_groups;

2.How to find the Workflow Version: 

Connect to the database with sqlplus as user apps and run query:
SQL> select distinct TEXT Version from WF_RESOURCES where NAME = 'WF_VERSION';

3.How to find the Web Server or Application Server version: 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

4.How to find the Forms & Reports version in EBS 11i 

Logon the Applications Middle-tier as the Application owner(ex:applmgr), using a putty terminal.
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

5.How to find the Forms & Reports version in EBS R12 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
$ORACLE_HOME/bin/rwrun | grep Release

6.How to find the Jinitiator version: 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep jinit_ver_comma $CONTEXT_FILE

7.How to find the Oracle Java Plug-in version: 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
grep plugin $CONTEXT_FILE

8.How to find the OA Framework Version (11i only): 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp

9.How to find the Database version: 

Connect to the database with sqlplus as sysdba and run query:
SQL> select * from v$version;

10.How to find the Weblogic server version in EBS R12.2: 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
Set the correct environment variables and run next command:
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

11.How to find the Fusion Middleware (FMW) version in EBS R12.2 

Logon the Applications Middle-tier as the Application owner(ex:applmgr).
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


No comments:

Post a Comment