My Oracle Support Banner

ORA-00942 "APEX_190100"."WWV_FLOW_BLUEPRINT_REPO" Upgrading To APEX 19.X (Doc ID 2553104.1)

Last updated on FEBRUARY 18, 2021

Applies to:

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

Symptoms


When trying to upgrade from APEX 18.x to APEX 19.x, the following errors occur:

Error log :
...

# Upgrade Metadata (1)
#
# Error: ORA-00942: table or view does not exist
# Statement: insert /*+append*/ into "APEX_190100"."WWV_FLOW_BLUEPRINT_REPO"

...
  # Message: ORA-06550: line 6, column 17:
  # PLS-00201: identifier 'WWV_FLOW_AUTHENTICATION_DEV.INTERNAL_MAKE_CURRENT'
must be declared
  # ORA-06550: line 6, column 17:
  # PL/SQL: Statement ignored
  # Statement:
  # declare
  # l_old_sgid number := wwv_flow_security.g_security_group_id
;
  # begin
  # wwv_flow_security.g_security_group_id := 10;
  # wwv_flow_authentication_dev.internal_make_current (
  # p_scheme_identifier => 'APEX' );
  # wwv_flow_security.g_security_group_id := l_old_sgid;
  # end;
  ok 351 - Enabling WS Constraints | 0.00
  ok 352 - Dropping Upgrade Triggers in APEX_180200 | 0.02
not ok 2 - 337 actions passed, 15 actions failed | 1.35
begin
*

ERROR at line 1:
ORA-20001: Install errors found in phase 2
ORA-06512: at "APEX_190100.WWV_INSTALL_API", line 440
ORA-06512: at line 8

Changes

 Upgrade to latest APEX available.

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.