ORA-02291 while attempting to install workspace export from version 4.0
flaviocOct 16 2012 — edited Oct 19 2012Anyone experiencing problems when installing workspace exports containing user groups in Apex 4.2?
When I try to install a workspace dumped from Apex 4.0, I am getting the following blocking error:
Execution of the statement was unsuccessful. ORA-02291: integrity constraint (APEX_040200.WWV_FLOW_FND_USER_GRPS_FK) violated - parent key not found
begin
wwv_flow_fnd_user_api.create_user_group (
p_id => 117697823207460082,
p_GROUP_NAME => 'MASTER',
p_SECURITY_GROUP_ID => 101624224619521722,
p_GROUP_DESC => '');
end;
ORA-02291: integrity constraint (APEX_040200.WWV_FLOW_FND_USER_GRPS_FK) violated - parent key not found
I checked the docs and I couldn't find any reference to known problem with the importing of a workspace containing user groups.
Thanks
Flavio
----
http://oraclequirks.blogspot.com
http://www.yocoya.com