If you want to submit any scripts useful for Apps DBA's then
Mail Me.
* Thanks to Ramnik for sharing below script with Other Oracle
apps DBA. These scripts are mentioned here for information only, Please test these before
executing them on Production Instance
/* Second Query to know, what all has been done during application of PATCH */
Select J.PATCh_NAME, H.APPLICATIONS_SYSTEM_NAME Instance_Name, H.NAME, I.DRIVER_FILE_NAME,
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, AD_PATCH_RUNS G, AD_APPL_TOPS H,
AD_PATCH_DRIVERS I, AD_APPLIED_PATCHES J
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_ACION_ID = C.COMMON_ACTION_ID
and D.FILE_ID = F.FILE_ID
and G.APPL_TOP_ID = H.APPL_TOP_ID
and G.PATCH_DRIVER_ID = I.PATCH_DRIVER_ID
and I.APPLIED_PATCH_ID = J.APPLIED_PATCH_ID
and B.PATCH_RUN_ID = G.PATCH_RUN_ID
and C.EXECUTED_FLAG = 'Y'
and G.PATCH_DRIVER_ID
in (select PATCH_DRIVER_ID from AD_PATCH_DRIVERS where APPLIED_PATCH_ID
in (select APPLIED_PATCH_ID from AD_APPLIED_PATCHES where PATCH_NAME = '<Patch Number>'))
GROUP BY
J.PATCH_NAME, H.APPLICATINS_SYSTEM_NAME, H.NAME, I.DRIVER_FILE_BNAME, D.APP_SHORT_NAME,
D.SUBDIR, D.FILENAME, E.ACTION_CODE
/* Script to find out Patch level of mini Pack */
Select product_version,patch_level from
FND_PROUDCT_INSTALLATIONS
where patch_level like '%&shortname%';
Replace short name by name of Oracle Apps Minipack for which
you want to find out Patch level . ex.
AD - for Applications DBA
GL - for General Ledger
PO - Purchase Order
|
Previous Page
|
Main Script Page
|