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 :
Issue Root Cause :
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;