• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

March 25, 2014 by Dimitri van de Ven

How to find EBS technology stack component versions

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).
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

Filed Under: ebs, Oracle Applications Tagged With: CONTEXT_FILE, E-Business Suite, EBS, f60run, FMW, fnd_product_groups, Forms, httpd, iAS, Java Plug-in, OA Framework, OA.jsp, R12.2, rwrun, TXKScript, Weblogic, WF_RESOURCES, WF_VERSION, WLS_PRODUCT_VERSION

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News & Events
  • Oracle
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group