How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside)

  How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside) If you've ever administered Oracle E-...

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