2 Replies Latest reply on Oct 27, 2017 5:39 AM by Dhanya-Oracle

    EBS 12.2 Oracle alerts work but output emailed from a concurrent request is failing

    Lori B.

      Hi all,

      We have an interesting situation. On our production EBS 12.2.6 environment the oracle alerts are working correctly and emailing as expected. But when we are submitting a  concurrent request and select EMAIL as the delievery option for concurrent request output, it is failing.  All of our lower env's are working for both types of email. The setup is the same on production.  All of our env's use ssl as well. I say this about ssl because the error makes you wonder if ssl or the mailer or some other thing is the issue.  I have an SR open but it is going nowhere fast.

      In summary:

      All I am doing is trying to send an Active users report to myself using the email delievery option in the application. Sendmail and mailx both work fine from the server. Oracle alerts send email correctly. I would appreciate any insight anyone might have! Thanks.

       

      Here is the error message:

       

      [10/23/17 10:15:26 AM] [10842:RT809993] Executing
      post-processing actions for request 809993.

      [10/23/17 10:15:26 AM] [10842:RT809993] CONC-OPP-DELIV BEGIN
      (REQID=809993)

      [10/23/17 10:15:26 AM] [UNEXPECTED] [10842:RT809993]
      javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException:
      PKIX path building failed:
      sun.security.provider.certpath.SunCertPathBuilderException: unable to find
      valid certification path to requested target

                      at
      sun.security.ssl.Alerts.getSSLException(Alerts.java:192)

                      at
      sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1916)

                      at
      sun.security.ssl.Handshaker.fatalSE(Handshaker.java:279)

                      at
      sun.security.ssl.Handshaker.fatalSE(Handshaker.java:273)

                      at
      sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1477)

                      at
      sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:213)

                      at
      sun.security.ssl.Handshaker.processLoop(Handshaker.java:969)

                      at
      sun.security.ssl.Handshaker.process_record(Handshaker.java:905)

                      at
      sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1035)

                      at
      sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1344)

                      at
      sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1371)

                      at
      sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1355)

                      at
      sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:559)

                      at
      sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)

                      at
      sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1343)

                      at
      sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:254)

                      at
      java.net.URL.openStream(URL.java:1048)

                      at
      oracle.apps.fnd.cp.util.RemoteFile.readURL(RemoteFile.java:311)

                      at
      oracle.apps.fnd.cp.util.RemoteFile.transferFile(RemoteFile.java:285)

                      at
      oracle.apps.fnd.cp.util.RemoteFile.transfer(RemoteFile.java:225)

                      at
      oracle.apps.fnd.cp.opp.DeliveryProcessor.fetchOutputFile(DeliveryProcessor.java:207)

                      at
      oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:99)

                      at
      oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185)

      Caused by: sun.security.validator.ValidatorException: PKIX path
      building failed: sun.security.provider.certpath.SunCertPathBuilderException:
      unable to find valid certification path to requested target

                      at
      sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:385)

                      at
      sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:292)

                      at
      sun.security.validator.Validator.validate(Validator.java:260)

                      at
      sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:326)

                      at
      sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:231)

                      at
      sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:126)

                      at
      sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1459)

                      ...
      18 more

      Caused by:
      sun.security.provider.certpath.SunCertPathBuilderException: unable to find
      valid certification path to requested target

                      at
      sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:196)

                      at
      java.security.cert.CertPathBuilder.build(CertPathBuilder.java:268)

                      at
      sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:380)

                      ...
      24 more

      [10/23/17 10:15:26 AM] [UNEXPECTED] [10842:RT809993]
      oracle.apps.fnd.cp.opp.PostProcessorException: Cannot find output file for
      request 809993

                      at
      oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:101)

                      at
      oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185)

      [10/23/17 10:15:26 AM] [10842:RT809993] Completed post-processing
      actions for request 809993.