We exported our workspace and try to import into a fresh 18.2 installation (with brand new 18xe) to test.
we get below error when we import in the new machine:
Execution of the statement was unsuccessful.
ORA-02291: integrity constraint (APEX_180200.WWV_FLOW_FND_GU_INT_G_FK) violated - parent key not found
begin wwv_flow_fnd_user_api.create_fnd_user ( p_user_id => '174201418577858152',
p_user_name => 'john',
p_first_name => 'john',
p_last_name => '',
p_description => '',
p_email_address => 'info-IT@ourbiz.com',
p_web_password => '45EB6D1AE6E4A11A544016DC3E78B970AADE1025',
p_web_password_format => '5;2;10000',
p_group_ids => '1825740968196605:1825836228196606:1825968924196606:',
p_developer_privs => 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
p_default_schema => 'INMYDB', p_account_locked => 'N',
p_account_expiry => to_date('201711041803','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;
Contact your application administrator.
Any ideas? by searching in Google we found this was an Apex 4.2 issue with a fix in Oracle Support, but now we are talking Apex 18.2 !