1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Sending pdf from rdf through pl/sql

Discussion in 'SQL PL/SQL' started by sneha.bharti, Jun 14, 2016.

  1. sneha.bharti

    sneha.bharti Active Member

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Hi All,

    Greetings of the day !
    I am working on oracle applications and database right now and have requirement of sending pdf from existing rdf to customers through Auto mail (Pl/Sql procedure).

    Please tell me the possibility of doing this and how can I achieve this.

    Thanks.
     
  2. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    I have used rdf report along with xml (bursting feature)publisher functionality to send email attachment (pdf file..think so).. ..let me know if you need details using that approach.

    Regards,
    Krishna rao
     
  3. sneha.bharti

    sneha.bharti Active Member

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Hi Krishna,

    Thank you so much for your response.
    Could you please enlighten me with that approach of yours.

    Thanks ,
    Sneha Bharti
     
  4. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    sent you my skypeid ..if interested..do follow up

    Thanks
    Krishna rao
     
  5. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    1) Capture this info in data model of the rdf report
    ,fnd_profile.value('FND_SMTP_HOST') smtp_host
    ,fnd_profile.value('FND_SMTP_PORT') smtp_port
    , rpad(TO_RECIPIENTS,240,' ') TO_EMAIL
    , rpad(CC_RECIPIENTS,240,' ') CC_EMAIL
    , rpad(BCC_RECIPIENTS,240,' ') BCC_EMAIL
    , :p_CONC_REQUEST_ID CP_CONC_REQUEST_ID
    2) Afterreport trigger submit the

    Submitting the XDOBURSTREP bursting program

    fnd_request.submit_request ('XDO'

    ,'XDOBURSTREP'

    ,''

    ,''

    ,FALSE

    ,'N'

    ,v_conc_req_id

    ,'Y'

    ,CHR(0)

    ,'','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','',''

    ,'','','','','','','','','','');

    hope this info helps

    Regards,
    Krishna rao