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