Home › Discussions › Questions & Answers › EBS 12.2 Patch Application Status Check via Forms Interface
EBS 12.2 Patch Application Status Check via Forms Interface
Customer · · Questions & Answers · 9 replies
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?
9 replies
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`).
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?
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.
I need to check the status across multiple application nodes simultaneously for specific patches. Can the report accommodate multiple inputs?
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.
Where can I find the list of installed languages in my EBS system to provide to the function?
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.
If I copy a seeded report to modify it, are the assignments and category linkages copied too?
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.
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.