I have a rule that copies the value from one field to the other but if i make a change after a first pass it affects the rule again. It is like i fill in some detail in Field 1 it populates field 2 for the fiest time but on the 2nd pass i make update it again affects the field 2. I want to eliminate the execution for the 2nd pass... I have to leave both the fields editable....
The first dependency would be for Field 1 set to any value. The second dependency would be for the hidden field having a null value. The rule would set Field 2 to the value of Field 1 and would set the hidden field to a non-null value.
Note that this only works if you are at a product level that allows the rule to set a value for a field that is listed in the dependency list. I think that was a 7.5 feature but I am not sure. It is supported only for request fields and is not available with Table Component rules.
you can have one more hidden field with default value 0 in whihc you have to populate/store count/sequnce for value change on field 1. just include this field in your rule, this you you can set the rule to trigger as per your choice of count.
select [field1],[field1],[hiddenfield] + 1,[hiddenfield] + 1 from dual