9 Replies Latest reply on Jan 25, 2019 6:40 AM by Renuka16

    Update rules don't seem to be consistently working

    Matthew Phillip

      I've created an update rule that updates CDO fields based on a lookup table. This lookup table takes the SFDC 18 digit values and replaces them with the actual name of one of our sales agents (ex: replace 0018A00000fXt13QAD with Jane Doe).

       

      I've added this update rule to an existing CDO Program Canvas that updates a different field. The update rule I am referring to is the second one on the canvas. (Update Opportunity Owner). See screenshot below:

      2019-01-09_10h43_38.png

       

      Once this is complete I want to sales agent name displayed in an email via a field merge.

       

      However, I've come across CDO's that have entered this program as recently as 3 hours ago that do not have their fields updated. I've checked multiple CDO's and confirmed that the SFDC value does match a value in the lookup table. I'm not sure what I'm doing wrong here.

       

      Any thoughts would be welcome!

        • 1. Re: Update rules don't seem to be consistently working
          Renuka16

          Hi Matthew Philip ,

           

          1. Did you checked whether any one of the contacts from the CDO has the SFDC ID matching to the lookup table?

          2. The CDO field which you are updating is already having some value in it. If yes it may be because if Data import priority. Try to create new field and update the value

           

          https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/Help/DataImportExport/DataImportPriority.htm

          • 2. Re: Update rules don't seem to be consistently working
            Matthew Phillip

            Thanks for the follow-up Renuka.

             

            For point #1, yes, the CDO matches a SFDC ID value in the lookup table, so I don't think that is the problem.

             

            Your next point makes a bit more sense, with regards to what I am seeing. Yes, the CDO field (Opportunity Owner) does have a value in it. It looks something like "0018A00000fXt13QAD". The article you included with your post says that "Data priority rules are not applied if the contact is updated using update rules via program build or CDO services".

             

            I'm pretty sure my scenario falls into that exception. (If that isn't the case, please tell me otherwise!)

             

            So... is my solution just to create a new field and update it with the appropriate values in the lookup table based on the SFDC ID in a separate field? Or is it something else entirely?

            • 3. Re: Update rules don't seem to be consistently working
              Matthew Phillip

              Another thought I had was just to remove the LookUp table and create a big update rule set as follows:

               

              Set to value "Jane Doe" where Opportunity Owner field = "0018A00000fXt13QAD" and then just duplicate that rule of each of the agents we have.

              More manually intensive and not the ideal solution, but it gets me what I need for now.

              • 4. Re: Update rules don't seem to be consistently working
                Matthew Phillip

                As a follow up... what I built works some of the time... maybe even most of the time. But not 100% of the time like I expect.

                 

                Notice in the attached screenshot below that the records modified at 13:14 on 1/23/2019 we had the Opportunity Owner field updated properly. All the CDOs that were modified at 14:00 on the same day do not have that field updated but then, at 14:14 the records had the same field updated.

                 

                2019-01-23_13h52_36.png

                So, is there a timing issue here? I'm not sure what I'm missing.

                 

                Thanks for any help!

                • 5. Re: Update rules don't seem to be consistently working
                  Renuka16

                  Hi Matthew exactly.

                   

                  You need to create new CDO field and update the Owner name. But you don't need to update the value that matches with the lookup table.

                   

                  Just create a new field called Owner name. Your lookup table willn't change. Just change the update rule.

                   

                  Previously your update rule will replace the ID to name. Now change the rule to write the owner name in to the new table instead of overwriting the Owner ID value.

                   

                  Thanks,

                  Renuka

                  • 6. Re: Update rules don't seem to be consistently working
                    Renuka16

                    Can you tell what exactly you did i mean the steps

                    • 7. Re: Update rules don't seem to be consistently working
                      Matthew Phillip

                      Repita, thanks for the reply!

                       

                      To clarify, I am not using a Lookup Table at the moment. I tried but the solution was not working for me. Instead, I created a large update rule set with conditional rules for each agent value and name.

                       

                      I have created the new CDO field (Owner Name) and then a Lookup Table (Agent Name and Value). I've configured the new update rule below, but I believe it is incorrect. Can you tell me what I've done wrong here?

                      2019-01-24_11h16_33.png

                      Alternatively, I believe I can use my existing update rule with the below configuration.

                      2019-01-24_11h20_04.png

                       

                      I'm not sure how to correctly configure the Lookup Table update rule and I am thinking the existing update rule with the revised configuration might work.

                      • 8. Re: Update rules don't seem to be consistently working
                        Renuka16

                        Hi I Think you need to look for the Opportunity owner ID field and then update the Owner name.

                         

                        In the first screenshot can you change the lookup field to Opportunity Owner ID

                         

                        Because you have the ID with already and you have look for that ID in the lookup table and then choose the Owner name value matching for that lookup ID

                        • 9. Re: Update rules don't seem to be consistently working
                          Renuka16

                          Try these Steps ,

                           

                          1. Have the Owner ID and Owner Name in the Lookup table.

                          2. While creating the table you lookup field will be field which has the SFDC ID and replacement column name will be your owner name field.

                          3.If you have many number of rows you can upload them Via Excel

                          4. Then Create/ update the the update rule to update the newly created

                          a. Owner name field of the CDO

                          b.Choose Overwrite the value from lookup table

                          3.Select the Lookup table & field (ie field with ID)

                          1 person found this helpful