Oracle Transactional Business Intelligence

Products Banner

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

Received Response
412
Views
4
Comments

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

  •  

Answers

  • 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 ✭✭✭

    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
            '[email protected]'                        PARAMETER2, -- cc
            '[email protected]'                          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 [email protected] in the relevant table.

     

    Delivery configuration details are attached in the screenshot document.

    Regards,

    Rashmi

  • 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 ✭✭✭

    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.