狀況:
user作銷退, 但reference到的AR transaction金額已改為0, 因此error.
You can not apply more than the original line amount
解法:
確認要拋AR, 先清掉reference_line_id, 再清掉兩個欄位:
1.interface_line_id
2.request_id
找資料時發現有人遇過資料在interface中沒error, 但也沒轉成功, 這時要清的欄位是:
1.interface_line_id
2.request_id
3.customer_trx_id
4.link_to_line_id
UPDATE ra_interface_lines_all
SET interface_line_id = null,
customer_trx_id = null,
request_id = null,
link_to_line_id = null
WHERE nvl(interface_status,'x') != 'P';
Ref:
"Stuck in the Interface" , Invoice not created in AR and no error is showing in the interface. (or) The AutoInvoice Master Program (RAXMTR) may complete without error but will not spawn the AutoInvoice Import Program. And Sales Order Line status is "closed"
http://oracleappserpsolutions.blogspot.com/2015/06/stuck-in-interface-invoice-not-created.html
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。