2013年9月5日 星期四

[OM.Shipment.ISSUE] Ship Confirm 後資料沒有拋轉到 AR Interface

[Symptom] 
完成 Ship Confirm 作業後資料沒有拋轉到 AR Interface.

1.做完 Ship Confirm, 狀態已 Close.
2.Sales Order Status 無法 Close.
3.Sales Order Line's Status 停在 Shipped.
4.檢查 Material Transaction 皆已完成扣帳.
5.檢查 AR Interface 沒有拋輚資料.



1.Delivery Status : Closed / Firm Status: Not Firm


















2.Delivery detail / Next Step: Not Applicable


















3.Sales Order 無法 Close





















4.Sales Order Line's Status 停在 Shipped.
























.
.
.
[Cause]
Workflow Background Process 停止.

[Solution]
System User: System Administrator
Program Path: Requests>Run:Submit requests
Program :Workflow Background Process
拋轉AR Interface Workflow輸入參數條件如下:

觸發拋轉AR Interface Workflow參數










.
.
.
.
.
.
.
.
.
.
.
.
.
Process run 完後至 AR Interface 檢查, 即會有資料.

[Other Information]
1.
Interface Table
Inventory Interface Table : MTL_TRANSACTIONS_INTERFACE
AR Interface Table: RA_INTERFACE_LINES_ALL

2.
/* 查看 Workflow Background Process */
/* COMPLETION_TEXT: An error occurred while attempting to terminate this request.*/
SELECT
       TO_CHAR(V.ACTUAL_START_DATE,'YYYY-MM-DD HH24:MM:SS') D
     , V.USER_CONCURRENT_PROGRAM_NAME pgname
     , V.PROGRAM_SHORT_NAME short_name
     , V.REQUEST_ID
     , V.PHASE_CODE AS PHASE
     , V.STATUS_CODE AS STATUS
     , V.COMPLETION_TEXT    
FROM FND_CONC_REQ_SUMMARY_V V
   , FND_USER FU
   , FND_RESPONSIBILITY_TL RB
WHERE 1=1
  AND V.REQUESTOR = FU.USER_NAME
  AND V.RESPONSIBILITY_ID = RB.RESPONSIBILITY_ID
  AND V.USER_CONCURRENT_PROGRAM_NAME LIKE '%Workflow Background Process%'
  AND (V.PHASE_CODE <> 'C' AND V.STATUS_CODE <> 'C'
    or V.PHASE_CODE = 'C' AND V.STATUS_CODE = 'X')
ORDER BY V.ACTUAL_START_DATE DESC

沒有留言:

張貼留言

歡迎討論指教,保留刪除留言權利。謝謝~