How to submit XML report publisher concurrent program from backend?

Here is the process of submitting XML publisher Report through Backend.

At times you might need to take the xml output of an existing program and apply an XML Publisher / BI Publisher Template to it. The standard use case is if the output is generated by pro*c code/ a spawned or host concurrent program. The XML Report Publisher concurrent program can help achieve this.

The Report takes the Concurrent request id, template application id, template name, template locale, template type and output type as parameters.

A sample code is shown below.

DECLARE

  l_req_id NUMBER;

BEGIN

  fnd_global.apps_initialize(6087,

                             20420,

                             1,

                             0);

  l_req_id := fnd_request.submit_request('XDO',

                                         'XDOREPPB',

                                         NULL,

                                         NULL,

                                         FALSE,  

                                         FND_GLOBAL.CONC_REQUEST_ID,

                                         1919318,

                                         20003, -- Receivables

                                         'XXGILGMDWOPICKLIST', -- Statement Generate

                                         'en-US', -- English

                                         'N',

                                         'RTF',

                                         'PDF');

  dbms_output.put_line(l_req_id);

     commit;

END;