Hi. I am building a Standalone Workflow that is having some odd behavior. Sometimes in Status Monitor a launched process will show up when searching, and sometimes it does not. I have tried several ways:
- When launching directly from Developer Studio, it always can be found when searching in Status Monitor. No issues with this option.
- When launching from simple call from PL/SQL code in SQL Developer, at times it shows when searching in Status Monitor and sometimes it does not. In the times it does not show up in Status Monitor, I am able to query the workflow tables (WF_ITEMS for example) and am able to see the ITEM_TYPE/ITEM_KEY combination that I am expecting.
- Why would it show up in the tables but does not show up in Status Monitor?
- To make this even more puzzling, it seems as though when I make a change to the package that the workflow process is using (such as adding a DBMS_OUTPUT.PUT_LINE statement for debugging purposes), recompile, then go back to Status Monitor and search again for the same Workflow Type, some previous runs that not displaying before are now displaying in the search results.
Has anyone else had similar issues?
Thanks,
Maria Revels