INSTALLATION DOCUMENTS BY RAVI

Wednesday, November 1, 2017

How to get EBS (Oracle E-Business Suite) version, patch set and modules

1. SQL query to get the EBS version

Login to EBS database and run the below query to get EBS version

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;
















2. SQL query to get the EBS patch set number

SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE '%AD%' ;















3. SQL query to get the EBS modules

SELECT APPLICATION_ID, APPLICATION_SHORT_NAME, APPLICATION_NAME FROM FND_APPLICATION_V1;
















No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...