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:

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

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