Trigger Email Alert Options
We have a customization in one of the Souring page to have integration with external suppliers accessing payment gateway.
When the user or supplier submits the page and process is successful, the supplier should receive a custom report.
What is the best approach to execute an email with attachment to the suppliers? Use a database trigger on a custom table or use/leverage Oracle EBS Alert mechanism?
Appreciate any insight or help.