Update wf_notifications.recipient_role after fnd_user.user_name change? Is there a way to avoid doi
We are about to update all fnd_user usernames.
The table wf_notifications stores the user_name and unless they are updated to the new value, the WF will error.
Is there a way to do this other than:
1 Rewinding the workflow
2 Withdrawing the transaction (if OIE) and resubmitting.
3 Manually updating the WF attributes for each open WF
Does "Synchronize WF LOCAL tables" do this?
Appreciate some practical advice.
Mike