EBS versions

classic Classic list List threaded Threaded
1 message Options
big
Reply | Threaded
Open this post in threaded view
|

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.