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

Delete Organization Classification and Organization Using API when BG - Business Group Setup

  Oracle HRMS – Delete Organization Classification and Organization Using API 📘 Overview In Oracle HRMS, each organization is classified ...