Thursday, August 12, 2010

ORA-20001:FND_CANT_INSERT_USER_ROLE when attaching responsibility to User

Yesterday we had a issue with one user saying after he logs into applications no responsibility displayed.When we did a search for that user on the forms ,surprisingly
there was no responsibilities attached to that user.

We tried to attach responsibility and save it ,but it will not save and came back with the below message

"ORA-20001:FND_CANT_INSERT_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT"

Later we ran concurrent program "Workflow Directory Services User/Role Validation" .Request completed normal and this time the responsibility was visible on the forms when we queried that user.But when the user tried to login no responsibilities still.

We fixed this issue by end-dating the responsibility assigned to the user and saved.Then removed the end date for the responsibility and saved.

Now requested the user to test and he can see the responsibility now and work without any issues.
Posted by at
Labels: ,

2 comments:

  1. Sasikumar MaruthachalamAugust 15, 2010 at 6:40 AM

    This comment has been removed by the author.

    ReplyDelete
  2. Sasikumar MaruthachalamAugust 15, 2010 at 6:40 AM

    Good note, We can also use the following APIs to resolve this kind of issues,

    exec apps.fnd_user_pkg.disableuser('Username');
    commit;

    exec apps.fnd_user_pkg.enableuser('Username');
    commit;

    - Sasikumar.M

    ReplyDelete

Subscribe to: Post Comments (Atom)