关闭

当发运后,成品数据一直在stage仓,造成不能立账的处理方法

标签: EBSOM
302人阅读 评论(0) 收藏 举报
分类:

-- Delivery Detail Line Status 始終是 Shipped ,一直沒有變成 Interfaced 的處理方法:
-- 1.
具體狀況為:
--
已做Ship Confirm 成功,但貨一直卡在Stage,沒有發出去. 也沒有拋AR Interface.
-- Delivery Detail
Line Status 始終是 Shipped ,一直沒有變成 Interfaced.
--
此時還未做Sales Order Issue交易, Ship Date 為空.
-- 2.
運行Request: Interface Trip Stop - SRS
--
參數: 指定Delivery,: J0001304; Debug Level = 1, Debugging ON.
-- 3.Request
運行結束, Phase = Completed, Status = Warning.
--
查看Log, 搜索'Error'關鍵字, 若搜索到類似以下Error Meesgae則繼續往下操作:
-- SQL ERROR MESSAGE FOR WHEN OTHRES:ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/209500'.
--
: 'OEOL/209500' 209500 Item Key, oe line id.
-- 4.
以下SQL查詢出現異常的oe_line_id:
Select distinct wdv.source_line_id oe_line_id
              , oe_interfaced_flag
              , inv_interfaced_flag
From wsh_deliverables_v wdv
Where 1 = 1
And wdv.delivery_id = 65107—(delivery id) -- J0003150 and oe_interfaced_flag = 'P'
and wdv.source_line_id  = 238146;
-- 5.
查詢以下SQL,結果為: process_activity = 161990(參考值,以實際結果為准), activity_status = COMPLETE, activity_result_code = SHIP_CONFIRM
--
參照步驟3Error Meesgae, activity_status應為NOTIFIED, activity_result_code 為空.
      Select wpa.process_name
            ,wpa.instance_label
            ,wias.process_activity -- 161990(
參考值,以實際結果為准)
            ,wias.activity_status -- COMPLETE
            ,wias.activity_result_code --SHIP_CONFIRM
            ,wias.*
      From   wf_item_activity_statuses wias, wf_process_activities wpa
      Where  wias.item_type = 'OEOL'
      And    wias.item_key In (Select Distinct to_char(wdv.source_line_id)
                               From   wsh_deliverables_v wdv
                               Where  1 = 1
                               And    wdv.delivery_id = 65107 -- J0001304
                               And    oe_interfaced_flag = 'P') --N
      And    wias.process_activity = wpa.instance_id
      And    wpa.activity_name = 'SHIP_LINE';
-- 6. Update activity_statu = 'NOTIFIED', activity_result_code = null,

该步骤的目的就是将状态退回到初始状态,重新跑workflow流程

    Update wf_item_activity_statuses wias
    Set    wias.activity_status = 'NOTIFIED'
         , wias.activity_result_code = Null
    Where  wias.item_key In (Select Distinct to_char(wdv.source_line_id)
                             From   wsh_deliverables_v wdv
                             Where  1 = 1
                             And    wdv.delivery_id = 65107 -- J0001304
                             And    oe_interfaced_flag = 'P') --N
    And    wias.process_activity = 161990--; -- 161990(
參考值,以步驟5查詢結果為准)
    AND    wias.item_key = 286811  --
可选                 
commit;
-- 7.
運行Request: Interface Trip Stop - SRS
--
參數: 指定Delivery,: J0001304; Debug Level = 1, Debugging ON.
-- 8.Request
運行結束, Phase = Completed, Status = Normal.
--
檢查Delivery(:J0001304),所有Delivery Detail Line Status 已變為 Interfaced,
-- Sales Order Issue
交易完成, AR Invoice 已產生.

--9.建议处理完接口后run2requestCreate Intercompany AR InvoicesAutoinvoice Master Program,为了产生AR invoice

PS:也可能出现Error msg: Your change invalidates the Customer Item Number on the Line.

这个说明customer item被失效掉了,找出出货的Sales order,在SO上找到失效的customer item,将其以及item cross reference全部启用后重新run request

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:8642次
    • 积分:448
    • 等级:
    • 排名:千里之外
    • 原创:37篇
    • 转载:3篇
    • 译文:0篇
    • 评论:0条
    文章分类