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 19.1.0.00.15 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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

ERROR
-----------------------
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.


STEPS
-----------------------
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".

Changes

 Upgrading to APEX 19.1

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.