My Oracle Support Banner

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.

Symptoms

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.

Error :

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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.