Debug Event Alert ( Event Alert Not Triggering)

Event Alert -- Debugging

If Event Alert Did not Fire
-------------------------------------------------------------------------------------------------------------

Find Out the Enabled Alerts in the System :

Run this Query

select dba_triggers.table_name, dba_triggers.trigger_name,
       dba_triggers.status, user_objects.status,
       dba_triggers.trigger_body
from   user_objects, dba_triggers
where  dba_triggers.trigger_name = user_objects.object_name and
       user_objects.object_type = 'TRIGGER' and
       user_objects.object_name like 'ALR_%'

****************************************************************************


Run this Query to Check Event Alert Submitted or not

SELECT REQUEST_ID
, REQUEST_DATE
, PHASE_CODE
, STATUS_CODE
, ORACLE_ID
, PROGRAM_APPLICATION_ID
, CONCURRENT_PROGRAM_ID
FROM APPLSYS.FND_CONCURRENT_REQUESTS
where Concurrent_program_id = (select Concurrent_program_id from fnd_concurrent_programs_tl where
USER_CONCURRENT_PROGRAM_NAME = 'Check Event Alert') order by request_date desc;

Status Code = C (completed).



--------------------------------------------------------------------------------------------------------------------------



Oracle Notes For Reference

How To Find Enabled Event Alerts on Oracle Applications Tables? [ID 1181594.1]
Event Alerts Not fired, (Check Event Alert) Request Not Submitted [ID 1067134.1]

{ID 98996.1 }- Event Alert is not Firing after Target Table is Updated or Inserted
{ID 48600.1} - Debugging Routine for Troubleshooting Event Alert Issues


-----------------------------------------------------------------------------------------------------------------------