Tuesday, June 16, 2015

How to check cloned instance and database versions

Cloned instance
================
select name, creation_date from FND_APPS_SYSTEM;
SELECT resetlogs_time FROM v$database
version details
=============
SELECT product, VERSION, status
FROM product_component_version;