My Oracle Support Banner

DBAdapter Invoke Wizard Failed With Error "Failed to generate XML Schema Definition for the SQL query" (Doc ID 2698949.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Integration - Version 17.4.1 and later
Information in this document applies to any platform.

Symptoms

On : NA version, Integration RT

While using the below query condition in OIC DB Adapter invoke flow, it fails with error.

Query Where Condition:
WHERE pay_recon.ofa_check_id = t24_ack.check_id and trunc(t24_ack.last_update_date) between #LASTJOBRUNTIME and trunc(sysdate))


ERROR
-----------------------

Error: Failed to generate XML Schema Definition for the SQL query. Please check the SQL Query entered. Refer Oracle documentation for further information.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create DBAdapter query with where condition as above and note it fails to generate the schema.

 

Changes

 

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.