Oracle Apps: E-Business Suite Applications Technology Stack Component Versions

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';

Feel free to point out if anything is missing/wrong in this blog.