Creating WebADI Integrator Fails With: Invalid Or Incompatible Default Values : SQL Query, Set Via (Doc ID 2178854.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.4 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version,

Creating custom WebADI Integrator fails with below error when trying to create Group Definition/Concurrent Program Request.


ERROR
------
Invalid or Incompatible default Values : SQL Query, set via personalization on type.

Changes

The issue can be reproduced at will with the following steps:


1. Add Function: Desktop Integration: Create Document
2. Create the interface > Next
3. Select uploader as ‘From Template’ > create > next
4. Creating Group Definition/Concurrent Program Request Submission

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