Wednesday, December 17, 2014

ORA-20002: [WF_NO_USER] NAME=XXXXX ORIG_SYSTEM=NULL ORIG_SYSTEM_ID=NULL has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

I got the above error when trying to add responsibility to a FND User.

There is no any specific reason for this,

As suggested by Corvin below, do the dummy update to the 'person' field

Login to the application and query the user
Clear the 'person' field and save, re-enter the the person field and save

Try adding responsibility.

If above steps does not resolve the issue please perform below steps

1>  Run the program "Synchronize WF LOCAL tables"
      
       Parameters:
       Orig System: ALL / Specific System (Ex: FND_USER)
        Parallel Processes : Number of parallel processes
        Logging Mode:
        Temporary Tablespace:
        Raise Errors:

> Only "Orig System" is a mandatory parameter

Alternatively you can execute below script

BEGIN
  WF_LOCAL_SYNCH.BulkSynchronization('ALL');
EXCEPTION
   WHEN OTHERS THEN
      DBMS_OUTPUT.PUT_LINE('ERROR: '||SQLERRM); 
END;

>> Check if the issue resolved, if not follow to step 2

2> Run the program "Workflow Directory Services User/Role Validation"
     > Change parameters 'Fix dangling users'                                -> Yes
                                             'Add missing user/role assignments' -> Yes
     > Leave other parameters with default values
     > If you want to run for a specific User/Role, please provide the related parameter value

> I hope this will resolve the issue.

10 comments:

  1. Nope.. this did not resolve the issue. I got the same error.. thankyou for sharing the fix though.. i am trying other options.

    ReplyDelete
    Replies
    1. Sorry about that, please let me know your exact issue and solution if found.

      Delete
    2. If you remove the data in the person field, save, then re-attach the person record and then add the responsibility, it works.

      Delete
    3. Here are the steps to add the responsibility:

      Logon to Oracle Applications
      query user in form
      clear the person field
      save
      re-enter person field
      add responsibility
      save

      Delete
    4. Thanks Corvin, have added your steps.

      Delete
  2. thanks Covin, your action plan worked for me

    Logon to Oracle Applications
    query user in form
    clear the person field
    save
    re-enter person field
    add responsibility

    ReplyDelete