Categories
- All Categories
 - Oracle Analytics Learning Hub
 - 19 Oracle Analytics Sharing Center
 - 17 Oracle Analytics Lounge
 - 233 Oracle Analytics News
 - 44 Oracle Analytics Videos
 - 15.9K Oracle Analytics Forums
 - 6.2K Oracle Analytics Idea Labs
 - Oracle Analytics User Groups
 - 87 Oracle Analytics Trainings
 - 15 Oracle Analytics Data Visualizations Challenge
 - 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