Last updated on May 28th, 2019 at 03:45 amWe often get the task to check patch applied in 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 particular application select … Continue reading Top queries to find Patch applied in Oracle apps »