JBO-25071: Applying List Binding LOV_AccountName With Given Set Of Values Leads To Multiple Matching (Doc ID 2147522.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales - 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

JBO-25071: Applying List binding LOV_AccountName with given set of values leads to multiple matching

When using Web Services to create a lead, an error is received. The process is the following:

Using soapUI, leads are created. createLead method is used.

We want to set a validation to restrict duplicate account creation.

The trigger used for this is:

println("createOpportunityAftIns: " + Name)
def leadId = getAttribute('LeadId');

def primaccountid = getAttribute('CustomerPartyId');
def primaccname = getAttribute('AccountName');

def vPrimOff = EventPlan_Obj_c?.EventOffice_Obj_c?.RecordName
def vOffUnit = adf.util.GetEventOffice(vPrimOff);
println("createOpportunityAftIns vOffUnit: " + vOffUnit);

def accflag = 'N';

if(primaccountid == null)
{
def voleadacc = newView('OrganizationProfile');
def vcleadacc = newViewCriteria(voleadacc);
def vcleadaccrow = vcleadacc.createRow();
def vci1leadacc = vcleadaccrow.ensureCriteriaItem('OrganizationName');
vci1leadacc.setOperator('=');
vci1leadacc.setValue(primaccname);
vcleadacc.insertRow(vcleadaccrow);
voleadacc.appendViewCriteria(vcleadacc)
voleadacc.executeQuery();
def accfound = voleadacc.first();
if(accfound != null)
{
accflag = 'Y';
println("Accountfound");
setAttribute('CustomerId', accfound.getAttribute('PartyId'))
println("Accountfound After SetAttribute");
}
}



ERROR
-----------------------
JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000004202451 ] in MklLeadEOJ
JBO-25183: Exception in expression "MklLeadEO" trigger "afterInsert" : oracle.jbo.ListBindingMismatchException
BO-25071: Applying List binding LOV_AccountName with given set of values leads to multiple matching rows for a row of type:SalesLead, key oracle.jbo.Key[300000004202451 ]




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create lead using SOAP UI using createLead method.
2. See the response error payload.

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