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 change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...