Query to check Oracle alert history

Hi friends, we are going to discuss about Query to check oracle alert history. We will share the detail sql query to find out the Oracle alerts history in oracle apps. Using this query , we can find out the complete history about the oracle alerts in oracle. If we want to see the oracle alert running history then we can also refer the fnd_concurrent_requests table. As alert scheduled in oracle apps as an oracle concurrent requests. We will also try to share the oracle alerts tables which help to store the oracle alerts history detail in oracle apps. Please find below the complete details about the Query to check Oracle alert history.

Query to check Oracle alert history

5 Important Tables to check Oracle alert history

1.ALR_ALERTS

2.ALR_ACTION_HISTORY

3.ALR_OUTPUT_HISTORY

4.ALR_ACTIONS_V

5.ALR_ALERT_HISTORY_VIEW

Detail SQL Query to get the Oracle alert history Detail in Oracle Apps

We are sharing this below query to get the oracle alerts history detail in oracle apps.

SELECT ALR_ACT .name,

ALR_ACT.description,

ALR_ACT.action_type,

ALR_ACT.action_level_type,

ALR_ACT.subject ,

ALR_ACT.msg_body

FROM 

ALR_ALERTS AL ,

ALR_ACTION_HISTORY AAH ,

ALR_OUTPUT_HISTORY AOH , 

ALR_ACTIONS_V ALR_ACT, 

ALR_ALERT_HISTORY_VIEW ALR_ACT_HIS 

WHERE AL.ALERT_NAME LIKE 'XX%'

AND AAH .CHECK_ID = AOH.CHECK_ID

AND ALR_ACT .ALERT_ID = AAH.ALERT_ID 

AND ALR_ACT_HIS.ALERT_NAME = AL.ALERT_NAME

AND AL.ALERT_ID = AAH.ALERT_ID

Query to check Oracle alert history