R12 E-Buiness Suite Web Applications Desktop Integrator Upload Fails With Error 'ORA-20001: Read only fields cant be updated. Please download again' For Some WebADI Templates

(Doc ID 2378284.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 E-Business Suite R12 Web Applications Desktop Integrator, WebADI related issues

 

 

 

When users upload a Web ADI template the following error is received:

'ORA-20001: Read only fields cant be updated. Please download again'

In some cases the read only columns with a default value upload the default value instead of the user entered value.

This occurs for both new inserts or downloaded rows which have read-only interface columns defined with default type and value.

The end result is the system uploads the default value instead of the one the user entered.

Changes

 Any of the following patches may have been recently installed when the problem occurs.

21823185
21959691
19273341
18789889
19069057
17445419
22962367

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms