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
order by 1 asc;
do you see anything listed more than once?
Sorry there is no such view or table in my DB.
Apex version : 20.1
Oracle version : 22.214.171.124.0
so sorry, it's
what version of APEX did you upgrade from?
There are many duplicates in this query, because this is application roles.
But there are 3 of them, which don't belong to any application and have same name with ORDS roles above:
OAuth2 Client Developer
I upgraded from Apex 18.2, 19.2 then 20.1