Business Event subscription Tables in Oracle Apps

Hi friends, we are going to discuss about the Business Event subscription Tables in Oracle Apps. We will share all the important tables list which do store the Business Event subscription details in oracle apps. In this post , We will share the both Business Event and Business Event subscription Tables. Both Business Event and Business Event subscription are interlinked with each other. We do create the subscriptions inside the Business event in Oracle apps. We can use these tables to get the details of Business Event subscription and to check that whether the Business Event triggered or not. Please find below the complete detail about the Business Event subscription Tables in Oracle Apps.

Business Event subscription Tables in Oracle Apps

3 Important Business Event subscription Tables in Oracle Apps

1. WF_EVENTS

2. WF_EVENT_SUBSCRIPTIONS

3. applsys.aq$wf_deferred

SQL Query Using Business Event subscription Tables to get Business Event subscription Details

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;

SQL Query to Check Business Event subscription status(Triggered or Not)

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

Business Event subscription Tables in Oracle Apps