Bursting to dynamically derived email addresses in 12.1.3
I have a concurrent request(Oracle Report) that pulls employees and their email addresses. I have a template and data definition associated with it. How should I go about trying to burst emails to the employees returned by the report? Should I use a "bursting control file" attached to the data definition or the Delivery Options associated with the concurrent request?
And adding this piece of code to the AfterReport trigger in the Oracle Report.
n_request_id := fnd_request.submit_request('XDO'
,'XDOBURSTREP'
,NULL
,NULL
,FALSE
,p_request_id
,'Y'
);