Dynamic delivery of Output formats in Email Scheduling using BIP

Question

Summary

Content

Is it possible to have Dynamic delivery of Output formats in Email Scheduling using BIP.

For Ex: I need a file name ABC_03022017 in the E-mail attachment as output while scheduling

Vani-R · Answer

Submit BI publisher report using pl/sql code using FND_REQUEST.SUBMIT_REQUEST call and call below code to call XML bursting

FND_REQUEST.SUBMIT_REQUEST

(application  => 'XDO',

program       => 'XDOBURSTREP',

description   => NULL,

start_time    => NULL,

sub_request   => FALSE,

argument1     => 'N',

argument2     => TO_CHAR(l_req_id)); -- request id of the report output CP

you also need to define bursting control file.