Summary
Bursting control file to loop through the XML, possible?
Content
HI : Can Bursting control file include a "looping" though the data from XML and put it into email body?
Here is my situation. we are in EBS 11.5.10.2 with BI publisher 5. ( yes sorry, very old )
User has a requirement to put the following information in the email body ( not attachment )
Dear customer : Here is your order
Item description
Apple Fruit
long desk furniture
car transportation
However, here is my XML output
<Order>
<item_detail>
<item>Apple </item>
<description>Fruit</description>
</item_detail>
<item_detail>
<item>Long Desk</item>
<description>Furniture</description>
</item_detail>
<item_detail>
<item>Car</item>
<description>Transportation</description>
</item_detail>
</Order>
I do not aware that I can put a LOOP into the control file........ or I just did not know... Do you?