A problem about Autoinvoice

来源:互联网 发布:无线淘宝收藏店铺按钮 编辑:程序博客网 时间:2022/05/28 05:31

Please run the following fix

Update ra_interface_lines_all
set Request_id = Null
where NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NOT NULL)
AND BATCH_SOURCE_NAME = 'Order Entry' ;

COMMIT


After this rerun Autoinvoice Program and it will process all records.