i can get the username of the person who approves the transaction using wf_engine.context_user. But how to get his email??
Basically i want to create a role for a group of people who approve the transaction.
WF_ENGINE.context_user will provide you with the username or email address (if the notification was responded to via email).
Use the user name to find the email address from the WF_USERS table.
WorkflowFAQ.com - the ONLY independent resource for Oracle Workflow development
Alpha review chapters from my book "Developing With Oracle Workflow" are available via my website http://www.workflowfaq.com
Have you read the blog at http://www.workflowfaq.com/blog ?
WorkflowFAQ support forum: http://forum.workflowfaq.com
are you sure the code in the post-notification function is kicked off? See if you are running it in a mode (parameter funcmode) that is not right. Also, once you get the name of the user you can get its e-mail address by using wf_directory.getRoleInfo.