Problem when migrating Apex REST to ORDS REST

I'd start with the roles you already have defined on the ords side

select * from ORDS_METADATA.SEC_ROLES

then compare those names to the roles you have defined in APEX - if you see ones with the same name, they can't both exist in the ORDS repo. So you'd have to rename one or the other before migrating.

You shouldn't have anything in your ORDS repo if you're just now migrating, so i'm wondering if apex allows you to have duplicates by role name?

What you're seeing in the ords side are ords system generated roles

I'm digging to find out how you can find those on the APEX side, stay tuned

please run this query and report back

select group_name

from apex...wwv_flow_instance_rest_admin

order by 1 asc;

do you see anything listed more than once?

so sorry, it's

WWV_FLOW_FND_USER_GROUPS

so

select GROUP_NAME

from  WWV_FLOW_FND_USER_GROUPS

what version of APEX did you upgrade from?