My Oracle Support Banner

Column Attribute is not restored after recreating a column of Interactive Report (Doc ID 2195656.1)

Last updated on FEBRUARY 18, 2021

Applies to:

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

Symptoms

SQL Query in region source can be modified with using Page Designer or Component View so as to add or delete a specific column from Interactive Report.

Once a column is deleted, column attributes will not be restored even after adding the same column to the region source again.

For example,

You have created a interactive report with following SQL Query:

"Column Alignment" of ENAME  is left as default, and you have modified it from left to right.

If you delete "ENAME" column, then add the same column to the region source again,

"Column Alignment" of "ENAME" will not be restored.

 

Changes

Deleting a column from the region source, then add(restore) the same column to the source.

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.