Write Back Error When Updating VARCHAR Column If The Report Has Date Column (Doc ID 2685088.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Symptoms

During update of a VARCHAR column in Write back report, received below error where the report has a date column. Without updating the Date column, other columns are not updateable.

Steps to reproduce

1. Create a simple report having VARCHAR and DATE columns.
2. Enable Writeback to the report.
3. Enable Update options to VARCHAR and DATE columns.
4. Try to update only VARCHAR column. Above error would be received.
5. Click 'Apply' option, above error would be received and not able update rest of the columns. All other columns gets updated only when a date column is updated  which becomes mandatory. 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.