Notifications using a Workflow
When a new record is inserted into a custom table, based on ceertain conditions the requirement is:-
to have a custom workflow send an Oracle Notification, as well as an Email to the address attached to a user, based on certain conditions.
however, we seem to be able to implement only either of these conditions:-
1.An email is sent, if the email address is set against the user id, in the wf_local_roles table.
2.Oracle notification is sent, only when the email id is absent in wf_local_roles table.
Any ideas on how I can have both 1 and 2 working?