Nitin_Intg wrote:Yes, it will be there in AD_APPLIED_PATCHES and AD_BUGS tables.
I need some clarification on merge patches
If you merge multiple patches and then apply those-do the individual patches get reflected in ad_applied_patches table
Nitin_Intg wrote:You should always query AG_BUGS to identify if the patch is applied or not (whether individually or merged). Querying AD_APPLIED_PATCHES alone is not a good practice.
Thank You !!
Let me explain why i asked this-
before raising this question-
I had queried ad_bugs table and as expected i saw this patch there which was applied as part of the merge patch
But when i queried ad_applied_patches table it did not return any row
Also from OAM when i query for that patch it does show it as a merged patch
Not sure why it would not show in ad_applied_patches table-Only reason would be that it was applied as a merge patch
What do you think ?
Nitin_Intg wrote:This is not definition and it is Oracle eTRM definition -- http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=AD_APPLIED_PATCHES&c_owner=APPLSYS&c_type=TABLE
But that does not answer my question
If ad_applied_patches table inserts each individual patch then how come i don't see an entry after having applied that particular patch through a merge patch
Because if that is the case then your definition of
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.
does not completely hold true