4 Replies Latest reply: Jan 4, 2013 3:06 PM by User287063 RSS

    ORA-29024: Certificate validation failure

    User287063
      DB - 11.2.0.3 - O/S s309 z/Linux
      APPS - 12.1.2 - O/S - SLES 10sp3

      We have a custom program, parts of which are re-produced below

      +<<write_to_log(' Begin Fax transmissions for predraft notifications.');+
      write_to_log('apps.mclaneco.com/FaxManagementWeb/PDFFaxManagement?FNO=' ||
      cur.fax_number || '&' ||
      -- 2547717244 || '&' ||
      +'FR1=' || cur.to_name || '&' || 'TO1=' || cur.from_name || '&' || 'FLN=' ||+
      cur.file_name || '&' || 'CNM=' || cur.cust_name || '&' || 'SNM=' ||
      cur.bill_to_site);
      l_efax_servlet_draft := utl_http.request(+
      *'apps.xxxxxxxx.com/FaxManagementWeb/PDFFaxManagement?FNO=' ||*
      cur.fax_number || '&' ||
      -- 2547717244 || '&' ||
      +'FR1=' || cur.to_name || '&' || 'TO1=' || cur.from_name || '&' || 'FLN=' ||+
      cur.file_name || '&' || 'CNM=' || cur.cust_name || '&' || 'SNM=' ||
      cur.bill_to_site);
      fnd_file.put_line (fnd_file.log,'   Finished Making the Request.');
      +>>+

      The job ends in an error message as re-produced below

      +<<**Starts**20-DEC-2012 08:44:07+
      ORACLE error 29273 in FDPSTP
      Cause: FDPSTP failed due to ORA-29273: HTTP request failed
      ORA-06512: at "SYS.UTL_HTTP", line 1722+
      ORA-29024: Certificate validation failure+
      ORA-06512: at "XXxxx.XXxxxx_AR_STMT_PKG", line 99
      ORA-06512: at line 1 . The SQL sta ---------------------------------------------------------------------------++
      Start of log messages from FND_FILE ---------------------------------------------------------------------------+ >>+

      Where do I start looking for clues as to how to fix this?

      Our EBS install is NOT ssl enabled.

      Edited by: 864641 on Jan 4, 2013 12:30 PM
        • 1. Re: ORA-29024: Certificate validation failure
          Hussein Sawwan-Oracle
          The job ends in an error message as re-produced below

          +<<**Starts**20-DEC-2012 08:44:07+
          ORACLE error 29273 in FDPSTP
          Cause: FDPSTP failed due to ORA-29273: HTTP request failed
          ORA-06512: at "SYS.UTL_HTTP", line 1722+
          ORA-29024: Certificate validation failure+
          ORA-06512: at "XXxxx.XXxxxx_AR_STMT_PKG", line 99
          ORA-06512: at line 1 . The SQL sta ---------------------------------------------------------------------------++
          Start of log messages from FND_FILE ---------------------------------------------------------------------------+ >>+

          Where do I start looking for clues as to how to fix this?
          Our EBS install is NOT ssl enabled.
          Please see if these docs help.

          Troubleshooting ORA-29024:Certificate Validation Failure [ID 756978.1]
          ORA-29024: Certificate validation failure [ID 789320.1]

          Thanks,
          Hussein
          • 2. Re: ORA-29024: Certificate validation failure
            User287063
            Please see if these docs help.

            Troubleshooting ORA-29024:Certificate Validation Failure [ID 756978.1]
            ORA-29024: Certificate validation failure [ID 789320.1]

            Thanks,
            Hussein
            >
            Troubleshooting ORA-29024:Certificate Validation Failure [ID 756978.1]
            ORA-29024: Certificate validation failure [ID 789320.1]
            I've checked the first note prior to posting - (the second seems to be valid for an earlier version of the DB - we're on 11.2.0.3) -

            but I'm unable to figure out if the cert error refers to the apps.xxxxco.com site or the certificate on the EBS app tier?

            If the request is being made to utl_http.request('apps.xxxxxco.com/.......)', then ordinarily, the cert error would be on the apps.xxxxxco.com site - CORRECT?
            • 3. Re: ORA-29024: Certificate validation failure
              Hussein Sawwan-Oracle
              but I'm unable to figure out if the cert error refers to the apps.xxxxco.com site or the certificate on the EBS app tier?
              What is "apps.xxxxco.com site" site?
              If the request is being made to utl_http.request('apps.xxxxxco.com/.......)', then ordinarily, the cert error would be on the apps.xxxxxco.com site - CORRECT?
              Is this the URL of your application tier node?

              The error is confusing since you do not have SSL implemented.

              Thanks,
              Hussein
              • 4. Re: ORA-29024: Certificate validation failure
                User287063
                Hussein Sawwan wrote:
                but I'm unable to figure out if the cert error refers to the apps.xxxxco.com site or the certificate on the EBS app tier?
                What is "apps.xxxxco.com site" site?
                If the request is being made to utl_http.request('apps.xxxxxco.com/.......)', then ordinarily, the cert error would be on the apps.xxxxxco.com site - CORRECT?
                Is this the URL of your application tier node?

                The error is confusing since you do not have SSL implemented.

                Thanks,
                Hussein
                The apps.xxxxco.com site refers to the corporate web application server site

                This is NOT the URL of the application tier node. And YES - confusing to me as well since we are non SSL. I did not (in the beginning) see this as a problem that was caused by a certificate (or lack thereof) on the application tier node - and therefore told the APP developer guys to look more into the apps.xxxxco.com site.

                But i'm running around in circles trying to figure out where this all starts.