Email Concurrent program output to user in Oracle Apps

Very often you get requirement from the client to email the output of a report to the users. So here is a sample way by which you can generate the report output and email the same to the user.

 

Following are the setups involved:

1.    Create a Request set with two concurrent programs

a.    First concurrent program is developed based on the customer requirement to generate the report output.

b.    Second concurrent program gathers the output details into a custom table.

2.    Create an Alert on the custom table to send the output of the Request set’s first concurrent program to the users.