1 2 Previous Next 15 Replies Latest reply: Jan 4, 2013 3:55 PM by Hussein Sawwan-Oracle RSS

    XDO Delivery_Throwing an error in r12

    suresh.b
      Dear Team,

      We are having an issue in our R12 applications.When we send Separate Remittance Advice we are getting an error like...

      Loaded email attachment file prefix from DB: Message { Code = IBY_FD_EMAIL_ATT_PRE, Cause = Payment}
      Preparing for email delivery
      SMTP server host: null
      Email subject: Separate Remittance Advice: payment reference number - 6953

      We have done required set up in xdodelivery.cfg,but still getting the above can any one please suggest us on this.


      Our Instance Details are:
      O.S:Windows Server 2008(32 bit)
      Applications:R12.1.1
      Database:11.1.0.7


      Thanks,
      Suresh
        • 1. Re: XDO Delivery_Throwing an error in r12
          Helios-GunesEROL
          Hi;
          SMTP server host: null
          Why this is null?

          Regard
          Helios
          • 2. Re: XDO Delivery_Throwing an error in r12
            suresh.b
            Hi Helios,

            We have set this parameter (SMTP server host:) in xdodelivery.cfg file.Eventhough it is throwing the same error.

            Can you please suggest me on this.

            Thanks,
            Suresh
            • 3. Re: XDO Delivery_Throwing an error in r12
              Hussein Sawwan-Oracle
              Please see if (The Send Separate Remittance Advice Transmits To Invalid E-Mail Addresses [ID 1443132.1]) helps.

              Thanks,
              Hussein
              • 4. Re: XDO Delivery_Throwing an error in r12
                Srini Chavali-Oracle
                Pl confirm that you have completed the setups in this MOS Doc

                How to set up the Separate Remittance Advice to send emails [ID 944074.1]

                HTH
                Srini
                • 5. Re: XDO Delivery_Throwing an error in r12
                  Hussein Sawwan-Oracle
                  Please also see (R12: How to Setup Remittance Advice Email Notification for Suppliers [ID 1072399.1]).

                  Thanks,
                  Hussein
                  • 6. Re: XDO Delivery_Throwing an error in r12
                    suresh.b
                    Hi Hussein,

                    We have done all the settings those were mentioned in the above docs.Eventhough we are getting the same error.

                    Log file details are....

                    Loaded email subject from DB: Message { Code = IBY_FD_SRA_EMAIL_SUBJ, Cause = Separate Remittance Advice: payment reference number - 6954}
                    Loaded email send-from from DB: Message { Code = IBY_FD_SRA_EMAIL_FROM, Cause = account_payables@visioncorp.com}
                    Loaded email attachment file prefix from DB: Message { Code = IBY_FD_EMAIL_ATT_PRE, Cause = Payment}
                    Preparing for email delivery
                    SMTP server host: null
                    Email subject: Separate Remittance Advice: payment reference number - 6954

                    Content file name: Payment6954.html
                    Email send from: account_payables@visioncorp.com
                    before calling XDO req.setDocument()
                    before calling XDO req.submit()
                    oracle.apps.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[HOST]
                         at oracle.apps.xdo.delivery.AbstractDeliveryRequest.validateProperties(AbstractDeliveryRequest.java:1367)
                         at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1174)
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.doElectronicProcessing(SRAAndPayerNotif.java:860)
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:393)
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:197)
                         at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:48)
                         at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

                    oracle.apps.iby.exception.PSException: Error: an error occurred while calling XML Publisher delivery API.
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.doElectronicProcessing(SRAAndPayerNotif.java:873)
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:393)
                         at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:197)
                         at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:48)
                         at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

                    Error: an error occurred while calling XML Publisher delivery API.
                    An error occurred. Roll back any changes.
                    Done roll back changes.
                    Request completed in error.
                    ---------------------------------------------------------------------------
                    Start of log messages from FND_FILE
                    ---------------------------------------------------------------------------
                    ---------------------------------------------------------------------------
                    End of log messages from FND_FILE
                    ---------------------------------------------------------------------------


                    ---------------------------------------------------------------------------
                    Executing request completion options...


                    Finished executing request completion options.

                    ---------------------------------------------------------------------------
                    Concurrent request completed
                    Current system time is

                    ---------------------------------------------------------------------------



                    Please suggest us.


                    Thanks,
                    Suresh
                    • 7. Re: XDO Delivery_Throwing an error in r12
                      Hussein Sawwan-Oracle
                      Please see these docs.

                      Separate Remittance Advice Email Errors With Required Property Missing [ID 1093974.1]
                      Send Separate Remittance Advices Ends With Error "Required property missing" [ID 745900.1]
                      Send Separate Remittance Advices Errors Out If One Recipient Is Missing Email [ID 805534.1]

                      Thanks,
                      Hussein
                      • 8. Re: XDO Delivery_Throwing an error in r12
                        user11980564
                        Hi,

                        We have an issue with the remittance email notification not being sent to customer.

                        Can any one please advice how to track the status of email being sent in Oracle?

                        Thanks,
                        Sandeep.
                        • 9. Re: XDO Delivery_Throwing an error in r12
                          Hussein Sawwan-Oracle
                          user11980564 wrote:
                          Hi,

                          We have an issue with the remittance email notification not being sent to customer.

                          Can any one please advice how to track the status of email being sent in Oracle?

                          Thanks,
                          Sandeep.
                          Did you review the docs referenced above?

                          Any errors in the log files?

                          Thanks,
                          Hussein
                          • 10. Re: XDO Delivery_Throwing an error in r12
                            user11980564
                            Dear Hussein,

                            Thanks for the reply, I do not see any errors in the request logs.

                            We have below information from the request log. But customer says they have not received this email.

                            SMTP server host: null
                            Email subject: Separate Remittance Advice: payment reference number - 8432
                            Recipient: compinc@usa.com
                            Content file name: Payment8432.html
                            Email send from: ahapurchasing@aisinholdings.com
                            before calling XDO req.setDocument()
                            before calling XDO req.submit()
                            Sucessfully delivered separate remittance advice/payer notification.
                            Exit: iby.scheduler.SRAAndPayerNotif.doElectronicProcessing()

                            Is there any we to check the status of the email? if it has been sent successfully etc?

                            Thanks,
                            Sandeep.
                            • 11. Re: XDO Delivery_Throwing an error in r12
                              Hussein Sawwan-Oracle
                              Can you send emails from your Application and OS with no issues?
                              Is there any we to check the status of the email? if it has been sent successfully etc?
                              Please check the CM/Database/Workflow/OPP log files for any errors.

                              Thanks,
                              Hussein
                              • 12. Re: XDO Delivery_Throwing an error in r12
                                user11980564
                                Dear Hussein,

                                We have issue with few "payment reference number" and for others its working fine.

                                We have also check the SMTP server log where we did not receive this "payment reference number" related email to SMTP server to be sent.

                                Thanks,
                                Sandeep.
                                • 13. Re: XDO Delivery_Throwing an error in r12
                                  Hussein Sawwan-Oracle
                                  Hi Sandeep,
                                  We have issue with few "payment reference number" and for others its working fine.

                                  We have also check the SMTP server log where we did not receive this "payment reference number" related email to SMTP server to be sent.
                                  Please test those servers from the OS using (How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer For Sending Email Notifications [ID 753845.1]) and see if it works.

                                  Was this working before? If yes, any changes been done recently?

                                  Thanks,
                                  Hussein
                                  • 14. Re: XDO Delivery_Throwing an error in r12
                                    user11980564
                                    Dear Hussein,

                                    We were able to send emails successfully from SMTP servers. Any way I will check once again and confirm to you.

                                    FYI.. We have different SMTP servers configured for Workflow email notifications and for Remittance advice (xdodelievery.cfg).

                                    Now we have issue while sending email through IBY_FD_SRA_FORMAT module: Send Separate Remittance Advices. Where one request goes fine and other fails which are submitted on same date.

                                    We have checked OPP logs and found below error .

                                    [12/21/12 11:00:16 PM] [UNEXPECTED] [259842:RT16892991] oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST
                                    at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)
                                    at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
                                    at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

                                    But may not be related and related profile options are not set.

                                    Can you please advice more where could be the possible issue? why one request of Send Separate Remittance Advices is able to send email and the other fails.

                                    Thanks,
                                    Sandeep.
                                    1 2 Previous Next