In this post, i will show you how to know all the applied patches details including (Patch number,creation date and patch type).
If you are looking for details of specific patch that was applied, you can use the below script to find the details.
Script:
If you are looking for details of specific patch that was applied, you can use the below script to find the details.
Script:
col PATCH_NAME format a10 col PATCH_TYPE format a10 col DRIVER_FILE_NAME format a15 col PLATFORM format a10 select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE, AD.PLATFORM,AL.LANGUAGE from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID and AP.PATCH_NAME = '1423433';
Output: PATCH_NAME PATCH_TYPE DRIVER_FILE_NAM CREATION_DATE PLATFORM LANG ---------- ---------- --------------- --------------- ---------- ---- 1423433 PATCH-SET u1423433.drv 01-SEP-15 GENERIC US
If you are looking for the details of all patches that was applied, you can use the below script to find the details.
Script:
col PRD format a40 trunc
col PRDID format a5
col PRDSTATUS format a10
col PATCHSET format a20
SELECT V.APPLICATION_NAME PRD, to_char(V.APPLICATION_ID) PRDID, L.MEANING PRDSTATUS, DECODE(I.PATCH_LEVEL, NULL, '11i.' || v.APPLICATION_SHORT_NAME || '.?', I.PATCH_LEVEL) patchset
FROM FND_APPLICATION_ALL_VIEW V, FND_PRODUCT_INSTALLATIONS I, FND_LOOKUPS L
WHERE (V.APPLICATION_ID = I.APPLICATION_ID)
AND (L.LOOKUP_TYPE = 'FND_PRODUCT_STATUS')
AND (L.LOOKUP_CODE = I.Status )
ORDER BY 1;
Output:
| PATCH_NO | PATCH_TYPE | DRIVER_FILE_NAME | CREATION_DATE | PLATFORM | LANGUAGE |
| 10422612 | ONE-OFF | u10422612.drv | 5-Aug-12 | GENERIC | US |
| 9922442 | ONE-OFF | u9922442.drv | 15-Feb-13 | GENERIC | US |
| 6524778 | ONE-OFF | u6524778.drv | 3-Jul-13 | GENERIC | US |
| 12609242 | ONE-OFF | u12609242.drv | 14-Jul-13 | GENERIC | US |
| 9839039 | ONE-OFF | u9839039.drv | 14-Aug-14 | GENERIC | US |
| 9239089 | PATCH-SET | u9239089.drv | 15-Aug-14 | SUN_OS5 | US |
| 9239090 | MAINTENANCE-PACK | u9239090.drv | 15-Aug-14 | SUN_OS5 | US |
Hope this post will helps you :)
No comments:
Post a Comment