After enabling SSL on the E-Business Suite Middle Tier, Some Functions are Failing With the Errors java.sql.SQLException ORA-29273 HTTP request failed, ORA-06512: at "SYS.UTL_HTTP" (Doc ID 1265016.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 03-April-2013***

Symptoms

After enabling SSL on the E-Business suite Middle tier, the following error occurs when trying to complete candidate registration in iRecruitment.

Error

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select nvl2(:1, irc_jps_generator.GenerateJPS(:2,:3), null) as Resume
,'Resume.htm' as FileName,
:4 as RESUME_STYLE
from dual

## Detail 0 ##
java.sql.SQLException: ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-28759: failure to open file
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-28759: failure to open file
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 409
ORA-06512: at "APPS.IRC_JPS_GENERATOR", line 423
ORA-06512: at line 1



Note:- The "java.sql.SQLException: ORA-29273: HTTP request failed" error can be reported by any E-Business suite application which calls "SYS.UTL_HTTP"


Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Enable SSL on the E-Business suite Middle tier following the instructions in

Note 376700.1 Using SSL with Oracle E-Business Suite Release 12

2. Chose option in iRecruitment site to register as new candidate.

3. Enter email,family name and password.

4. Chose the option to upload resume later.

5. Enter basic personal information.

6. Enter qualification and skills details.

7. Enter preferences.

8. Error is coming before resume template selection.

Business Impact

Due to this issue users are unable to proceed with candidate registration when going for auto generation of resume.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms