PO状态之po in process 解法:
方法1:建议改成INCOMPLETE,然后打开,重新提交审批
方法2:到工作流管理那里去做加速处理,加速成已审批
目的都是为了要走系统的工作流。
为什么不直接改为 approved,是因为太危险!因为你不清楚,系统在对po头的状态更新的同时还更新或者记录了什么东西,如果出现问题将是很麻烦的。不过,如果你非常清楚,从技术的角度,这个po的审批流做了什么,你也可以自己手工这么干。
无私奉献,欢迎大家交流:Step 1. 找出In Process的PR
Step 2. 找出此PR的WF_ITEM_TYPE及WF_ITEM_KEYselect requisition_header_id,segment1 pr_no,wf_item_type,wf_item_keyfrom po_requisition_headers_allwhere segment1 = '10501028';
Step 3. 于SQL *Plus下执行wfretry.sql (此sql要先从server上的$FND_TOP/sql目录download下来)于Value of 1输入REQAPPRV (即Step 2中的WF_ITEM_TYPE)于Value of 2输入Step 2中的WF_ITEM_KEY于Label输入MAIN_REQAPPRV_PROCESS于Command输入RETRY于Result直接按[Enter]
Step 4.再进ERP确认此PR是否已为Approved,若仍为In Process则重复
附 :wfretry.sql
/* Formatted on 2006/04/30 15:15 (Formatter Plus v4.8.7) */
REM HEADER
REM $Header: wfretry.sql 115.4 2001/03/29 20:51:49 pkm ship $
REM NAME
REM wfretry.sql - WorkFlow Handle error'ed activity
REM USAGE
REM @wfretry
REM DESCRIPTION
REM Displays a list of errored activityes for the indicated item.
REM Type in the name of the activity, and command to skip, retry, or reset.
SET verify off
DEFINE item_type='&1'
DEFINE item_key='&2'
PROMPT Select from list of error activities
SELECT pa.instance_label label, ias.activity_result_code RESULT
FROM wf_item_activity_statuses ias, wf_process_activities pa
WHERE ias.item_type = '&item_type'
AND ias.item_key = '&item_key'
AND ias.process_activity = pa.instance_id
AND ias.activity_status = 'ERROR'
/
ACCEPT activity prompt "Label: "
PROMPT SKIP, RETRY or RESET activity?
ACCEPT comflag prompt "Command: "
PROMPT Result of activity if command is SKIP
ACCEPT result prompt "Result: "
BEGIN
wf_engine.handleerror ('&item_type',
'&item_key',
'&activity',
'&comflag',
'&result'
);
END;
/
SET verify on
COMMIT ;
EXIT;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/226700/viewspace-831965/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/226700/viewspace-831965/