Thursday, October 7, 2010

Alert History

I have learned that alerts which are runned by Oracle Applications Alert Manager are being logged, alerts' running times and outputs can be seen via following query

select * from ALR_ALERTS al, ALR_ALERT_CHECKS alc, ALR_ALERT_OUTPUTS alo
where al.alert_id=alc.alert_id
and al.alert_id=alo.alert_id
and al.alert_name like '%'
order by alc.last_update_date desc

No comments:

Post a Comment