Top queries to find Patch applied in Oracle apps

We often get the task to check patches applied in the oracle apps environment. Here are the Top queries to find Patch applied in EBS How to find if the bug number or patch is applied to Apps EBS select substr(APPLICATION_SHORT_NAME,1,10) Product,substr(BUG_NUMBER,1,10),Version,last_update_date applied_date from ad_bugs where BUG_NUMBER= to_char(‘&bug_no’); How to find the patch level of …

Top queries to find Patch applied in Oracle apps Read More »