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
I am happy to find this post Very useful for me, as it contains lot of information. I Always prefer to read The Quality and glad I found this thing in you post. Thanks Eric Samek Brasa Capital
ReplyDeleteThank you
DeleteWow i can say that this is another great article as expected of this blog.Bookmarked this site.. click here
ReplyDeleteThanks for sharing this blog. The content is beneficial and useful. Very informative post. Visit here to learn more about Data Warehousing companies and Data analytics Companies. I am impressed by the information that you have on this blog. Thanks once more for all the details.Visit here for Top Big Data Companies.
ReplyDeleteThank you
ReplyDeleteIt's really a great and helpful piece of info. I'm glad that you just shared this useful information with us. Please keep us up to date like this. Thank you for sharing.Here is the right place to Submit Guest Post Big Data.
ReplyDeleteThank you very much
ReplyDelete