How to Correct Workflow Error, 'X' Is Not A Valid Role Or User Name

纵横四海

GoalHow to correct the workflow error 'X' Is Not A Valid Role Or User Name where 'X' represents the username that will be shown in during this error message.
SolutionTo implement the solution, please take the following steps:

     1.  Verify the username 'X' is a valid username
          You may run the following SQL statement.
               SELECT *
               FROM fnd_user
               WHERE upper(user_name) = upper('&username');

     2.  Verify that the employee (Person) associated to that username is also valid.

     3.  Verify that the resource associated to the employee/username is valid.

    4. Verify that the user is in WF_USERS.
         You may run the following SQL statement.
         SELECT *
         FROM wf_users
         WHERE upper(name) = upper('&username');


    5. Verify that the user has a valid role in WF_ROLES:
        You may run the following SQL statement.
            SELECT name, display_name, orig_system
            FROM wf_roles
            WHERE upper(name) = upper('&username');

   6. Take the following actions:
       6a. Responsibility = System Administrator
           Navigate: Security > User > Define
       6b. Using View/Find on the menu, query up 'X'.
       6c. Remove the value from the Person field.
       6d. Save the record.
       6e. Use the flashlight to requery 'X'
       6f. Replace the value in the Person field.
       6g. Save.