Hello Community,
I have an Oracle BI Publisher report that fetches payment file outputs from iby_trxn_documents and bursts the output to an email address provided at runtime via a parameter (P_EMAIL).
The report works correctly; however, we are receiving a separate email for each payment file selected. We would like to receive a single email with all selected payment files attached.
Current Bursting Query:
SELECT payment_instruction_id AS "KEY",
'payment xsl template.xsl' AS TEMPLATE,
'en' AS LOCALE,
'txml' AS OUTPUT_FORMAT,
'EMAIL' AS DEL_CHANNEL,
'PaymentFile_' || payment_instruction_id AS OUTPUT_NAME,
:P_EMAIL AS PARAMETER1,
'no-reply@oracle.com' AS PARAMETER3,
'Payment Files' AS PARAMETER4,
'Please find attached your payment document.' AS PARAMETER5
FROM iby_trxn_documents
WHERE 1=1
AND payment_instruction_id IN (:P_PAY_REF_NUM)
AND DOCTYPE = 101
