My Oracle Support Banner

WebADI Importer Error: Invalid or incompatible default value : SQL Query, set via personalization on Type (Doc ID 2779047.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.
WebADI: Web Applications Desktop Integrator


Symptoms

Attempting to create/modify a custom WebADI integrator results in the following error messages when working with the Importer:

ERROR
-----------------------
Invalid or incompatible default value : SQL Query, set via personalization on Type

The requested page contains stale data.
The view object BneIntegratorsAM.BnePreImportRulePVO1 contained no record.
The displayed records may have been deleted, or the current record for the view object may not have been properly initialized.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) Desktop Integration Manager Responsibility > Create Integrator
2. After entering the appropriate data for Integrator, Interfaces, Contents and Uploader, click (B) Next to reach the Importer.
3. Select Importer Type (Asynchronous), enter Importer Name, then click on 'Concurrent Program Request Submission' from the Importer Rules section.
4. Error occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create/modify custom integrators.

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!


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