DIF Errors With ORA-00907 During Upload When WHERE Clause Has 'OR' Operator Or 'ORDER BY' Clause
(Doc ID 2508643.1)
Last updated on OCTOBER 24, 2019
Applies to:Oracle Web Applications Desktop Integrator - Version 12.2.6 and later
Information in this document applies to any platform.
On R12.2.6 env, when creating DIF integrators with interface attribute definition WHERE clause having 'OR' operator or 'ORDER BY' clause without parenthesis, and during upload from the download document, the validation will give below error. Even if the document is uploaded without errors, the data uploaded to the table will contain different values then the uploaded data since the WHERE clause does not have parenthesis.
ORA-00907: missing right parenthesis
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