My Oracle Support Banner

Importing an Application gets ORA-01400: cannot insert NULL into apex_schema.WWV_FLOW_ACL_GROUP_USERS.GROUP_ID (Doc ID 2580664.1)

Last updated on FEBRUARY 10, 2023

Applies to:

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

Symptoms

APEX 18.1

When attempting to import second time an application
the following error occurs.




The issue can be reproduced at will with the following steps:
1. Import the application first time and works fine.
2. Update the application assigning roles to uses.
3. Import the application again to replace the old one.


Changes

 Assign Roles to the Application Users

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.