You may get the following bizarre error message when invoking the Oracle Application Express API procedure: APEX_UTIL.CREATE_USER
ORA-02291: integrity constraint (FLOWS_030100.WWV_FLOW_FND_GU_INT_U_FK) violatedFor instance, suppose you have a registration page where the user can enter his/her data and the apex user is created with an after submit process as follows:
- parent key not found
Error ORA-02291 that we've got is caused by a combination of factors:
p_user_name => :P12_USER_NAME
,p_first_name => :P12_NAME
,p_last_name => :P12_SURNAME
,p_email_address => :P12_EMAIL
,p_web_password => :P12_PASSWORD
,p_group_ids => apex_util.get_group_id('web_users')
- the value returned by the expression apex_util.get_group_id('web_users') must be not null
- the user name must be already existing
This behavior has been seen on Apex 3.1.2.
See message translations for ORA-02291 and search additional resources or read more Oracle Apex related articles.