EBS 12.2 Patch Application Status Check via Forms Interface

Customer September 11, 2021 at 3:28 am

We need to verify if a mandatory patch has been applied to our Oracle EBS 12.2 instance before proceeding with a major upgrade. I usually do this via SQL Developer, but is there a simpler way for my functional team to check this directly from the EBS interface?

Viewing 8 reply threads

Author
Replies
- Support September 11, 2021 at 5:36 pm
  Yes, using a Blitz Report provides a simple and quick way for any authorized user to check the patch status directly from the EBS Forms interface, without needing database access or OAM navigation. You can create a custom report leveraging the Oracle function `ad_patch.is_patch_applied` within your SQL extraction query. This function requires input parameters such as the EBS release (‘R12’), the Application Top ID (`&appltop_id`), the patch number (`&patch_num`), and the language code (`&lang`).
- Customer September 13, 2021 at 3:40 am
  If I create this custom report, how does it handle the input parameters like the Application Top ID, which can be complicated to look up manually?
- Support September 15, 2021 at 6:23 am
  A well-designed Blitz Report would utilize List of Values (LOVs) for complex parameters such as the Application Top ID, allowing users to select the value from a list rather than inputting it manually. The underlying SQL for the LOV can query the `applsys.ad_appl_tops` table to fetch the available Application Top IDs and names. When the report runs, it presents a perfectly formatted Excel output confirming whether the patch status is ‘APPLIED’ or ‘NOT APPLIED’ for the specified configuration.
- Customer September 17, 2021 at 3:58 am
  I need to check the status across multiple application nodes simultaneously for specific patches. Can the report accommodate multiple inputs?
- Support September 18, 2021 at 2:27 pm
  If you wish to check multiple patches across multiple application nodes and languages, you would modify the core report SQL to join `ad_bugs` and `ad_appl_tops` tables, passing the patch number list to the `ad_bugs` filter. This is essentially optimizing the query presented in the documentation to make it flexible for simultaneous node and patch verification, displaying the status for each unique combination of bug number, application top name, and language.
- Customer September 20, 2021 at 4:04 am
  Where can I find the list of installed languages in my EBS system to provide to the function?
- Support September 21, 2021 at 12:19 pm
  You can find the list of installed language codes by running a SQL query against the `fnd_languages` table, specifically looking where the `installed_flag` is set to ‘I’. This gives you the necessary `language_code` and `nls_language` information that can be passed to the fourth parameter of the `ad_patch.is_patch_applied` function, although ‘US’ is used by default if no language is specified.
- Customer September 22, 2021 at 7:31 am
  If I copy a seeded report to modify it, are the assignments and category linkages copied too?
- Support September 24, 2021 at 12:00 am
  When you use the ‘Copy Report’ functionality, a new copy of the existing report is created, which is the recommended method before making any changes to ensure seeded reports remain untouched. However, you should note that neither the existing Assignments nor the Category assignments are copied along with the report definition itself, so you will need to re-establish those linkages manually or via the Tools > Assignments menu option.
Author
Replies