Hi all,
I am working on a BPM > Sales Order > Update method, specifically in the Order Release module. Users are getting ttOrderRel has multiple records error when I enable the BPM. I am guessing it has something to do with my use of Set BPM Data Field where I set callContextBpmData.Number02 to OrderNum from ttOrderRelRow.OrderNum.
Any ideas on how to fix / work around this?
Thanks much for your time,
Elvin
typically when you get this, it is because you are not filtering out only the “modified” record. Remember that when something is being modified, there will be two rows returned… the unmodified version (rowmod = “”) and the modified one (rowmod = “U”). There are some cases, where the system DOES allow multiple rows to be modified at one time, and so you may need to select only the first one. It is hard to tell unless we see what your BPM is trying to do and how you defined it.
I did set a condition of “If there is at least one modified record in the ttorderrel table”. maybe i should be more specific by doing “if ttorderrel.field has been updated to another value”. I will try that for now, thank you!