The below query can help extract the Oracle Payments xml file which is processed by Oracle cloud ERP Payments module.
This query extracts the formatted xml which is sent to the bank. This can greatly help in Debugging Payment issues:
SELECT *
FROM iby_trxn_documents itd
WHERE itd.payment_instruction_id IN (SELECT payment_instruction_id
FROM ap_checks_all aca
WHERE aca.check_number = <Paymentnumber>)
AND itd.doctype = 101 —code for formatted xml