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