Wednesday 14 July 2010

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!!!

SocialTwist Tell-a-Friend

Related Posts by Categories



3 comments:

Unknown said...

Hi Ajikumar,
Appreciate your help in sending me the steps to upgrade R12.1.1 to R12.1.2 on windows 32bit.

FYI...
Installation of R12.1.1 on windows32 has been completed succesfully.We are stucked while upgradation.

Thanks for your help in advance.

Regards,
Kashyap Varma N
nkashyapvarma@yahoo.com
varma.kashyap@gmail.com

Anonymous said...

Dear Mr. Ajikumar,

Good day. I am sending this post from UAE and need your help in tuning our Oracle 10g database server. Please let me know your contact details so that we can talk further.

Best Regards

V. Upendra Rao
Mobile : 055 3153590

Ajikumar G said...

Hi Upendra,

You can reach me ajikumarg@gmail.com

Thanks
Ajikumar G