If you want to submit any scripts useful for Apps DBA's then
Mail Me.
* Thanks to Vish for sharing these scripts with Other Oracle
apps DBA. These scripts are mentioned here for information only, Please test these before
executing them on Production Instance
/* To get information related to how many time driver file is applied for bugs */
select * from AD_PATCH_RUN_BUGS where BUG_ID in
(select BUG_ID from AD_BUGS where BUG_NUMBER = '<BUG NUMBER>'
/* To find latest patchset level for module installed */
select APP_SHORT_NAME, max(PATCH_LEVEL) from AD_PATCH_DRIVER_MINIPKS
GROUP BY APP_SHORT_NAME
/* To find what is being done by the patch */
select A.BUG_NUMBER "Patch Number", B. PATCh_RUN_BUG_ID "Run Id",D.APP_SHORT_NAME appl_top,
D.SUBDIR, D.FILENAME, max(F.VERSION) latest, E.ACTION_CODE action
from AD_BUGS A, AD_PATCH_RUN_BUGS B, AD_PATCH_RUN_BUG_ACTIONS C, AD_FILES D, AD_PATCH_COMMON_ACTIONS E, AD_FILE_VERSIONS F
where
A.BUG_ID = B.BUG_ID and B.PATCH_RUN_BUG_ID = C.PATCH_RUN_BUG_ID and
C.FILE_ID = D.FILE_ID and E.COMMON_ACTION_ID = C.COMMON_ACTION_ID and
D.FILE_ID = F.FILE_ID and
A.BUG_NUMBER = '<patch number>' and B.PATCH_RUN_BUG_ID = ' < > ' and
C.EXECUTED_FLAG = 'Y'
GROUP BY
A.BUG_NUMBER, B.PATCH_RUN_BUG_ID, D. APP_SHORT_NAME, D>SUBDIR, D.FILENAME, E.ACTION_CODE
/* To find Merged patch Information from database in Oracle Applications */
select bug_number from ad_bugs where bug_id in ( select bug_id from ad_comprising_patches
where patch_driver_id =(select patch_driver_id from ad_patch_drivers where applied_patch_id =&n) );
|
Previous Page
|
Next Page
|