EBS versions

[big]

Hi,
are the followings right commands to find versions in an EBS system:

DB version:
SELECT banner_full FROM v$version;

RU level:
SELECT action_time, patch_id, patch_type, action, description
FROM dba_registry_sqlpatch
ORDER BY action_time DESC;

EBS version:
SELECT release_name FROM fnd_product_groups;

EBS modules:
SELECT application_short_name, product_version, patch_level
FROM fnd_application_all_view f, fnd_product_installations p
WHERE f.application_id = p.application_id
AND p.status = 'I';

WLS:
java weblogic.Server
or
look at :
$EBS_DOMAIN_HOME/config/config.xml

WLS Patches:
$ORACLE_HOME/OPatch/opatch lsinventory

Java version:
$JAVA_HOME/bin/java -version
To find $ORACLE_HOME of Middleware

. <EBS_BASE>/EBSapps.env run
echo $FMW_HOME
$ORACLE_HOME is under $FMW_HOME/wlserver

Please add anything if necessary.

Thanks and regards.

[ErmanArslansOracleBlog]

select release_name from apps.fnd_product_groups; - EBS APP Version

SQL>  SELECT * FROM V$VERSION; -- DB version / using sqlplus

Following tech components;

$IAS_ORACLE_HOME/ohs/bin/httpd -v

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

FORMS
frmcmp_batch | grep Version | grep Forms

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

REPORTS
$ORACLE_HOME/bin/rwrun | grep Release

JAVA
#sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print$2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;”

#java -version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

PERL
$IAS_ORACLE_HOME/perl/bin/perl -v | grep built

WEBLOGIC
cd $FMW_HOME/wlserver_10.3/server/lib

#java -cp weblogic.jar weblogic.version