ORA-02291: Integrity Constraint-Parent Key Not Found (WWV_FLOW_FND_GU_INT_G_FK) - When Importing A Workspace In APEX - ORDS(with Weblogic)
(Doc ID 1992236.1)
Last updated on SEPTEMBER 26, 2018
Applies to:Oracle Application Express (APEX) - Version 4.2.1.00.08 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Steps to reproduce:
1) In APEX Instance #1 (that uses APEX Listener), create a developer account
and assign it to one (or all) of the pre-created user groups: RESTful
Services, SQL Developer, OAuth2 Client Developer.
2) Export this workspace.
3) In APEX Instance #2, log in as instance administrator and open Manage
Workspaces / Import Workspace page.
4) Upload the export file from Step 2 and complete the import wizard - the
following error is displayed:
Execution of the statement was unsuccessful. ORA-02291: integrity constraint
(APEX_040200.WWV_FLOW_FND_GU_INT_G_FK) violated - parent key not found
This error occurs because pre-created user groups (SQL Developer, etc) do not
have the same IDs in two APEX instances.
ORA-02291: integrity constraint (APEX_040200.WWV_FLOW_FND_USER_GRPS_FK) violated - parent key not found when importing a workspace into a newly reinstalled instance
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document