Error while using BAPI_USER_ACTGROUPS_ASSIGN

[Former Member]

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

[former_member286481]

Hello Saravana,

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

Thanks,

Karthik

[Former Member]

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

[sandeep_katoch]

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.