Oracle Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics

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
41
Views
1
Comments
Srinivas Naidu
Srinivas Naidu Rank 1 - Community Starter
in Oracle Analytics

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.