we are having errored records processing_status_code = 'ERROR' or transaction_status_code = 'ERROR' from the previous months.
1--when we run this process next month, will we need to remove all previous months records from rcv_transactions_interface table ?
Or its fine to leave them as it is.
In general, how can we troubleshoot once a record got transaction status code as ERROR. Can we just update the transaction_status_code to NULL and rerun the concurrent program?
1. It's ok leave the ERROR records in the table but recommended to remove them periodically.
2. I believe both the transaction_status_code and processing_status_code need to be updated to PENDING.