How the data is populated on the WF_Local_Roles table?
We are updated the email addresses in FND_USER, HZ_PARTIES and PER_PEOPLE_V7 tables. However, I think the workflow is picking up the data from the WF_ROLES view or WF_LOCAL_ROLES table Oracle EBS R12.2.10.
Workflow tables still have showing old email address as their email address instead of new email ids. I couldn't find out how the data is populated in the workflow tables.
Can anyone know how the data is populated on the WF_Local_Roles table then we can update it accordingly at the source.
Thanks