Here is the sample code to send emails conditionally from BI/XML Publisher bursting feature.
Problem Statement:
Generate payslips for all the employees at one shot and email the payslips to respective employee.
1. Alter EMP table and added a column called email to hold emails of each individual employees.
And then update email column to add email Ids where you want your emails to be delivered.
2. Create a Data template Sample code available here
3. Default package Sample code available here
4.Define a concurrent program and assign the concurrent program to a responsibility as per your convenience.
5. Design a simple RTF template and register the same. Sample template available here
6. Register data template, created in #1 above
7. Register control file for bursting. Sample code available here
Package Sample code here.
8. Submit the concurrent program defined in #4. If everything goes fine,
you should be able to see emails delivered at the email ids provided.
Sample Data in XML format.
9. Sample output below..
