Home › Discussions › Questions & Answers › How to check if a patch is applied in Oracle EBS 12.2

How to check if a patch is applied in Oracle EBS 12.2

Avatar photoCustomer Questions & Answers 7 replies

During our EBS 12.2 patching cycles, the critical step of verifying whether a patch (identified by a bug number) has been successfully applied to the correct application top is cumbersome, usually requiring OAM navigation or direct SQL access. Can Blitz Report provide a simplified, repeatable method for this verification?

7 replies

  • Support Enginatics

    Yes, Blitz Report is the optimal method for simplifying patch verification, allowing execution directly from the EBS Forms interface. You can create a custom report utilizing the standard Oracle function `AD_PATCH.IS_PATCH_APPLIED`.

  • Avatar photoCustomer

    What is the technical structure of the SQL query required to use this function for verification across multiple application tops?

  • Support Enginatics

    The query needs to join `ad_bugs` (adb) and `ad_appl_tops` (aat) to map the bug number to the application top. You call the function `ad_patch.is_patch_applied` using four parameters: the release (`’R12’`), the application top ID (`aat.appl_top_id`), the bug number (`adb.bug_number`), and the language (`adb.language`). The result uses a `DECODE` statement to clearly display ‘APPLIED’ if the function returns ‘EXPLICIT’ and ‘NOT APPLIED’ otherwise.

  • Avatar photoCustomer

    The main benefit we seek is avoiding direct database login or relying on OAM. Does saving this query in Blitz Report automate the access permissions needed to query these fundamental DBA tables?

  • Support Enginatics

    By defining and saving this custom report within Blitz Report, you create a repeatable utility accessible via the EBS Forms interface, removing the necessity to log in to the database or navigate to the OAM page for verification. Once saved, the report definition, including the complex SQL, is instantly available for quick access.

  • Avatar photoCustomer

    This capability sounds like a perfect addition to our general upgrade toolkit for EBS 12.2.

  • Support Enginatics

    It is indeed an essential part of the project implementation and upgrade toolkit. Tools like this, which leverage existing EBS functions for rapid checks, streamline overall project management and audit compliance without the typical reporting overhead.

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