3 Replies Latest reply: Aug 23, 2012 8:21 AM by Alejandro Sosa-Oracle RSS

    How to get role of a customer using party_id

      Hi All, I have to send notifications in a for loop of my plsql block and would be using wf_notification.send
      I need to fetch role of my customer, i have party_ids and need to send notifactions to all those customers to their party level email ids

      I created a customer with email address, but i could not find any record of role into wf_roles, wf_local_roles or wf_local_user_roles

      Can any one please let me know how can i get the role to pass parameter to wf_notification.send

      Thanks in advance.