My Oracle Support Banner

APEX Upgrade To 22.1 From 18.2 Failed With Error ORA-02298 Error (Doc ID 2905103.1)

Last updated on OCTOBER 25, 2022

Applies to:

Oracle Application Express (APEX) - Version 22.1 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : APEX 22.1 version, Administration

When attempting to upgrade from APEX 18.X
the following error occurs at phase 3

ERROR
-----------------------
ORA-02298: cannot validate (APEX_220100.WWV_FLOW_FND_GU_INT_G_FK) - par
ent keys not found
# Statement: alter table "APEX_220100"."WWV_FLOW_FND_GROUP_USERS" enable constra
int "SYS_C0030140" enable constraint "SYS_C0030141" enable constraint "SYS_C0030
142" enable constraint "WWV_FLOW_FND_GU_INT_G_FK" enable constraint "WWV_FLOW_FN
D_GU_INT_U_FK"
# Backtrace: ORA-06512: at "APEX_220100.WWV_FLOW_UPGRADE", line 204


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade APEX 18.X to 22.1
2. Phase 3 gives above error in the install<date>.log



Changes

 Upgrading in-place

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
References


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