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

Customer May 17, 2023 at 7:26 pm

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?

Viewing 6 reply threads

Author
Replies
- Support May 19, 2023 at 11:33 am
  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`.
- Customer May 20, 2023 at 10:43 pm
  What is the technical structure of the SQL query required to use this function for verification across multiple application tops?
- Support May 22, 2023 at 6:21 pm
  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.
- Customer May 24, 2023 at 6:03 pm
  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 May 26, 2023 at 7:12 pm
  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.
- Customer May 28, 2023 at 3:25 pm
  This capability sounds like a perfect addition to our general upgrade toolkit for EBS 12.2.
- Support May 29, 2023 at 3:23 pm
  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.
Author
Replies

Viewing 6 reply threads

You must be logged in to reply to this post.