Workflow Activity Status

http://oracleapps4u.blogspot.in

The combination of order type/line type/item type determines the line workflow.
If you leave Item Type blank, the workflow applies to all item types for the line type (unless they have a specific assignment in this form).
In Process Name, select the workflow that Oracle Order Management should use for the order type/line type/item type combination.
If you do not assign a workflow to a configured item type, the configured item does not use a workflow.
You can perform all standard processing including orders, returns, drop-ship orders, Orders for configured items, and orders for assemble-to-order items using seeded workflows.



Check Order line Workflow Activity Status
  SELECT COUNT (1)
        INTO ln_completed_lines
        FROM wf_item_activity_statuses a,
             wf_process_activities b,
             oe_order_lines_all c
       WHERE a.process_activity = b.instance_id
         AND b.process_item_type = 'OEOL'
         AND b.activity_name = <‘Activity_Name’>
         AND activity_status = 'COMPLETE'
         AND item_key = TO_CHAR (c.line_id)
         AND c.header_id = pin_order_header_id


Submit the OEOH & OEOL (Header & line workflow) from database:
BEGIN
wf_engine.Background (itemtype=>'OEOH', -- ‘OEOL’
                      minthreshold => NULL,
                      maxthreshold => NULL,
                      process_deferred => TRUE,
                      process_timeout=> FALSE,
                      process_stuck => NULL);
END;
When an order header workflow is error out, how to retry the workflow for the order?
Go to workflow administrator, provide the item key (header_id) and submit to retry the WF for the corresponding order.