Aloz 的 Oracle ERP 天地

如果有使用到 Receiving Transaction Interface 處理資料, 如果遇到了錯誤, 除了處理發生問題的設定或資料外, 還要修正一下 Interface 的資料, 這樣在下一次的處理中才有辦法再被執行

/* 確定問題資料 : RCV_TRANSACTIONS_INTERFACE */

select REQUEST_ID
, GROUP_ID
, PROCESSING_REQUEST_ID
, VALIDATION_FLAG
, PROCESSING_STATUS_CODE
, TRANSACTION_STATUS_CODE
, PROCESSING_MODE_CODE
, INTERFACE_TRANSACTION_ID
from RCV_TRANSACTIONS_INTERFACE
where 0 = 0
and GROUP_ID = 45458
;

/* 確定問題資料 : RCV_HEADERS_INTERFACE */

select HEADER_INTERFACE_ID
, GROUP_ID
, PROCESSING_REQUEST_ID
, PROCESSING_STATUS_CODE
, VALIDATION_FLAG
from RCV_HEADERS_INTERFACE
where GROUP_ID = 45458
;

/* 修正問題資料 : RCV_TRANSACTIONS_INTERFACE */

update RCV_TRANSACTIONS_INTERFACE
set REQUEST_ID = null
, PROCESSING_REQUEST_ID = null
, VALIDATION_FLAG = 'Y'
, PROCESSING_STATUS_CODE = 'PENDING'
, TRANSACTION_STATUS_CODE = 'PENDING'
, PROCESSING_MODE_CODE = 'BATCH'
where 0 = 0
and GROUP_ID = 45458
;

/* 修正問題資料 : RCV_HEADERS_INTERFACE */

update RCV_HEADERS_INTERFACE
set PROCESSING_STATUS_CODE = 'PENDING'
, PROCESSING_REQUEST_ID = null
, VALIDATION_FLAG = 'Y'
where 0 = 0
and GROUP_ID = 45458
;

此時, 再去 Submit Request : Receiving Transaction Processor, 這樣才會真正的再處理一次喔