Prabhakar Somanathan

When developing XML Publisher / Bi Publisher report, there are many occasions when we have to submit the concurrent program to generate XML Publisher / BI Publisher report using fnd_request.submit_request. When we try to view the concurrent program output we get the following error "Unable to find published output for this request".

In this article i will explains the mandatory steps to be completed before submitting a concurrent program to generate XML Publisher / BI Publisher report using fnd_request.submit_request.

Error Message Received :
When we submit a concurrent program to generate XML Publisher / BI Publisher report using fnd_request.submit_request , the Template Name, Template Language and Format is not set in the concurrent program option. Hence when we try to view the output, we get the error "Unable to find published output for this request".


Solution  :

Set the Template details for the concurrent program using the function Fnd_Request.add_layout() before calling the fnd_request.submit_request.;

function add_layout (template_appl_name in varchar2,
                            template_code     in varchar2,
                            template_language in varchar2,
                            template_territory in varchar2,
                            output_format     in varchar2) return boolean is
 
Example Code :

PROCEDURE SubmitBursting(p_request_id IN INTEGER) AS
n_request_id NUMBER;
lay boolean ;
BEGIN

lay := fnd_request.add_layout('XDO',
'BURST_STATUS_REPORT',
'en',
'US',
'PDF');

n_request_id := fnd_request.submit_request('XDO'
,'XDOBURSTREP'
,NULL
,NULL
,FALSE
,p_request_id
,'Y'
);
END SubmitBursting;

Add comment

Name (required)

E-mail (required, but will not display)

Website

Notify me of follow-up comments

Refresh

Send

Cancel