Receiving Transactions Processor - Failed Receipt transactions deleted from rcv_transactions_interfa
We are loading rcv_headers_interface and rcv_transactions_interface for Ariba and other Legacy receipts, there are situations when few receipts are getting failed due to validations. We would like to correct those problems and re-process failed receipts records but the problem we are facing that failed receipts are getting deleted from rcv_transactions_interface table which means we have record in rcv_headers_interface but does not exists in rcv_transactions_interface for failed receipt.
Ideally failed receipts records should not be deleted from rcv_transactions_interface table.
We are not able to re-produce the issue in any of our test instance but its happening almost every day in Production.