How Do You Know If A Specific Oracle Patch Has Been Applied In Apps T

1.	How Do You Know If A Specific Oracle Patch Has Been Applied In Apps To Your Environment?
Answer» Use table ad_bugs, in which COLUMN bug_number is the PATCH number. SELECT bug_number ,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated FROM apps.ad_bugs WHERE bug_number = TRIM(‘&bug_number’) ; Use table ad_bugs, in which column bug_number is the patch number. SELECT bug_number ,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated FROM apps.ad_bugs WHERE bug_number = TRIM(‘&bug_number’) ;

How Do You Know If A Specific Oracle Patch Has Been Applied In Apps To Your Environment?

Answer»

Use table ad_bugs, in which COLUMN bug_number is the PATCH number.

SELECT bug_number
,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated
FROM apps.ad_bugs
WHERE bug_number = TRIM(‘&bug_number’) ;

Use table ad_bugs, in which column bug_number is the patch number.

SELECT bug_number
,to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated
FROM apps.ad_bugs
WHERE bug_number = TRIM(‘&bug_number’) ;