XML Bursting R12

Enable Notification mail server

Navigate system administrator -> Oracle Applications manager -> workflow

Click view details to refer email server inbound/outbound details

Port: 25

Click test mailer and select recipient role to send test message

Pre-requisites

•          Create data definitions
•         Create template
•          Create concurrent program
•          Assign it to request group

XML BURSTING Control File elements

xapi:request: Give details of how you want to split the XML File

xapi:email: Give details of the Email

·         id: This is a unique value that identifies each group. In our case it is the Supplier Number.

·         reply-to: This is the reply to email address

·         from: This is the from email address that will be used while sending the email

·         port: The port number of the email server. Check with your DBA / System Administrator for this value.

·         server: The details of the email server

xapi:message: Give details of the Email Message

·         subject: Subject of the Email

·         attachment: We are attaching the report output with the email. So the value should be “true”.

·         to: The email id of the Supplier, which is the recipient’s email address.

·         id: This is a unique value that identifies each group. In our case it is the Supplier Number.

xapi:document: Here we define the output document details

·         output-type: The output type of the report output.

·         output: The folder in which the output file will be saved.

xapi:template: Give details of the RTF Template

·         type: Give the details of the Template Type. In our case it is RTF

·         location: Location of the RTF Template.

XML Bursting Control File Definition

To get path of XML template location

select   'xdo://'||

         xtb.application_short_name||'.'||

         xtb.template_code ||'.'||

         xtb.default_language ||'.'||

         xtb.default_territory||

         '/?getSource=true'

  from   apps.xdo_templates_b xtb

 where   xtb.template_code ='DCFAPDN'

Add “afterReport” definition in package specification

 function afterReport (p_conc_request_id in number) return boolean;

Implement “afterReport” function in package body

function afterReport (p_conc_request_id in number) return boolean is

     l_conc_id     NUMBER;

   g_request_id  NUMBER;

  begin

     l_conc_id :=

   fnd_request.submit_request

           (

             application   => 'XDO'

            ,program       => 'XDOBURSTREP'

            ,description   => NULL

            ,start_time    => SYSDATE

            ,sub_request   => FALSE

            ,argument1     => NULL         

            ,argument2     => p_conc_request_id  --Request ID of XML Publisher Report

            ,argument3     => 'Y'           -- debug Flag

           );

           

           dbms_output.put_line (l_conc_id);

   COMMIT;

  

   RETURN (TRUE);

  end afterReport;

Define Default package in data template

<dataTemplate name="DCFAPDN" defaultPackage="DCF_AP_DEBIT_NOTE_REP_PKG" version="1.0">  

Define data trigger

<dataTrigger name="afterReport" source="DCF_AP_DEBIT_NOTE_REP_PKG.afterReport(fnd_global.conc_request_id)"/>

Run concurrent program

It will internally call “Bursting program”

Output of Burst Program

Electronic mail notification

Check electronic notifications are triggered to respective users as per XML Bursting definitions