Some miscellaneous workflow things I encountered.
Workflow can be started by two different ways
1. Itemtype (launch workflow)
2. wf_event.RAISE
So to search for the workflow in the code you have to keep in mind the above.
Deferred Events:
To find if you event or workflow is struck in the deferred Q, use the following query.
SELECT a.user_data.event_name event, a.msg_state status,a.user_data.send_date
FROM applsys.aq$wf_deferred a
WHERE a.user_data.event_name like 'oracle%write%'
No comments:
Post a Comment