XML Publisher Bursting

Below is the piece of code which we will be using in XML Bursting process

Step 1: Use below code in After Trigger section in Report Builder

function AfterReport return boolean is

v_request_id number;

lc_boolean2           BOOLEAN;

begin

v_request_id :=  fnd_request.submit_request(

                  application => 'XDO',            

                  program => 'XDOBURSTREP',     

                  description=>  'v_cp_description',  

                  argument1=>'N', 

                  argument2=> :P_CONC_REQUEST_ID,   

                  argument3=> 'Yes'                

                  );

SRW.USER_EXIT('FND SRWEXIT');  

  return (TRUE);

end;

Step 2: Use below code in Before Report

srw.user_exit('FND SRWINIT');

Step 3: Attach the bursting file and make sure all the details are correctly placed as below

<?xml version="1.0" encoding="UTF8" ?> 

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"> 

<xapi:request select="/XXEXEMP/LIST_G_EMPLOYEE_NUMBER">

<xapi:delivery> 

<xapi:email server="192.168.16.34" port="25" from="support@.com"> 

<xapi:message id="123" to="dinesh@.com" cc="" 

bcc="" attachment="true" 

contenttype="html/text" subject="Termination Employees Information Report">

Dear Team,

Please find enclosed Termination Employees Information Report.

Regards

HR

*************This is a system generated email****************

</xapi:message> 

</xapi:email> 

</xapi:delivery> 

<xapi:document output="Termination Employees Information Report" output-type="excel" delivery="123"> 

<xapi:template type="rtf" 

location="xdo://XX.XXEXEMP.en.00/?getSource=true">

</xapi:template> 

</xapi:document> 

</xapi:request> 

</xapi:requestset>

Step 4: Use below code to identify the template details

SELECT APPLICATION_SHORT_NAME||'.'||

TEMPLATE_CODE||'.'||

DEFAULT_LANGUAGE ||'.'||

DEFAULT_TERRITORY

FROM XDO_TEMPLATES_VL

WHERE TEMPLATE_CODE like 'XXEMP_INFORMATIONS'