Home › Discussions › Questions & Answers › Audit Compliance: Using AD_PATCH.IS_PATCH_APPLIED with Blitz Report for EBS 12.2 Patch Status

Audit Compliance: Using AD_PATCH.IS_PATCH_APPLIED with Blitz Report for EBS 12.2 Patch Status

Avatar photoCustomer Questions & Answers 6 replies

Our audit team needs a definitive and reliable method to verify the status of applied AD/TXK Release Update Packs (RUPs) across our EBS 12.2 environments. We understand that directly querying the `AD_BUGS` table is no longer considered reliable for compliance checks in 12.2 due to potential incomplete patching cycles. Which standard Oracle database function should we use, and can we automate this process using a dedicated Blitz Report for easy access and record keeping?

6 replies

  • Support Enginatics

    For reliable verification of applied patches in EBS 12.2, you must use the Oracle-provided function `AD_PATCH.IS_PATCH_APPLIED`. This function returns an authoritative status, distinguishing between an ‘EXPLICITLY’ applied patch and a ‘NOT APPLIED’ status.

  • Avatar photoCustomer

    That function requires parameters like APPL_TOP_ID and EBS_RELEASE. Where do we find those values, especially in a multi-node installation?

  • Support Enginatics

    For the EBS release parameter, always use ‘R12’. For multi-node systems, the APPL_TOP_ID can be retrieved by querying `AD_APPL_TOPS` joined with `FND_APPL_TOPS` to filter out obsolete records. For single-node systems, you can typically use `-1`.

  • Support Enginatics

    To automate this check without connecting via SQLPlus or OAM, you can create a custom report in Blitz Report. The seeded report ‘AD Applied Patches R12.2’ uses this very function, accepting patch number, Appl Top Id, and Language as parameters.

  • Avatar photoCustomer

    How does using Blitz Report benefit the compliance process compared to running manual SQL queries?

  • Support Enginatics

    The key benefit is centralized control and ease of access directly from the EBS forms interface. Blitz Report eliminates the need for APPS user database access knowledge, provides LOVs for parameter selection, and instantly delivers the results as a perfectly formatted Excel output for clear auditing records.

  • You must be logged in to reply to this post.