Oracle ERP R12. - Resubmitting WIP_COST_TXN_INTERFACE

Resubmitting Failed or Pending Resource Transactions

若工單過站charge resource交易的成本收集失敗,其交易會卡在WIP_COST_TXN_INTERFACE,並會造成無法關結期間.
重新執行的Update語法如下:


UPDATE WIP_COST_TXN_INTERFACE A
   SET A.GROUP_ID = NULL,
       A.TRANSACTION_ID = NULL,
       A.REQUEST_ID = NULL,
       A.PROCESS_STATUS = 1
 WHERE A.PROCESS_STATUS = 3 --Error


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