Eloqua Integration With Sales Cloud Failed With errorMessage:"Failed to build ViewCriteria from expression "

(Doc ID 2313771.1)

Last updated on DECEMBER 05, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Leads, Sales Campaigns

The customer has an integration between Eloqua and Oracle Sales Cloud. They configured an Import sync to pull Leads that have been retired in Sales Cloud over to Eloqua. They are noticed that since the Oracle Sales Cloud Release 12 upgrade was completed this integration is now failing with the following error:

ERROR
statusCode:500, reasonPhrase:"Internal Server Error", errorMessage:"Failed to build ViewCriteria from expression "(StatusCode='RETIRED';LeadDoNotSyncWithEloqua_c!='Y';COLeadStatus_c='PARTNER_LOST') AND (LastUpdateDate between '2017-09-16T06:29:00' and '2017-09-25T17:32:00')" using view object MklLeadVOForRest. "

Cause

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