Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dynamic delivery of Output formats in Email Scheduling using BIP

Summary
Dynamic delivery of Output formats in Email Scheduling using BIP
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
Answers
-
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.
0