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

Result:
Event Key passed: 1686010
