This discussion is archived
5 Replies Latest reply: Dec 5, 2012 1:14 PM by Hussein Sawwan-Oracle RSS

Merge Patch

Nitin_Intg Newbie
Currently Being Moderated
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

Please confirm

thanks
  • 1. Re: Merge Patch
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Nitin_Intg wrote:
    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

    Please confirm

    thanks
    Yes, it will be there in AD_APPLIED_PATCHES and AD_BUGS tables.

    - 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.

    How to find Applied/Present Patches, Mini Packsand Family Packs in 11i

    Thanks,
    Hussein
  • 2. Re: Merge Patch
    Nitin_Intg Newbie
    Currently Being Moderated
    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 ?

    thanks,
    NB
  • 3. Re: Merge Patch
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Nitin_Intg wrote:
    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 ?

    thanks,
    NB
    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.

    Thanks,
    Hussein
  • 4. Re: Merge Patch
    Nitin_Intg Newbie
    Currently Being Moderated
    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
  • 5. Re: Merge Patch
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Nitin_Intg wrote:
    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
    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

    This info is available on OTN forum since the time eTRM was available for public access.

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points