Unkown error when trying to delete record on the sys_user_grmember table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 05:53 AM
I am currently having issues with adding / removing users from one of our groups.
We have a scoped app made for HR and not the HR module.
We have a flow that triggers when a user becomes inactive. so it looks up the record in the sys_user_grmember table and for each record we want it to delete the record.
This flow works for global and our other Owner Support scoped app groups but not for HR
There is no business rules in place and I have checked all the ACL's and they look fine
I have also looked at the cross scope privileges and they match the other scoped app so I am really not sure now why it will not delete the record
If i go directly into the table i can add and remove manually no issues just the flows cannot.
I have attached screenshots of the error log and the error in the flow executions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:21 AM
I don't see any attached screenshots. May be able to help troubleshoot if you can provide those.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:23 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:26 AM
This KB article should help you as it is what seems to be happening.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 06:29 AM
I have tried to follow this and added an action in with the condition of inherited=false and it doesn't find any records as all users are given roles based off the group they are in so no non-inherited roles exist against the user.