I have a xml destination profile similar to one as shown below.
Here I am splitting the xml with respect to the <RE>. RE and LI1 are unbounded elements. I have used "line item increment" function to assign values to seq_no. It increments seq_no continuously even for the next occurrence of RE. I need to reset the value to 1 once the 1st occurrence of RE has been closed. I tried giving reset value with cache by mapping and cache by document and they didn't work. How to reset seq_no?