topic Re: Error while using BAPI_USER_ACTGROUPS_ASSIGN in Application Development and Automation Discussions

Error while using BAPI_USER_ACTGROUPS_ASSIGN

Former Member — Thu, 04 Oct 2012 05:04:09 GMT

HI Experts,

In OIM (oracle identity manager) , when we are creating the users in Oracle and assigning 4 roles to the users (For assigning roles to the users we are using BAPI_USER_ACTGROUPS_ASSIGN bapi ) , we are getting the below error ,

Caused by: RfcException: [PRO|amendoim]
message: The ABAP/4 Open SQL array insert results in duplicate database
records. records in the data base.
Return code: RFC_SYS_EXCEPTION(3)
error group: 104
key: RFC_ERROR_SYSTEM_FAILURE
message class: 00
message type: X
message number: 341
message parameter 0: SAPSQL_ARRAY_INSERT_DUPREC

But when we created users and assigning 1 role at a time . we are not gettign any error . So what could be the problem for this issue.

Kindly suggest some ideas to resolve .

Regards,

Saravana.S

Re: Error while using BAPI_USER_ACTGROUPS_ASSIGN

former_member286481 — Thu, 04 Oct 2012 05:37:04 GMT

Hello Saravana,

Try using the FM 'PRGN_USER_ASSIGNMENT_CHANGE' For assigning roles to the users.

Thanks,

Karthik

Re: Error while using BAPI_USER_ACTGROUPS_ASSIGN

Former Member — Thu, 04 Oct 2012 05:41:27 GMT

Hi Karthi ,

Thanks for the reply . we want to use same BAPI for assigning roles... we just wanted to know how to solve this issue.. By adding any code/parameter or any SAP notes available .

Note: system is ECC 6.0

Regards ,

Saravana.S

Re: Error while using BAPI_USER_ACTGROUPS_ASSIGN

sandeep_katoch — Thu, 04 Oct 2012 07:24:33 GMT

Hi Saravana,

The problems seems like there is duplicate entries when you are creating multiple roles.

Actually when you are passing 4 roles then it is giving this error because an entry already exists but in case of single roles as far as I know the functionality of this BAPI it deletes the roles which are not a part of activitygroups table. So when you are doing it by passing single role at a time the next time the previous role which was assigned is deleted and new one is created that is why not giving the duplicate entry error.

may be you can check once again all the four roles.