Oracle ERP R12. - Resubmitting WIP_MOVE_TXN_INTERFACE

Resubmitting Failed Move Transactions

若WIP_MOVE_TXN_INTERFACE執行失敗後,經修正完錯誤原因後,要重新執行的Update 語法如下 :


UPDATE WIP_MOVE_TXN_INTERFACE A
   SET A.GROUP_ID = NULL,
       A.TRANSACTION_ID = NULL,
       A.PROCESS_STATUS = 1
 WHERE A.TRANSACTION_ID = <要重新執行的那些資料>


參考文件 : Oracle - Resolving Period Close Pending Transaction