Sunday, 1 January 2017

How to find the details and Script of Oracle Apps EBS system Cloned Date, Version Details, URL of Oracle Applications

Cloned Date, Version Details, URL of Oracle Applications
Cloned date of oracle application and Version

------------------------------------
-- Query to get Version details.. --
------------------------------------

SELECT product, VERSION, status
FROM product_component_version;

-----------------------------------------------------
-- Query to  get cloned date of an oracle instance --
-----------------------------------------------------

SELECT resetlogs_time FROM v$database;


-------------------------------------------------
-- Query to get the front end URL from backend --
-------------------------------------------------
SELECT home_url FROM icx_parameters;

No comments:

Post a Comment

How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

  How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...