ORA-20002: [WF_NO_ROLE] NAME=FND_RESP|ICX|XXICX_SSP_IPROC|82 ORIG_SYSTEM=FND_RESP ORIG_SYSTEM_ID=51285 has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

Issue: Trying to assign a responsibility to a user using "fnd_user_pkg.addresp" or from "Users" Screen in "System Administrator" responsibility and you receive the error below:

"ORA-20002: [WF_NO_ROLE] NAME=FND_RESP|ICX|XXICX_SSP_IPROC|82 ORIG_SYSTEM=FND_RESP ORIG_SYSTEM_ID=51285 has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT"


As its shown; this is the custom exception raised by Oracle API.

Let see how to get it resolve:

1) Submit Program "Workflow Directory Services User/Role Validation" with parameters like

"100000, USERNAME, , Y, Y, N, "

• Parameters
  • Batch Size: Number of records that will be processed per commit cycle
  • Fix dangling user/roles: Removes any user/roles where the user and/or the role does not exist in WF_LOCAL_ROLES
  • Add missing user/role assignments: Adds any user/roles that are present in WF_LOCAL_USER_ROLES but missing in WF_USER_ROLE_ASSIGNMENTS
  • Update WHO columns in WF tables: Controls the updating of who columns when corrupt records are corrected

2) Set the Enable Security Groups profile option to Yes at application level for the application relevant to the responsibility

3) Submit Program "CREATE FND_RESP WF ROLES"

Hope it helps !!