How to send Payslip attachments to 5000 employees using Bursting concept? SELECT papf.person_number AS "KEY", papf.person_number AS "DELIVERY_KEY", 'burst_1000rec' AS TEMPLATE, 'en-US' AS LOCALE, 'PDF' AS OUTPUT_FORMAT, 'EMAIL' AS DEL_CHANNEL, (SELECT pea.email_address FROM per_email_addresses pea WHERE pea.person_id = papf.person_id AND pea.email_type = 'W1') AS PARAMETER1, NULL AS PARAMETER2, 'bipublisher-report@oracle.com' AS PARAMETER3, 'Your Custom Report' AS PARAMETER4, 'Hello, Please find your Payslip report attached.' AS PARAMETER5, 'true' AS PARAMETER6, 'donotreply@oracle.com' AS PARAMETER7 FROM per_all_people_f papf WHERE trunc(sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date AND ROWNUM <=5000...
Posts
Showing posts with the label Reports