Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Emails not getting bursted, inspite of job success and delivery details show right info.

Received Response
1029
Views
4
Comments
User_MC37Q
User_MC37Q Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

Summary

Emails not getting bursted, inspite of job success and delivery details show right info.

Content

Hi,

 

I am using BI publisher to burst employee confirmation e-mails to corresponding employees.

currently, i am bursting it to a single id which is my email id and the same is updated in the person records in dev2 fusion hcm cloud instance. the job is successful. please find screenshots attached herewith. But, I am not getting the e-mails.

Please advise.

Regards,

Rashmi

  •  
Tagged:

Answers

  • Amritsen Behera-56873
    Amritsen Behera-56873 Rank 1 - Community Starter

    Hi Rashmi,

    Could you please share the bursting query as well?

    Also you need to check the email server configuration going to the below path :-

    OTBI Home page -> Administrator-> Manage BI Publisher-> Delivery -> Email

     

    Thanks and Regards,

    Amritsen Behera

     

     

  • User_MC37Q
    User_MC37Q Rank 3 - Community Apprentice

    Hi Amritsen,

    Thanks for the update. Please find bursting query below:

    =========================================

    SELECT  PERSON_NUMBER           KEY,
      'RTF'               TEMPLATE_FORMAT,
      'en-US'              LOCALE,
      'PDF'               OUTPUT_FORMAT,
      'EMAIL'              DEL_CHANNEL,
      'Employee Confirmation Letter'        OUTPUT_NAME,
            PEA.email_address                            PARAMETER1, -- to
            'rashmirao2@kpmg.com'                        PARAMETER2, -- cc
            'hr@fusiondev2.com'                          PARAMETER3, -- from
            'Employee Confirmation Letter'               PARAMETER4, -- subject
      'Hi, Congratulations on your confirmation !' PARAMETER5, -- message body
      'true'                  PARAMETER6 -- attchment true or false
    from
    FUSION.PER_ALL_PEOPLE_F PAPF
    ,FUSION.PER_EMAIL_ADDRESSES PEA
    WHERE PAPF.PERSON_ID = PEA.PERSON_ID(+)
    AND PAPF.primary_email_id =PEA.email_address_id(+)

    ===============================================

    PEA.email_address is also set as rashmirao2@kpmg.com in the relevant table.

     

    Delivery configuration details are attached in the screenshot document.

    Regards,

    Rashmi

  • Noelle Bartlam-Oracle
    Noelle Bartlam-Oracle Rank 5 - Community Champion

    HI Rashmi

    You might want to try enabling diagnostics when you schedule this and take a look at the resulting log.  Since the job is succeeding, it's doubtful that there will be an error, but worth checking.  You could also try scheduling a non-bursted job to send to email to test.  If both of those work and there is no evidence of error in bip, then you should turn to looking at the mail server logs for any errors/blocks on the mail server side.

     

    Noelle

  • User_MC37Q
    User_MC37Q Rank 3 - Community Apprentice

    Thanks Noelle, there was a firewall block on mail server. We are using an alternate email id and it works very well with the same code.