I have an 18.1 installation (upgraded from 4.2) running on an 11g database.
I have a second 18.1 installation on a 12.2 database.
I exported a workspace from the 11g database using the APEX administration tool.
When I try to import into the 12.2 database I get the following error:
Execution of the statement was unsuccessful. ORA-02291: integrity constraint (APEX_180100.WWV_FLOW_FND_GU_INT_G_FK) violated - parent key not found
begin wwv_flow_fnd_user_api.create_fnd_user (
p_user_id => '1296001321801907',
p_user_name => 'ANDY',
p_first_name => 'Andy',
p_last_name => 'Hardy',
p_description => '',
p_email_address => 'email@example.com',
p_web_password => '0FDFDFD740282741266104E5244EB9A8',
p_web_password_format => '3;1;',
p_group_ids => '1760312063204924:1760422769204936:1760545087204937:',
p_developer_privs => 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
p_default_schema => 'SCOUTS',
p_account_locked => 'N',
p_account_expiry => to_date('201007040000','YYYYMMDDHH24MI'),
p_failed_access_attempts => 0,
p_change_password_on_first_use => 'N',
p_first_password_use_occurred => 'N',
p_allow_app_building_yn => 'Y',
p_allow_sql_workshop_yn => 'Y',
p_allow_websheet_dev_yn => 'Y',
p_allow_team_development_yn => 'Y',
p_allow_access_to_schemas => ''); end;
From the constraint name I assume that the issue is related to the group ids for the user? On the source instance this user is associated with the 'usual' built-in groups e.g. Oauth, SQL Developer, etc.
Any ideas on how to complete the import?