Fnd_cant_insert_user_role when assigning a responsibility in R12

Whenever assign user responsibilities, next time user responsibilities are queried they are no longer in the form (FNDSCAUS) they are not visible.

A second attempt to assign the same responsibility produces the error
Oracle Error -20001: ORA-20001: FND_CANT_INSERT_USER_ROLE has been detected in 
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

The cause of the issue is that there are no subscribers defined for AQ WF_BPEL_Q

Solution
1. Drop / recreate the subscriber as follows:

declare
lagent sys.aq$_agent;
subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);
begin
lagent := sys.aq$_agent('WF_BPEL_Q',null,0);
dbms_aqadm.add_subscriber(queue_name
=>APPS.WF_BPEL_Q',subscriber=>lagent,rule=>'1=1');
exception
when subscriber_exist then
-- just add the rule if subscriber exists
dbms_aqadm.alter_subscriber(queue_name =>'APPS.WF_BPEL_Q',
subscriber=>lagent,
rule=>'1=1');
end;
/

2. Run the concurrent request Workflow Directory Services User/Role Validation.

1.1 "Workflow Directory Services User/Role Validation" Parameters : 100000, Yes, No, No"
1.2 "Workflow Directory Services User/Role Validation" Parameters : 100000, No, Yes, No"

3. Bounce Apache

Also read Note:549040.1 - How Standard Business Events Work With WF_BPEL_Q?

Cheers!!!

Related Posts by Categories