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 5 replies

During critical patching windows in EBS 12.2, we need a fast and non-intrusive way to verify the application status of specific patches across multiple application tops, ideally without accessing the database command line (SQL*Plus) or OAM. Can Blitz Report help?

5 replies

  • Support Enginatics

    Absolutely. Blitz Report is the optimal method for this check, allowing execution directly from the EBS Forms interface, eliminating the need to log in to the database or navigate to the OAM page. You can create a custom report leveraging the Oracle function `AD_PATCH.IS_PATCH_APPLIED`.

  • Can you share the general structure or the necessary components that the custom Blitz Report SQL query would use with that function?

  • Support Enginatics

    The query uses `AD_PATCH.IS_PATCH_APPLIED` with parameters including the release (`’R12’`), application top ID (`aat.appl_top_id`), bug number (`adb.bug_number`), and language (`adb.language`). This function returns the status, allowing you to use a `DECODE` statement to clearly label the result as ‘APPLIED’ or ‘NOT APPLIED’ for specific bug numbers.

  • That is exactly what we need. Once created, how do we ensure quick access to this utility report?

  • Support Enginatics

    Once the custom query is defined, you can save it within the Blitz Report form for future quick access. It retains the report definition and parameters, turning a complex DBA query into a repeatable, one-click operational tool.

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