料號禁用,在做履行接受時,資料無法傳送AR介面
一、檢視訂單行狀態:
在檢視行狀態,發現已經關閉了,但是INVOICE_INTERFACE_STATUS_CODE = NOT_ELIGIBLEINVOICED_QUANTITY = NULL
SELECT ool.fulfilled_quantity, ool.invoice_interface_status_code, ool.open_flag, ool.flow_status_code, ool.line_id, ool.invoiced_quantity, ool.ordered_quantity, ooh.order_number FROM oe_order_headers_all ooh, oe_order_lines_allool WHERE 1 = 1 AND ooh.header_id = ool.header_id AND ooh.org_id = 81 AND ool.line_id = 131959;
二、檢視訂單行工作流狀態:
SELECT ias.item_type , ias.item_key , pa.instance_label , ias.activity_result_code result , ias.activity_status FROM wf_item_activity_statuses ias, wf_process_activities pa WHERE1 = 1 AND ias.item_type LIKE 'OEOL' AND ias.item_key LIKE '131959' --AND pa.instance_label LIKE 'instance_label' AND ias.process_activity = pa.instance_id --AND ias.activity_status = 'ERROR' ORDER BY ias.item_key, ias.begin_date
三、執行匯入介面表:
DECLARE l_result_outVARCHAR2(30); l_return_status VARCHAR2(30); CURSOR cur_order_info IS SELECT line_id FROM oe_order_lines_all WHERE line_id = 131959; BEGIN fnd_global.apps_initialize(user_id=> 1292, resp_id=> 50830, resp_appl_id => 222); mo_global.init('S', 81); FOR rec IN cur_order_info LOOP UPDATE oe_order_lines_all SET invoiced_quantity= NULL, invoice_interface_status_code = NULL, --fulfilled_quantity= ordered_quantity, --非銷退不要更新 open_flag= 'N', flow_status_code= 'CANCELLED', last_updated_by= -1, last_update_date= SYSDATE WHERE line_id = rec.line_id; DELETE FROM ra_interface_lines_all WHERE interface_line_attribute6 = to_char(rec.line_id); DELETE FROM ra_interface_salescredits_all WHERE interface_line_attribute6 = to_char(rec.line_id); COMMIT; oe_invoice_pub.interface_line(rec.line_id, 'OEOL', l_result_out, l_return_status); dbms_output.put_line(to_char(rec.line_id) || '+' || l_result_out || '+' ||l_return_status); commit; END LOOP; END;
執行之後,檢視狀態(已連線至應收款管理系統),已經成功插入介面表中
四、跑INVOICE_INTERFACE工作流:
由於工作流中的interface 都是未完成,需要更改工作流狀態(執行本程式後,請等5-10分鐘,讓系統的工作流跑完)
BEGIN fnd_global.apps_initialize(user_id=> 1292, resp_id=> 50830, resp_appl_id => 222); mo_global.init('S', 81); wf_engine.handleerror(itemtype => 'OEOL', itemkey => 131959, activity => 'INVOICE_INTERFACE', command => 'RETRY', RESULT => NULL); commit; END;
執行之後,檢視訂單行狀態,已經關閉。
檢視訂單行工作流狀態,如下圖所示:
五、跑CLOSE_LINE工作流:
此時發現 CLOSE_LINE_PROCESS 還沒有結果,所以需要再重新執行一遍工作流關閉的節點。(執行本程式後,請等5-10分鐘,讓系統的工作流跑完)
BEGIN fnd_global.apps_initialize(user_id=> 1292, resp_id=> 50830, resp_appl_id => 222); mo_global.init('S', 81); wf_engine.handleerror(itemtype => 'OEOL', itemkey => 131959, activity => ' CLOSE_LINE', command => 'RETRY', RESULT => NULL); commit; END;
檢視訂單行工作流狀態,如下圖所示:
OM模組流程結束。
六、附 OM行上檢視工作流狀態方法: