Chitika Add

Friday, November 23

Useful script on Oracle alert History

select
distinct AAHV . *
FROM apps.ALR_ALERTS al ,
APPS.ALR_ACTION_HISTORY AAH ,
APPS.ALR_OUTPUT_HISTORY AOH ,
APPS.ALR_ACTIONS_V ALV ,
apps.ALR_ALERT_HISTORY_VIEW AAHV
WHERE al . alert_name ='HOLX_ADDR_CHG_FIELD_ENGR' --'XX_ALERTS_SAMPLE'
AND al . alert_id = aah . alert_id
AND aah . check_id = aoh . check_id
and ALV . ALERT_ID = AAH . ALERT_ID
and AAHV . ALERT_NAME = AL . ALERT_NAME
order by aahv.alert_check_date desc;