Query to Check business Events in Oracle

Hi Friends, we are going to discuss about Query to check business events in oracle. We will share the detail sql query to find out the complete business events details and to check business events status and its fired status. Using this sql Query we can check the business events its triggered or not and its complete status in oracle apps. We will also share the important tables which helps to store the business events details and to check the business events in oracle apps. Please find below the complete detail about Query to check business events in oracle.

Query to check business events in oracle

3 Important Tables to check business events in oracle

1.APPLSYS.AQ$WF_DEFERRED

2. WF_EVENTS

3. WF_EVENT_SUBSCRIPTIONS

SQL Query to Check Business Events in Oracle Apps

Here below is the detail sql query to get the business Events Status in Oracle Apps

SELECT 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.fnd.req.completed' --Here We need to pass Business event name

GROUP BY a.msg_state, a.user_data.event_name, a.user_data.send_date

ORDER BY a.user_data.event_name,a.user_data.send_date DESC

SELECT 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.fnd.req.completed' --Here We need to pass Business event name

GROUP BY a.msg_state, a.user_data.event_name, a.user_data.send_date

ORDER BY a.user_data.event_name,a.user_data.send_date DESC

select w_even.name

  ,w_even.status event_status

  ,w_e_subs.status subscription_status

  ,nvl(w_e_subs.phase,0) subscription_phase

  ,w_e_subs.rule_function

from wf_events w_even

  ,wf_event_subscriptions w_e_subs

where

  w_even.name like 'xxcust.oracle.apps.cust.testBusinessEvent'

  and w_e_subs.event_filter_guid = w_even.guid;

Query to check business events in oracle