完成 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
沒有留言:
張貼留言
歡迎討論指教,保留刪除留言權利。謝謝~