Oracle Apps R12: Check if the patch applied from sqlplus

Jan 19, 2021 | Oracle

Two tables to check if the patch is applied or not:

This table includes the defined bugs on the system:
SELECT   bug_number
FROM     apps.ad_bugs
WHERE   bug_number LIKE ‘%’ ||3594604 || ‘%’;

This table includes patches applied on the system:
SELECT patch_name
FROM   apps.ad_applied_patches
WHERE patch_name LIKE ‘%’ ||3594604 || ‘%’

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Your Title Goes Here

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Oracle Apps R12: Check if the patch applied from sqlplus

Your Title Goes Here

Your Title Goes Here

Your Title Goes Here

Let's set up a call?

We'll get in touch

Let's set up a call

We'll get in touch

Let's get on a call!

We'll get in touch

Subscribe To Keep Up To Date

You have Successfully Subscribed!