1. Reltio Support
  2. Knowledge Base
  3. Connectors
  4. SFDC

Why is the entity not being updated to Salesforce where there is multiple OV values for an attribute that is used in the to_salesforce mapping definition?

gloria.faley
Updated

Question

We have included CustomerProcessEngagementCd values in connector mapping filter. The updated filter is as below. 

Reltio to Salesforce Mapping:

"filter": "equals(configuration/entityTypes/BusinessOrganization/attributes/ReadyToPublish,'true') AND 
(equals(configuration/entityTypes/BusinessOrganization/attributes/DataStewardValidationStatus, REJ) OR
 equals(configuration/entityTypes/BusinessOrganization/attributes/DataStewardValidationStatus, APRV)) AND 
(equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, DIR_PRC_EXCPT) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, DISTI_PRC_EXCPT) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, SD_REV) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, SLS_PPLN))"
Any entity with CustomerProcessEngagementCd = ORD_CASH or SLS_PPLN is not synchronizing.

We see the following in the connector log.

{            "timestamp": "2022-10-10T14:17:58.760Z",
            "severity": "INFO",
            "message": "env:361<0ReajuwzxWVebB3+00D2i0000000bckEAA> <m>: CNR_I103 Event ENTITY_CHANGED, uri: entities/hLpCT0P, skipped: Sync disabled for record entities/hLpCT0P"
}

mceclip0.png

Answer

The entity has three OV values for theCustomerProcessEngagementattribute.  The SFDC connector analyses and synchronize only one OV value even if multiple OV values are present. In this case, it will take ORD_CASHCustomerProcessEngagementCdvalue and will apply the filter from the mapping:

 

(equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, DIR_PRC_EXCPT) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, DISTI_PRC_EXCPT) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, SD_REV) OR 
equals(configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement/attributes/CustomerProcessEngagementCd, SLS_PPLN))

 

The ORD_CASH value is not in the filter, so the entity will not be processed across the connector.

 

The solution is change the survivorship so that there is only one OV=true attribute value for configuration/entityTypes/BusinessOrganization/attributes/CustomerProcessEngagement attribute.  The other solution is make the valueSLS_PPLNfirst in the list of the OV values.

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

See more