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.
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: Failed to generate XML Schema Definition for the SQL query. Please check the SQL Query entered. Refer Oracle documentation for further information.
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.
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