Avoid running XML Publisher Report Bursting Program to send Report emails

Avoid running XML Publisher Report Bursting Program to send Report emails

Business Need:

Define a simple process to send the emails without running XML Publisher Report Bursting Program seperately providing the request ID of the XML report generated before.

Resolution:

1. Enable Concurrent: Business Intelligence Integration Enable = Y

2. Create the XML report "XXXX" as required

3. Enable the business event Program Completed at the concurrent program definition "XXXX"

4. Write a Business Event subscription for the Business Event oracle.apps.fnd.concurrent.program.completed utilizing UTL_SMTP standard package. This will make sure the Output Post Processor has completed all the necessary formatting etc and the output is placed in the o/p directory.