APEX Upgrade To 22.1 From 18.2 Failed With Error ORA-02298 Error
(Doc ID 2905103.1)
Last updated on MAY 31, 2024
Applies to:
Oracle Application Express (APEX) - Version 22.1 and laterOracle 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 |