Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  How could I know if a patch is already applied ?

NOTE: This article named How could I know if a patch is already applied ?  was taken from  www.in-oracle.com.

SQL> conn apps/apps
Connected.

SQL> select BUG_NUMBER,CREATION_DATE, SUCCESS_FLAG from AD_BUGS where bug_number='6117031';

no rows selected

If there are no rows selected that means the patch is not applied. 

NOTE: This could be done using Oracle Application Manager as well. 

NOTE: This article named How could I know if a patch is already applied ?  was taken from  www.in-oracle.com.