Bursting control file to loop through the XML, possible?

Fleong

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?

Fleong

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...

mist123

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...

YGUTTIKONDA

Please check the following for the complete bursting process

In Depth Apps - Oracle eBusiness Suite - Gareth Roberts: BI Publisher EBS Bursting 101: A tutorial/case study including …

and for your email delivery please check your parameters as below ...

Regards,

Yugandhar