Best way to get the Payment extract from back end tables in Fusion:

Fusion: Generate IBY PPR Diagnostic Report (Doc ID 1377744.1)

How to configure the Payments  Process Profile in Fusion:

Manage Transmission Configuration to setup all FTP and file format details.

Security details report:

BI Publisher - Fusion Apps - How Can A BI Publisher Report Based On A SQL Query Use The Security Roles In Fusion Applications? (Doc ID 1537196.1)