My Oracle Support Banner

Lead Import Failed Due To ODI 'ORA-00907: missing right parenthesis' Error (Doc ID 1934294.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Lead Management Cloud Service - Version to [Release 1.0]
Oracle Fusion Lead Management - Version to [Release 1.0]
Oracle Fusion Sales Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


The customer is testing Lead import with one column (Lead name) in the CSV file. The import job completed with load error, but the Error or Exception log was not created.

Below error is generated in ODI:



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.