My Oracle Support Banner

Missing Region Sources After Copy/export when Region Source is Table/View (Doc ID 2765284.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

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

Symptoms

On : 20.2 version, Administration

Missing region sources after copy/export

After copying an application or exporting/importing an application all region sources of chart regions are missing and so the application is not usable at all because all series with Source-Location=Region Source are invalid.
All other Chart regions where the series have Source-Location=Local Database and SQL Query are ok.

After starting the copy and import of an application one gets the message:

Ajax call returned server error ORA-06592: CASE not found while executing CASE statement for .

The source region is only missing if it is declared with "Location=Local Database Type=Table / View Table Owner=Parsing Schema Table Name=nnn"

If the source region is declared as SqlQuery then the copy or imported application has no missing source.

Issue replicates on APEX 20.2 with 20.2 patch set applied on apex.oracle.com

ERROR
-----------------------
ORA-06592: CASE not found while executing CASE statement for .




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create application and set Source-Location=Region Source to Local Database->Table/View
2. Either export/import the application or Copy the application
3. Observe the region source is not kept and one must select anew.


Changes

 Upgrade to APEX 20.2

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.