Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bursting control file to loop through the XML, possible?

Received Response
178
Views
3
Comments
Fleong
Fleong Rank 2 - Community Beginner

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?

Tagged:

Answers