Last updated on April 11th, 2019 at 05:52 pmWe 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 »