Dynamic CRM workflows and integration


I have a Oracle DB integrating with CRM. CRM pulls data and Oracle and inserts to Account and Opportunity entities via the Organization Service.

I have work flows that are configured based on the fields modified by the integration but if there are multiple updates to a particular field even though the same data is updated CRM detects it as a change and triggers the WF.

i.e. I have a stage called application entry when the same application entry value is past to the field and the previous entry is Application Entry CRM detects it as a change and triggers the WF.

Is there anything we can do to avoid this from happening.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Feridun KadirPrincipal ConsultantCommented:
Are you sure that the workflow isn't triggered by some other condition?  Do you have multiple fields selected in the when field changes section of the workflow?

I suggest enabling auditing on the relevant entities (even if temporarily) to monitor all the changes to records in case something else is going on.
GulfITAuthor Commented:
Auditing is enabled and the WF is triggered on one field change.

For e.g. Stage field is been push each time any other field changes even though the Stage field has not changed.

We will say that the Stage field changes are as below as one push job.
10:32 Stage1 to Stage1
10:33 Stage1 to Stage1

CRM detects that the Stage has changed even though the value has not.
Feridun KadirPrincipal ConsultantCommented:
Sorry for the delay in replying. I don't have any other suggestions for you. I suspect it is something to do with how the integration program is updating CRM but that is only a guess.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GulfITAuthor Commented:
Thanks for the Suggestion.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.