My Oracle Support Banner

ORA-38824 error and APEX Component Invalid After Upgrading Database to 12.2.0.1.0 (Doc ID 2498410.1)

Last updated on JULY 14, 2023

Applies to:

Oracle Application Express (APEX) - Version 18.2.0.00 and later
Information in this document applies to any platform.
***   ****
Reviewed for currency on 14-Jul-2023

Symptoms

After upgrading a database, when utlrp runs and sys.validate_apex is being executed, the following error message can be thrown and APEX is recorded as INVALID in DBA_REGISTRY:

Function dropped.

...(11:18:18) Starting validate_apex for APEX_180200
...(11:18:22) Checking missing sys privileges
...(11:18:22) Re-generating APEX_180200.wwv_flow_db_version
ORA-20001: ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.
...(11:18:22) Key object existence check
...(11:18:24) Setting DBMS registry for APEX to INVALID
...(11:18:24) Exiting validate_apex

PL/SQL procedure successfully completed.



Changes

 Upgraded Database to 12.2.X

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.