Queries to know Information about your Oracle Instance

There are some quries given below by which you can get the information regarding your oracle application instance:

Query to find Oracle Apps Database Version

SELECT VERSION FROM V$INSTANCE ;

Query to find host name of Oracle Apps Instance

SELECT HOST_NAME FROM V$INSTANCE;

Query to find Oracle Apps Instance Version

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

Query to find Oracle Apps Instance Name

SELECT INSTANCE_NAME FROM V$INSTANCE;

Query to find Oracle Apps Instance is set up for MultiOrg

SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS;

Query to find list of Products and their version installed on your Oracle Apps Instance

SELECT * FROM PRODUCT_COMPONENT_VERSION;

Query to find workflow version

SELECT TEXT FROM WF_RESOURCES WHERE NAME= 'WF_VERSION';

Query to find Database Version and PL/SQL version

SELECT * FROM V$VERSION;

Query to find Database Status

SELECT STATUS FROM V$INSTANCE;

Query to find Application Patch Level

SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE '%&Your_Application_Short_Name%';