修正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)

 

Oracle EBS: 批次將concurrent產出之output更名為所需之PO PDF

 針對以程式批次產出之PO PDF output, 整批進行更名並下載.

1.找出request_id與其中PO之關聯, 取得PO number

2.組出如下內容, 存檔為cp_po.sh

cp -p o172681076.out /tmp/pdf_file/3200244536.pdf

cp -p o172681077.out /tmp/pdf_file/3200244557.pdf

cp -p o172681078.out /tmp/pdf_file/3200244558.pdf

cp -p o172681079.out /tmp/pdf_file/3200244559.pdf

cp -p o172681080.out /tmp/pdf_file/3200244564.pdf

cp -p o172681081.out /tmp/pdf_file/3200244566.pdf

3.執行cp_po.sh

4.下載/tmp/pdf_file中的PDF檔案