Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dynamic delivery of Output formats in Email Scheduling using BIP

Received Response
42
Views
1
Comments
Srinivas Naidu
Srinivas Naidu Rank 1 - Community Starter
in Oracle Analytics Forum

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

  • Vani-R
    Vani-R Rank 4 - Community Specialist

    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.