How to burst the whole output

sheebs_sheebs

Summary

How to burst the whole output

Content

Hello, I have a requirement to burst the output to specific email. I am in R12.1.3 and using Excel in 3 tabs as output.

In the below sample, how do I burst at DATA level and what should I give in  key="" output="" . I do burst at DEPT level and that works fine but I do want email the output as attachment to HR email.

Sample data

<?xml version="1.0" encoding="UTF-8"?> <DATA> <DEPT>   <DEPARTMENT_ID>20</DEPARTMENT_ID>   <DEPARTMENT_NAME>Marketing</DEPARTMENT_NAME>   <EMPS>   <EMPLOYEE_ID>201</EMPLOYEE_ID>   <EMP_NAME>Michael Hartstein</EMP_NAME>   <EMAIL>MHARTSTE</EMAIL>   <PHONE_NUMBER>515.123.5555</PHONE_NUMBER>   <HIRE_DATE>1996-02-17T00:00:00.000+00:00</HIRE_DATE>   <SALARY>13000</SALARY>   </EMPS>   <EMPS>   <EMPLOYEE_ID>202</EMPLOYEE_ID>   <EMP_NAME>Pat Fay</EMP_NAME>   <EMAIL>PFAY</EMAIL>   <PHONE_NUMBER>603.123.6666</PHONE_NUMBER>   <HIRE_DATE>1997-08-17T00:00:00.000+00:00</HIRE_DATE>   <SALARY>6000</SALARY>   </EMPS>   </DEPT> <DEPT> ... ... </DEPT> </DATA>

Bursting file

<?xml version="1.0" encoding="UTF-8"?> <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting"> <xapi:request select="/DATA"> <xapi:delivery> <xapi:email id="EMAIL" server="xxx.com" port="25" from="xxx.com" reply-to="xx.com"> <xapi:message id="EMAIL" to="sheeba@sheeba.com" attachment="true" subject="[INTERNAL] - Monthly Expenses - Top 10 Claims"> Dear ${DEPT}, email body </xapi:message> </xapi:email> </xapi:delivery> <xapi:document key="${DEPT}" output="${DEPT}" output-type="excel" delivery="EMAIL"> <xapi:template type="EXCEL" location="xdo://XX.XXTEST_TP.en.00/?getSource=true"> </xapi:template> </xapi:document> </xapi:request> </xapi:requestset>

Reference used to create excel template : https://docs.oracle.com/cd/E12844_01/doc/bip.1013/e14667/create_excel_tmpl.htm#ext_multsheets

Thank you

Sheeba

sheebs_sheebs

Gave like this and worked key="${DATA}" output="Monthly Expense"

sheebs_sheebs

Well after posting this , I could burst the whole report but is there a way to change the name of the output file. It is attached as xdo1_2.xls Thanks Sheeba