Application: EBS R12.x + GRC AppsFlow 7.x
Without our EBS, I am using GRC AppsFlow to create workflow such as "Capital Approval Request". I am creating an APEX front-end application to allow user to submit capital approval request. Upon submission, the workflow ""Capital Approval Request" created by GRC AppsFlow is triggered.
Within this workflow, we are sending approval email to a given GRC workflow role/group (which contains multiple users) and users will act upon such workflow notification email once they receive it. Sometimes, users are forgetting reacting on the approval notification and delay the approval process. Also may accidently deleted the approval notification email they have received in the email client application (e.g. MS Outlook). Thus, we need a way to resend a given approval notification to the GRC appsflow workflow group (which contains multiple users).
in my APEX application, for a given notification id, I can click a "Send Again" button to resend the same workflow notification id to a given GRC workflow role/group, behind the button, it is calling EBS workflow API, apps.wf_notification.resend(p_nid => 123456) to send the notification.
This is all working in our EBS R12.1.3 (which includes GRC AppsFlow 7.3). Then we upgraded to EBS R12.2. After upgrade, when I click "Send Again" button, it doesn't send email anymore.
I have opened an Oracle SR, but didn't get too much support given this is a customization involved in my case.
Thus, I'd like to ask this question here. I hope some GRC Appsflow developer/expert can help me on this question:
"in EBS R12.2, what code is needed to resend a workflow notification id. Here notification id's recipient is a GRC Appsflow role/group (a row in apps.wf_local_roles) , not a workflow role (apps.wf_roles).
Thanks!
Kevin Zhang