Oracle EBS: PO workflow retry (wf_engine.handleerror)

幾十筆因reschedule PO而停在In process, 原因是人員帳號及buyer失效.

把帳號及buyer改為有效, 手動重跑workflow成功.

為了節省處理時間, 找出procedure , 先確定item_type和activity, 再用cursor取item_key, 就批次解決了.


begin
  wf_engine.handleerror('POAPPRV',                     --itemtype
                        '1450765-127028',              --itemkey
                        'APPROVE_PO_SUB_PROCESS_CO',   --activity(internal_name)
                        'RETRY',                       --command
                        NULL);                         --result
end;


Ref:
https://docs.oracle.com/cd/B13789_01/workflow.101/b10286/wfapi47.htm