We have an issue in a database where APEX has been freshly installed.
We've taken the workspace exported from our current environment, expecting it to install no problems, but we encounter the following error
group does not exist but should be in internal workspace
This occurs when the script attempts to create the standard groups, of which I'm having trouble locating decent detail on their definition.
----------------
-- G R O U P S
--
prompt Creating Groups...
begin
wwv_flow_api.create_user_groups (
p_id => 1814419965114954,
p_GROUP_NAME => 'OAuth2 Client Developer',
p_SECURITY_GROUP_ID => 10,
p_GROUP_DESC => 'Users authorized to register OAuth2 Client Applications');
end;
/
There seems to be a chicken before the egg issue in that it appears to be checking for existence in the WWV_FLOW_FND_USER_GROUPS table before creating a record in that table.
There are only the three rows in our existing, 1 workspace environment ('OAuth2 Client Developer', 'RESTful Services', 'SQL Developer'). And no records in our new database (hence the error).
This is in a new APEX 20.2 environment, though the initial workspace export was produced when our current environment was 5.1.4.
The same result happens with a fresh export.
What would be the impact of creating the workspace with APEX_INSTANCE_ADMIN.ADD_WORKSPACE, and not having these groups present? I'm not convinced they've been actively used at this stage.
Scott