metanett

Here is a WF query for EBS. If you want to see all process and activities on DB instead of status monitor for a completed workflow, it can be useful for you. Just give ITEM_KEY and  ITEM_TYPE parameter and wait for the response. It can takes 3-5 minutes if you are not purging old workflows. SELECT sta.item_type item_type,          sta.activity_result_code result,          pra.process_name || ' : ' || pra.instance_label process_activity_label,          sta.process_activity instance_id,          sta.item_key item_key, sta.begin_date     FROM wf_item_activity_statuses sta, wf_process_activities pra    WHERE     sta.item_key = p_item_key          AND sta.item_type = p_item_type      ...

Today a lot of process has a approval flow on ERP systems. I got a problem on Oracle E-Business Suite recently. When we approve a notification with computer (like outlook) or on worklist (oracle self service responsibility) it approved. We got no error. But when we give approve response with smartphone ( like blackberry or i-phone ) approve answer didn't come inbox folder on mail server. So po didn't approved. Then I run " Synchronize Workflow LOCAL tables" concurrent from sysadmin responsibilty and it solve the problem. You can get more information from  the following link. http://vivekrajendran.wordpress.com/2011/02/23/about-po-approval-and-workflow-notification-mailer-integration-with-blackberry/