My Oracle Support Banner

Unable To Create Interactive Grid Report After Upgrading To APEX 23.1 (Doc ID 2953975.1)

Last updated on JUNE 26, 2023

Applies to:

APEX Application Development - Version NA and later
Oracle Application Express (APEX) - Version 22.2 and later
Information in this document applies to any platform.

Symptoms

Apex has been upgraded to 23.1, but cannot create Interactive Grids, either as a new region or using a new page wizard.
Hitting with the below error
• Error: ORA-1400: cannot insert NULL into ("APEX_230100"."WWV_FLOW_IG_REPORTS"."ID")

Error Stack: ORA-1400: cannot insert NULL into
@ ("APEX_230100"."WWV_FLOW_IG_REPORTS"."ID")
@ ORA-6512: at "APEX_230100.WWV_FLOW_INTERACTIVE_GRIDS_T2", line 6
@ ORA-4088: error during execution of trigger
@ 'APEX_230100.WWV_FLOW_INTERACTIVE_GRIDS_T2'
@ ORA-6512: at "SYS.DBMS_SQL", line 1721
@ ORA-6512: at "APEX_230100.WWV_META_META_DATA", line 2639

 

Changes

 Upgraded to APEX 23.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.