My Oracle Support Banner

ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects, Upgrading APEX 19.1 from 5.1 on a 12.2 DB (Doc ID 2532498.1)

Last updated on OCTOBER 02, 2023

Applies to:

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


On : APEX version,
When attempting to upgrade APEX from 5.1 to 19.1 on a 12.2 DB
the following error occurs.

create or replace trigger FLOWS_FILES.wwv_biu_flow_file_objects
ERROR at line 1:
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property
of an existing object.

The issue can be reproduced at will with the following steps:
1. Upgrade a Healthy APEX 5.1.1 on a 12.2 DB to APEX19.1
2. The install fail and left APEX invalid in dba_registry

When running in this environment, the customer may notice that they are not able to import a plug-in export.

1. Select the file for import.
2. Click next. The file appears to be selected, however the user sees a failure "File must be selected to upload".


 Upgrading to APEX 19.1


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

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