R12:AP:After Making Payment, a Mail to be Sent to Supplier by Triggering Separate Remittance Program. But it is Error Out by the Error 'com.sun.mail.util.MailConnectException: Couldn't connect to host, port: hybrid.formfactor.com, 1531; timeout -1;' (Doc ID 2669690.1)

Last updated on DECEMBER 27, 2022

Applies to:

Symptoms

After making payment, a mail should be sent to the supplier by triggering the Separate Remittance Advice Program. But it is error out by below error:

ERROR
-----------------------
IBY_FD_SRA_FORMAT: Send Separate Remittance Advices
+---------------------------------------------------------------------------+
SRAAndPayerNotif->runProgram():
Before calling OraPmt.init()
After calling OraPmt.init()
Enter: iby.scheduler.SRAAndPayerNotif.runSRA()
Param name: IBY_FD_SRA_INSTR_REF_NUM, value: xxxxx
Param name: IBY_FD_SRA_PMT_REF, value:
Param name: IBY_FD_SRA_PMT_REF, value:
Param name: IBY_FD_SRA_FMT_VS, value: IBY_PAY_REMIT_ADV
executing PAYMENTS_QUERY: SELECT payment_id, iby_fd_extract_gen_pvt.Get_sra_Attribute(payment_id, 1), payment_reference_number  FROM iby_payments_all WHERE payment_instruction_id IN (SELECT payment_instruction_id FROM  iby_pay_instructions_all WHERE payment_instruction_id =NVL(:1,payment_instruction_id) AND (remittance_advice_created_flag = 'N'  OR iby_fd_post_picp_progs_pvt.get_allow_multiple_sra_flag(payment_instruction_id) = 'Y'))  AND separate_remit_advice_req_flag = 'Y'  AND(payment_reference_number BETWEEN nvl(:2,   payment_reference_number) AND nvl(:3,   payment_reference_number))  AND payment_status IN ('INSTRUCTION_CREATED', 'READY_TO_REPRINT', 'SUBMITTED_FOR_PRINTING', 'FORMATTED',  'TRANSMITTED', 'ISSUED') order by payment_reference_number
Payment reference number: xxxx delivery method: EMAIL
Enter: iby.scheduler.SRAAndPayerNotif.doElectronicProcessing()

-

-

-

com.sun.mail.util.MailConnectException: Couldn't connect to host, port:XXXX.COM, 1531; timeout -1;
 nested exception is:
java.net.ConnectException: Connection timed out
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2054)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:697)
at javax.mail.Service.connect(Service.java:364)
at javax.mail.Service.connect(Service.java:245)
at javax.mail.Service.connect(Service.java:194)
at oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler.submitRequest(Unknown Source)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.doElectronicProcessing(SRAAndPayerNotif.java:899)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:410)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:210)
at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:60)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Caused by: java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:344)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:331)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:238)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2020)
... 11 more

oracle.apps.iby.exception.PSException: Error: an error occurred while calling XML Publisher delivery API.
at oracle.apps.iby.scheduler.SRAAndPayerNotif.doElectronicProcessing(SRAAndPayerNotif.java:961)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runSRA(SRAAndPayerNotif.java:410)
at oracle.apps.iby.scheduler.SRAAndPayerNotif.runProgram(SRAAndPayerNotif.java:210)
at oracle.apps.iby.scheduler.FDSeparateRemittanceAdvice.runProgram(FDSeparateRemittanceAdvice.java:60)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.