Does Last Update Date Column In The AD_APPLIED_PATCHES Table Get Updated For Every Patch Run

Does Last Update Date Column In The AD_APPLIED_PATCHES Table Get Updated For Every Patch Run?


Oracle Application Install - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]

Information in this document applies to any platform.

Goal

 Does Last Update Date Column In The AD_APPLIED_PATCHES Table Get Updated For Every Patch Run?

Fix

There is no information captured in the AD_APPLIED_PATCHES Table for every re-application of a patch.

Users should refer to tables like ad_patch_runs,ad_patch_run_bugs and ad_patch_run_bug_actions to see change in  last updated date as these tables hold information of  various runs of a  patch and the bugs that may or may not have got applied in a particular  invocation.

 Whereas the tables like ad_applied_patches and ad_bugs do not get updated their rows with various invocations of adpatchand hence last updated date also does not change.