Error Creating Leads Through API (Doc ID 2268274.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Leads, Sales Campaigns

Customer has a script syncing data between
their primary internal system with Sales Cloud using the Sales Cloud API.
This script has been working fine until April 13th when it started receiving
the below error when trying to create Lead records. They tried using this
posting this JSON to the API outside of the sync script and received the same
error. But after removing the values for PrimaryContactId and CustomerId,
they are not seeing the error. This issue is happening with few accounts and
contacts.

API URL:
https://ccgw.crm.us2.oraclecloud.com:443/salesApi/resources/latest/leads

Payload: {"Name":"Ron Herman","LeadTopic_c":"Demo Request Form
Submission","PartnerName_c":"ONE STEP RETAIL
SOLUTIONS","OPSLeadStatus_c":"ACTIVE","URL_c":"www.ronherman.com","Owner_c":"J
ean-Luc
Rieu","AdditionalOwner_c":"","NumberOfStores_c":"3","Consultant_c":"N","Curren
tPOS_c":"","NumberOfPOS_c":"0","ProductsBeingConsidered_c":"","StoreName_c":"R
on Herman
Inc","StatusCode":"UNQUALIFIED","IndustryType_c":"SOFT","Region_c":"UNITED
STATES_CANADA","PrimaryContactId":"300000005442219","CustomerId":"300000005441
752"}


ERROR
-----------------------
"Applying List binding LOV_AccountName with given set of values leads
to multiple matching rows for a row of type:MklLeadVOForRest, key
oracle.jbo.Key[300000005347770 ]An application error occurred. See the
incident log for more information. An application error has occurred. Your
help desk can use the following information to obtain a more detailed
description of this incident: 10, Server Domain: CRMDomain, Server Instance:
SalesServer_1, Application Name: SalesApp.
JBO-25071: Applying List binding LOV_AccountName with given set of values
leads to multiple matching rows for a row of type:MklLeadVOForRest, key
oracle.jbo.Key[300000005347770 ]"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Rest
2. End point for the API call is
https://ccgw.crm.us2.oraclecloud.com:443/salesApi/resources/latest/leads
3. Post> Input
4.Getting error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Leads with Accounts and Contacts through API .

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