Error upon Lead Conversion : Client received SOAP Fault from server : JBO-25020: View row with key null is not found in Account (Doc ID 2294882.1)

Last updated on AUGUST 08, 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.12.1.0 version, Opportunities

Recently after upgrading to R12 we can no longer update an Account Records SalesProfileType. Which was working perfectly in R11.

The script using web services is as follows. This is placed in a BeforeInsert trigger in opportunity object.

-------START OF SCRIPT---------

if (LeadType_c == "END-USER"){
  def enduserId = getSelectedListDisplayValue('EndUserAccount_c')
  def account = newView('OrganizationProfile');
  def criteria = account?.createViewCriteria();
  def type
  def accId
  def accName
  def criteriaRow = criteria?.createRow();
  criteria?.insertRow(criteriaRow);
  def criteriaItem = criteriaRow?.ensureCriteriaItem('OrganizationName');
  criteriaItem?.setValue(enduserId);
  account?.appendViewCriteria(criteria);
  account.executeQuery();
  if(account.hasNext()){
  def accRow = account.next();
  accId = accRow?.PartyId
  println (' The party id of og in the query : ' +accId)
  def accountM =
  [
  PartyId: accId,
  Type: 'ZCA_ENDUSER',
  ]
  adf.webServices.AccountWS.updateAccount(accountM)
  }
}
-------------END OF SCRIPT---------------

ERROR
-----------------------
Error:
Exception in expression "MklLeadVO" object function BeforeLeadConversion() : oracle.binding.expr.ServiceInvocationException Unexpected exception caught: oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException, msg=Client received SOAP Fault from server : JBO-MKL:::MKL_LEAD_OPTY_CNVRT_EVNT_ERR: JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000071005131 ] in OpportunityEOJBO-25183: Exception in expression "oracle.apps.sales.opptyMgmt.opportunities.model.entity.OpportunityEO" trigger "beforeInsert_trigger" : oracle.binding.expr.ServiceInvocationException JBO-29000: Unexpected exception caught: oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException, msg=Client received SOAP Fault from server : JBO-25020: View row with key null is not found in Account.: Client received SOAP Fault from server : JBO-25020: View row with key null is not found in Account.: Client received SOAP Fault from server : JBO-MKL:::MKL_LEAD_OPTY_CNVRT_EVNT_ERR: JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000071005131 ] in OpportunityEOJBO-25183: Exception in expression "oracle.apps.sales.opptyMgmt.opportunities.model.entity.OpportunityEO" trigger "beforeInsert_trigger" : oracle.binding.expr.ServiceInvocationException JBO-29000: Unexpected exception caught: oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException, msg=Client received SOAP Fault from server : JBO-25020: View row with key null is not found in Account.: Client received SOAP Fault from server : JBO-25020: View row with key null is not found in Account.
at "MklLeadVO" object function BeforeLeadConversion() line 42


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a Lead
2. Convert Lead
3. Notice the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users can not convert leads

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