This post helps to find the vesrions of some of the Technology components in R12.2.
Inorder to get the Technology Stack Components Version on E-Business Suite, please refer to the below Metalink Note.
E-Business Suite Applications Technology Stack Utility / Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc) (Doc ID 601736.1)
The script from the above Note will give you an html report with all the Technology stack components versions.
Note:- The below scripts have been verified only on a 12.2.7 instance
Scripts to run on middle-tier (ex:- use putty)
#1. Forms Version
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
#2. Reports Version
$ORACLE_HOME/bin/rwrun | grep Release
#3. PL/SQL Version
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
#4. Weblogic Version
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
#5. Jinitiator Version
grep jinit_ver_comma $CONTEXT_FILE
#6. Application Server Version
cat $ORACLE_HOME/config/ias.properties | grep Version
Scripts to run on database
#1. EBS Version
select release_name from apps.fnd_product_groups;
#2. Database Version
select * from v$version;
#3. Workflow Version
select text version from wf_resources where name = 'WF_VERSION';
Inorder to get the Technology Stack Components Version on E-Business Suite, please refer to the below Metalink Note.
E-Business Suite Applications Technology Stack Utility / Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc) (Doc ID 601736.1)
The script from the above Note will give you an html report with all the Technology stack components versions.
Note:- The below scripts have been verified only on a 12.2.7 instance
Scripts to run on middle-tier (ex:- use putty)
#1. Forms Version
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
#2. Reports Version
$ORACLE_HOME/bin/rwrun | grep Release
#3. PL/SQL Version
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
#4. Weblogic Version
cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
#5. Jinitiator Version
grep jinit_ver_comma $CONTEXT_FILE
#6. Application Server Version
cat $ORACLE_HOME/config/ias.properties | grep Version
Scripts to run on database
#1. EBS Version
select release_name from apps.fnd_product_groups;
#2. Database Version
select * from v$version;
#3. Workflow Version
select text version from wf_resources where name = 'WF_VERSION';
Feel free to point out if anything is missing/wrong in this blog.