修正ra_interface_lines_all中資料以重新作autoinvoice

修正ra_interface_lines_all中資料以重新作autoinvoice

1.確認Auto Invoice程式未在執行中

2.清除ra_inteface_lines_all中的flag並commit

UPDATE ra_interface_lines_all
    SET interface_line_id = NULL,
        customer_trx_id = NULL,
        request_id = NULL,
        link_to_line_id = NULL,
        interface_status  = null
  WHERE NVL (interface_status, 'x') != 'P';

 3.重新執行AutoInvoice

 

Ref:

1.AutoInvoice: "Stuck in the Interface" issue

http://oraclapps.blogspot.com/2019/07/autoinvoice-stuck-in-interface-issue.html

 

2.Troubleshooting AutoInvoice: "Stuck in the Interface" issues: Interface line not created in AR and no error is showing in the interface (Doc ID 1146573.1)