My Oracle Support Banner

Eloqua Integration With Sales Cloud Failed With errorMessage:"Failed to build ViewCriteria from expression " (Doc ID 2313771.1)

Last updated on DECEMBER 22, 2020

Applies to:

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


On : 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:

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. "


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.