How to fix wf_local_roles?
Hello,
We have an issue where, the OTL workflow was completing correctly, but for a particular approver, it was not recording his approver id. So I did some tracing, and found the workflow package was finding a workflow role of "WF_LOCAL_USERS" for this user, instead of "PER".
I did some research, and found the following query:
select orig_system,notification_preference,email_address
from wf_local_roles
where name=<username>;
For most users, they have a PER record. For this user, he has two records, as shown below (I am removing the email_address column):
ORIG_SYSTEM NOTIFICATION_PREFERENCE