Oracle Apps Business Events Tables

Hi friends, we are going to discuss about Oracle Apps Business Events Tables. We will share the detail list of  Business Events Tables in oracle apps. These tables helps to store the business events details and its subscription details in oracle apps. Using these tables we can develop data extraction query related to business events. We will also share the detail sql query which helps to fetch the business events and the subscription details in oracle apps. Please find the complete detail about Oracle Apps Business Events Tables.

Oracle Apps Business Events Tables

3 Important Oracle Apps Business Events Tables

1 WF_EVENT_SUBSCRIPTIONS

2 APPLSYS.AQ$WF_DEFERRED

3 WF_EVENTS

SQL Query to extract the business event details using Oracle Apps Business Events Tables

Here below is the detail sql query to get the business events details in Oracle Apps

Business Event Subscription Detail SQL Query:- 

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;

Business Events SQL Query:-

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

Oracle Apps Business Events Tables