Difference between AD_BUGS and AD_APPLIED_PATCHES table.

Oracle: Difference between AD_BUGS and AD_APPLIED_PATCHES table.

AD_BUGS: 

========
Holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

AD_APPLIED_PATCHES:

===================
Holds information about the "distinct" Oracle Applications patches that have been applied. 
If 2 patches happen to have the same name but are different in content (eg. "merged" patches), then they are considered distinct and this table will therefore hold 2 records.

Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions