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 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Lead Management - Version 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Sales Cloud Service - Version 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

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:

 

Solution

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 hundreds of Community platforms