My Oracle Support Banner

APEX Upgrade Fails with ORA-02298: cannot validate (APEX_210100.WWV_FLOW_DATA_SESSION_FK (Doc ID 2788271.1)

Last updated on JULY 20, 2023

Applies to:

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

Symptoms

On : APEX 18+, On-prem and Cloud (DBCS)

When attempting to upgrade APEX
the following error occurs.

ERROR
-----------------------

  not ok 64 - Enabling Constraints and Triggers | 0.02
  # Message: ORA-02298: cannot validate (APEX_210100.WWV_FLOW_DATA_SESSION_FK)
 - parent keys not found
  # Statement: alter table "APEX_210100"."WWV_FLOW_DATA" enable all triggers e
nable constraint "VALID_ITEM_FILTER" enable constraint "VALID_SESSION_STATE_STAT
US" enable constraint "WWV_FLOW_DATA_SESSION_FK"
  ok 65 - Creating Public Synonyms | 0.03


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade APEX (running the apexins script over an existent APEX instance of lower version)



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
References


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