Dynamic delivery of Output formats in Email Scheduling using BIP — Oracle Analytics

Oracle Analytics Cloud and Server

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
31
Views
1
Comments

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.