When editing an object, the following error may occur:
ORA-20025: No role access to " role OPS_NO_EDIT in get_role_seq_aw when add_obj_roles
Investigation:
User Group(s) are assigned to a User, and define what a User can view or edit. This error can be seen by User "John", in the following configuration:
User John has User Group A assigned to the user
The object throwing the "No role access" error is owned by User Group A and User Group B
User Group B is not assigned to User Group A
Behavior is as designed and is caused by the way that the groups are assigned.
User Group A requires indirect access to User Group B.
This can be done by editing User Group A and assigning User Group B to User Group A.