Oracle - Troubleshooting Workflow

1. Create SQL query to get ITEM_KEY
Use wf_messages_vl and wf_notifications tables.
2. Use Workflow Administrator Web Applications responsibility
3. Select Administrator Workflow > Status Monitor
4. Add Type Internal Name and Item Key and Go.

4.1. Click on Activity History 

Go to Notification column > Click Open > Shows error message

4.2. Click on Status Diagram

Check the process you are interested in.

5. Open the workflow in Workflow Builder > Processes (double click) > Click on the button > Check Function Name -> package and function name

 6. Check the code behind
resultout := Wf_Engine.eng_completed||':F';
Determines which case of the workflow will happen. This is an error one.