XML Bursting in Oracle Apps R12

XML Bursting in Oracle Apps R12:

It is used to deliver report to multiple emails, let it be your pay slips or PO’s or others.

1. Create rdf data model.
2. Register Executable.
3. Register Concurrent Program
4. Setup the temporary Working directory.
5. XML Bursting control File.
6. Create the rtf template.
7. Register Data definition.
8. Upload XML control file to data definition.
9. Register data template.
10. Move rdf file to registered TOP.
11. Move rtf file to tmp directory.
12. Attach the concurrent program to request group.
13. Attach another XML Publisher Report Bursting Program concurrent program to same request group.
14. Run the report.
15. Errors and solutions

1. Create rdf data model.

Query:

select full_name, person_id,email_address,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE

from per_people_x ppx

where email_address is not null

and employee_number in ('9213','9214','9215')

and business_group_id = :p_business_group_id

and rownum < 5

function AfterReport return boolean is

 req_id number;

begin

            req_id := FND_REQUEST.SUBMIT_REQUEST(

                application =>'XDO',

             program     =>'XDOBURSTREP',

             description =>null,

             start_time  =>null,

             sub_request =>FALSE,

             argument1   =>'Y',

             argument2   =>:P_CONC_REQUEST_ID,

             argument3     =>'Y');

   

 if req_id = 0 then

   srw.message(100,'Failed to submit bursting program');

 end if;                                        

 SRW.user_exit('FND SRWEXIT');

 return (TRUE);

end;

2. Register Executable

3. Register Concurrent

4. 

5.

6.

7.

8.

9.

10.

11.

12, 13.

14.

Errors and Solution:

If the xml report run is normal and Bursting concurrent Program ends with Error then check the patch number Patch 9501440:R12.XDO.B is applied or not.

 

SELECT patch_name
FROM   apps.ad_applied_patches
WHERE patch_name LIKE '%9501440%'

 

Reference: Doc ID 1276845.

If both programs ends normal, but no email then need to check with the network and database team regarding server and port which we configured in the xml control file.