Oracle EBS: SO已book, 但無對應的workflow -- Part 2

這狀況又發生了, SO中有5個line, user要建立Delivery時有問題, 才發現第5個line沒有workflow, status還停在Booked.

有了上次的經驗, 這次處理速度快了些.


1.檢查workflow status, 沒資料

  SELECT *

    FROM wf_item_activity_statuses

   WHERE item_type = 'OEOL'

     AND item_key = TO_CHAR(1458486)

2.launch process

begin

    wf_engine.launchProcess('OEOL',  --itemtype in varchar2,

               1458486,  --1         itemkey  in varchar2,

               'Line Flow - Generic',--         process  in varchar2,

               'Sales Order 102013860, Line 5.1..', --         user_key in varchar2,

               'XX01530' );        -- owner_role in varchar2)

end;

3.再檢查workflow, 已有資料, line的status仍是Booked

4.commit


5.執行Workflow Background Process


搞定~