AD_BUGS 和 AD_APPLID_PATCHES 的区别-优快云博客

本文介绍了Oracle应用程序中两个重要的表：AD_BUGS和AD_APPLIED_PATCHES。AD_BUGS记录了已应用补丁中包含的所有Bug信息；AD_APPLIED_PATCHES则记录了所有已应用的独特补丁详情，即使补丁名称相同但内容不同也会被视为独立条目。

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.

Ad_applied_patches contains information about patches that you applied on the system,
ad_bugs has information about all bugs and patches that have been included in the patches you applied.

For example you apply merged patch merge123 it contains 5 patches
10001 10002 10003 …
ad_applied_patches – will have one record about merge123
ad_bugs – 5 records

Another example: you apply maintenance patch which includes 51 other
patches. In that case
ad_applied_patches – will have one record about maintenance patch
ad_bugs – 51 + 1

I use ad_bugs table in order to find out do I have one or another patch to apply.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-737347/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-737347/