12 Replies Latest reply on Mar 4, 2020 4:47 PM by RameshPatel

    XML Bursting Email not sending

    3472700

      Hi

       

      I have attempted the xml bursting for my oracle report. I have completed all setups. Placing the bursted output files in the server is working flawlessly. But when trying to send the mail with attachment, I couldn't. I have mentioned the from and to address in the bursting control xml file, the request also ends well and the bursting completed status report shows success, but I couldn't see any mail in the inbox or sent box since both addresses are mine.

       

      Please advise, if I have missed any setup for the email to be sent.

       

      Thanks !

        • 1. Re: XML Bursting Email not sending
          User910243567

          Can you change email address and recheck, Sometimes it might be firewall which might be preventing it from sending with an attachment.

           

          What version XML publisher are you using.?

          • 2. Re: XML Bursting Email not sending
            3472700

            Hi

            I have changed and tried with the different addresses and no result. The version is Oracle XML Publisher 5.6.3. Don't we have to provide any authentication for the mail to be sent ?

            • 3. Re: XML Bursting Email not sending
              Mohammed Ali A. Syed

              Hi,

               

              You should have correct value for the following profile options

               

              FND: SMTP Host

              FND: SMTP Port

               

              First try to run any simple report and in delivery options choose email -> Enter your email in from and to and see if you are receiving emails.

               

              Thanks,

              Mohammed Ali A. Syed

              • 4. Re: XML Bursting Email not sending
                3472700

                Yes Syed,

                 

                I tried the above suggestions, now the program runs fine and the

                Delivery status: 12

                Delivery message: Message has not been sent for following addresses by some reason

                 

                The server is fine and I want to know if the port no. 587 is fine ?

                Thanks !

                • 5. Re: XML Bursting Email not sending
                  Shaik

                  Hi

                  Get the port and host details from your network team.

                   

                  Regards

                  Shaik

                  • 6. Re: XML Bursting Email not sending
                    Mohammed Ali A. Syed

                    Hi,

                     

                    Please get them from your mail server admin.

                     

                    Port No: 587 could be right.

                     

                    If your mail server doesn't have SSL then it should be 25

                     

                    If your mail server is TSL then it should be 587

                     

                    If your mail server is SSL enabled then it should 465

                     

                     

                    Thanks,

                    Mohammed Ali A. Syed

                    • 7. Re: XML Bursting Email not sending
                      Bommi

                      Hi,

                       

                      I am not sure whether I am right or wrong. But, could you please try as below (THis is how we have done couple of weeks back and working without any issues)

                       

                      1. Develop the RDF Reports (Hope you are using RDF )

                      2. In RDF, under After Report trigger, call the bursting program as below

                      FUNCTION AfterReport RETURN BOOLEAN
                      IS
                           v_sub_req                      NUMBER;
                           v_cp_description               VARCHAR2(100);
                           v_req_id                       CONSTANT  NUMBER         := :P_CONC_REQUEST_ID; 
                      BEGIN
                               BEGIN
                                    v_sub_req := APPS.FND_REQUEST.SUBMIT_REQUEST('XDO',
                                                                                 'XDOBURSTREP',
                                                                                 NULL,
                                                                                 NULL,
                                                                                 FALSE,
                                                                                 'Y',
                                                                                 v_req_id,                                                         
                                                                                 'Y');
                                    COMMIT;
                                    IF v_sub_req <= 0
                                    THEN
                                         SRW.MESSAGE('206','Failed to submit Bursting XML Publisher Request for Request ID = '|| v_req_id);
                                    ELSE
                                         SRW.MESSAGE('207','Submitted Bursting XML Publisher Request Request ID = ' || v_sub_req);
                                    END IF;
                               EXCEPTION
                                  WHEN OTHERS THEN
                                       RAISE SRW.PROGRAM_ABORT;
                               END;
                        SRW.USER_EXIT('FND SRWEXIT');
                        RETURN (TRUE);
                      EXCEPTION
                            WHEN SRW.USER_EXIT_FAILURE
                            THEN
                               SRW.MESSAGE (1, 'Failed in AFTER REPORT TRIGGER');
                               RETURN (FALSE);
                            WHEN OTHERS
                            THEN
                               SRW.MESSAGE (1000, 'Failed in When Others' || SQLERRM); 
                      END;
                      

                       

                      3. Now, In XML Publisher Data Definition Template, attach the bursting control file with below details

                      <?xml version="1.0" encoding="UTF-8"?>
                      <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
                      <xapi:request select="/XX_POXPOSTD/LIST_G_1/G_1">
                      <xapi:delivery>
                      <xapi:email id="123" server="smtp.company.com" port="25" from="XX.DevOracleWF@company.com" reply-to="XX.DevOracleWF@company.com">
                      <xapi:message id="123" to="${CF_REQ_MAIL}" attachment="true" subject="XX - PO Purchase Order Detail Report">
                      Hi,
                      
                      
                      Please find the attachment for the list of Open PO's with outstanding amount details.
                      
                      
                      Thanks,
                      Purchasing Team
                      </xapi:message>
                      </xapi:email>
                      </xapi:delivery>
                      <xapi:document output="XX - PO Purchase Order Detail Report" output-type="excel" delivery="123">
                      <xapi:template type="rtf" location="xdo://XX.XX_POXPOSTD.en.US/?getSource=true">
                      </xapi:template>
                      </xapi:document>
                      </xapi:request>
                      </xapi:requestset>
                      

                       

                      Here, the server, port details you need to get it (generally from project admin team will help you)

                       

                      Hope this will helps you

                       

                      Mark my answer as helpful or correct if anyways helped you

                       

                       

                      Regards,

                      Bommi

                      • 8. Re: XML Bursting Email not sending
                        3472700

                        Thanks Bommi,

                         

                        Can you please advise if the report outputs can be placed in the client's desktop like if FileSystem delivery helps for that ?

                        • 9. Re: XML Bursting Email not sending
                          RajeshAlex

                          Try to send an email from the shell and see if the message is being delivered. Could be a relay issue /configuration issue with the mail server.

                          • 10. Re: XML Bursting Email not sending
                            RameshPatel

                            <xapi:email id="123" server="smtp.company.com" port="25"

                             

                            smtp.compan.com need to name of the mail server configuration eg. mail.company.com (using port 25)

                            • 11. Re: XML Bursting Email not sending
                              3472700

                              Thanks RameshPatel,

                               

                              I can receive mail by using the port = 25. Previously I tried with Port = 587. I believe the 587 is not supported here.

                               

                              Also, I only get a limited mail as the results, where as I have many records which are not received. Eg: The Results Customer:60, Received only 35.

                               

                              Please advise.

                               

                              Thanks

                              • 12. Re: XML Bursting Email not sending
                                RameshPatel

                                check the from address (XX.DevOracleWF@company.com) on the mail server to see if any got rejected due to invalid address.