[Feature Request]: Allow to persist failed transaction records

[dmohns]

Preflight Checklist

• I have read the Contributing Guidelines for this project, if it exists.
• I agree to follow the Code of Conduct that this project adheres to.
• I have searched the issue tracker for a feature request that matches the one I want to file, without success.

Problem Description

We are over using DB::Transaction. This make it hard to trace and reproduce error situations. It is totally normal business case that a transaction can be rejected.

It should be possible to persist this information in MPM. However, it's currently hard due to transaction processing being wrapped in a DB transaction

Proposed Solution

Change the flow to allow persisting of failed transactions.

Alternatives Considered

N/A

Additional Information

No response