Core Workflow - EBS (MOSC)

MOSC Banner

How to fix wf_local_roles?

edited Sep 23, 2015 1:31AM in Core Workflow - EBS (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center