This discussion is archived
4 Replies Latest reply: Jan 4, 2013 1:02 PM by Hussein Sawwan-Oracle RSS

ORA-29024: Certificate validation failure

User287063 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points