Following are some of the queries that can be used to get the database and Application information.
SQL Query To Get Product Version Of The Oracle Database And Application:
SQL Query To Get Oracle Applications Version and Patch Information:
SQL Query To Get The Information of Installed Patches In Oracle Applications:
SQL Query To Check Whether the Oracle application is setup for Multi-Org:
SQL Query To Get Product Version Of The Oracle Database And Application:
SELECT product , VERSION , status FROM product_component_version
Or Just run the following query to get the details
select * from v$version;
SQL Query To Get Oracle Applications Version and Patch Information:
SELECT SUBSTR (a.application_name, 1, 60) Application_Name , SUBSTR (i.product_version, 1, 4) Version , i.patch_level , i.application_id , i.last_update_date FROM apps.fnd_product_installations i , apps.fnd_application_all_view a WHERE i.application_id = a.application_id ORDER BY a.application_name
SQL Query To Get The Information of Installed Patches In Oracle Applications:
AD_APPLIED_PATCHES table stores information about all the patches installed in the system. Use the following query to get the details.
SELECT applied_patch_id , patch_name , patch_type , source_code , creation_date , last_update_date FROM ad_applied_patches
SQL Query To Check Whether the Oracle application is setup for Multi-Org:
SELECT multi_org_flag
FROM fnd_product_groups;
I am so excited that I have found this your post on SQL queries to get product version of Oracle database because I have been searching for some information about it almost half a day.
ReplyDeletesap support costs