Oracle Workflow Most Frequently Used Queries

1.     SQL Query To Find Out All Workflow Items For A Given Item Type:

2.     SQL Query To Find Out All Notifications Sent By A Particular Workflow:

3.     SQL Query To Find the Activity Statuses For All Workflow Activities For A Particular Item Type and Item key: 

4.     SQL Query To Find All Errored Workflow Activities For A Particular Item Type/ Item Key:

5.     SQL Query To Find Out Errored Process Activity Statuses For A Particular Item Type/Item Key: 

6.     SQL Query To Find Out The Errored Activities For A Particular Item Type/Item Key:

7.     SQL Query To Find Out Attribute Values Of A Workflow:

8.     SQL Query To Find Out Number Of Deferred Workflow Activities:

9.     SQL Query To Get The Details Of Various Workflow Agent Listeners And Their Statuses:

10.  SQL Query To Find Records That Are Pending In Each Of The Workflow Agent Listener Queues;

11.  SQL Query To Track The Status Of Notifications/Business Events That Are Waiting To Be Processed/That Have Errored Out: