Port transaction details in the DB report mediator

[SanojPunchihewa]

Description

We need to port #2089 to the following doc spaces:

MI 420
MI 440
MI 450

Version

No response

[wso2-engineering-bot]

@wso2-engineering-bot create a PR for this issue following repo conventions

[SanojPunchihewa]

Closing this as all the PRs are merged