XML Publisher Bursting



About Bursting
Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a "Key" value. For each block of the data, a separate document is generated and delivered.

 


Dynamic location value :
location="xdo://XXCUST.XXCUST_RTF.en.00/?getSource=true">

location="xdo://<Application short name>.<DataTemplate Shortname>.<Language>.<Territory>/?getSource=true">

Using the below code for running the Bursting file:(After Report Trigger)

G_REQUEST_ID is the request_id of the main program submitted.

G_BURST_REQUEST_ID := APPS.FND_REQUEST.SUBMIT_REQUEST ( 'XDO',
          'XDOBURSTREP', '', '', false, G_REQUEST_ID, 'Y', '', CHR(0), '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '');
          COMMIT;

 

Bursting:
Error!! Could not deliver the output for Delivery channel:null

Solution:
May be wrong FROM and TO Email ID’s provided in the Bursting file. Check those

  • Sample Bursting file (.xml)
 
 Upload the created .xml file into XML Data definition --> Data Definition
 


Different types of XML Publisher Bursting:

 
 


References:
 

Comments

  1. hello, to burst through Email, where should I give username and password? so send mails via an account I will need to pass username and password right?

    ReplyDelete

Post a Comment

Popular posts from this blog

Finding concurrent program assigned to which responsibilities