Showing posts with label Business events trigger status. Show all posts
Showing posts with label Business events trigger status. Show all posts

Thursday, 2 April 2015

Query to check business event fire status

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 ;

Result:
Event Key passed: 1686010

Useful fusion query for User access

  Table FUN_USER_ROLE_DATA_ASGNMNTS is used for “Manage data access for users”. it will store use and role assignment to data security. Tabl...