Oracle EBS 如何查看补丁是否打过是否生效

Oracle EBS 如何查看补丁是否打过是否生效 

Release 12.2 - confirming a patch is applied:

select
'Patch '|| &patch_number
||' is '||
ad_patch.is_patch_applied('R12',-1,'&&patch_number')
||'. (EXPLICIT means Applied - NOT APPLIED means Not Applied)'||'' result
from dual;

Note: STATUS

N - Not Applied In the current node but applied in other nodes
R - Patch Application is going on.
H - Patch failed in the middle. (Hard Failure)
F - Patch failed in the middle but user tried to skip some failures.
S - Patch Application succeeded after skipping the failed jobs.
Y - Patch Application succeeded.

C - Reserved for clone and config_clone. Indicates clone completed

-- 刘轶鹤转