Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Bursting control file to loop through the XML, possible?

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?
Answers
-
I can put the data into pdf file. But the requirement is the data shows in the email body .. not a pdf file attachment in the email. If there is a way that I can print the body of the PDF file into the email body, that will work. But I don't know is that possible...
0 -
Hi,
why do you want to display in the bust subject ? you can provide the data in PDF file right?
I don't think so we have LOOP or not...
0 -
Please check the following for the complete bursting process
and for your email delivery please check your parameters as below ...
Regards,
Yugandhar
0