Business Event And Subscription Query.txt

Query to find business events and it's subscription select we.name ,we.status event_status ,wes.status subscription_status ,nvl(wes.phase,0) subscription_phase ,wes.licensed_flag subscription_licensed_flag ,we.licensed_flag event_licensed_flag ,wes.rule_function from wf_events we ,wf_event_subscriptions wes where we.name like 'oracle.apps.fnd.%' and wes.event_filter_guid = we.guid;

Below query can be used to check Business events trigger status in oracle from database: SELECT COUNT(1), a.msg_state, a.user_data.event_name, a.user_data.send_date FROM applsys.aq$wf_deferred a WHERE a.user_data.event_name LIKE 'oracle.apps.ont.oi.xml_int.status' --Business event name AND a.user_data.send_date > SYSDATE - 1 GROUP BY a.msg_state, a.user_data.event_name, a.user_data.send_date ORDER BY 1, 2 ;